Question:
I have a question regarding a query provided by Standard Business Content. The query in question is Order Values 0PUR_C01_Q0015 from the 0PUR_C01 Purchasing Data Cube. I’ve checked the documentation at help.sap.com and also searched this site, but I haven’t found any clarification.
This query reports the “Order Values” and the “PO Quantity”, I’ve added the “Goods Receipt Value” and the “Actual Goods Receipt Quantity” at the request of our users. When the query is executed, a report parameter selection box is displayed. We select a months worth of data.
My concern is this:
If we run the report for April, all the PO’s that were entered (keyed into the system) in April are reported, even if some of the PO’s don’t have a requested delivery date until May.
Our users want the report to display the values for the PO’s that are due in April and that have actually been goods receipted in April.
Can someone verify that my concern is valid? And if it is…what should I do? Is there an easy way to modify the way the date selection occurs?
Thanks,
Sara
Answer:
What is Calender Day based off of?
Is it the posting date, goods issue date, delivery date, etc....?
If you know what date the calender date is based off of, then you can determine if your concern is correct.
If your concern is correct, then you would need to add Good Reciept date to your cube so that users can select only those PO's which have a goods reciept date within the month they want.
- Stephen
_________________
As a rule I don't answer Questions in PM.
(this is not to be a d**k, but it is to allow everyone to benefit from information. Not just one person.) Ask a question in the forum and I will answer it if I can.
Answer:
Thank you for pointing me in the right direction.
Unfortunately for me, the values that are being reported are based on "the order date when a purchase order is created or changed" (as quoted from help.sap.com). So...my concern is correct.
I'm off to find a solution!
Thanks again,
Sara
Answer:
hello.
am just wondering if you know what table can i find the goods receipted date, because i belive that schedule delivery date is from table EKET thanks!