I have a customer that wants a report that lists POs by Plant, Material, and Vendor that are outstanding. Meaning that part of the order has been received, but the order was not complete. I need to create a report that lists P.O.s by plant, vendor, and material with the corresponding PO Quantity (ordered) , the quantity delivered (received), and the difference between ordered and received. I turned on the 0PUR_C01 cube and loaded it successfully. I have been to the link below, but I still have a few questions.
[http://help.sap.com/saphelp_nw70/helpdata/EN/c5/a26f37eb997866e10000009b38f8cf/frameset.htm]
Am I using the right infocube to get this information?
I see alot of quantity key figures, but I want to make sure I use the correct ones.
What is the correct key figure to use for the number of items ordered?
What is the correct key figure to use for the actual number of items delivered?
Is there a key figure for the variance between ordered and received? If not, I can make a formula, but it never hurts to have something to validate against.