We want to post regular acquisitions from appr. 200 vendors each month (amounts each month are different). We need to post different vendors to different cost centers, segments and other assignment elements/objects. I suppose that we need to use a batch input by importing a MS Excel spreadsheet, because software where we are tracking those payables makes export just into Excel. In SAP we have separate Vendors Master Data for all 200 vendors. Please help me to create batch input program for this monthly batch postings. How to define SAP field correspondence with Excel cells, and etc.?
(P.S. Im quite new in batch input functionalities )