Total Purchasing dollars per Vendor
I would like to get a query where only for the Vendors which have "ERS" -Evaluated Receipt Settlement type slected , I want to get the total dollars purchased from that vendor.
Which table gives the total Purchasing dollars per Vendor?
Friedrich Glugsberger replied
Here is a quick approach using Excel:
First extract vendors marked for ERS by using SE16 - table lookup for table LFM1. Add field XERSY (flagged for ERS) to the selection fields and use the AVL list as output option. Once you have the list, download it into Excel.
Now run transaction MC$4, which will access information structure S012 (Purchasing Information System) and run the report by selecting a range of periods. There are a bunch of key figures available, from the original PO $ to invoiced $. Once you have selected the key figure/key figures you need, download the report into Excel.
Now use the vblookup function in Excel, using the downloaded ERS vendors as reference to find the desired key figures from the second downloaded table.