Query linking Sales Order, Purchase Order & Delivery Doc

[Former Member]

Hi, can someone help me create a report that shows Sales Order No, Sales Price, Purchase Order Num, Purchase Orde Price, Purchase Date, Delivery Doc Num. This is the relationship map:

[former_member604104]

Did this ever get answered. Rizki's link did not actually solve this. It only gave you what the link was between the delivery doc and sales order's.

The original question was how to get "Purchase Order Num", "Purchase Orde Price", I am wondering the same thing. There seems to be no unique keys that connect the two in a full proof way. It almost looks like they use certain links along with an internal algorithym of FIFO (First in First out.)

[former_member375912]

Hi,

I gave you a hint to solve this problem by answering your previous question.

Please check this thread :

https://answers.sap.com/questions/138252/index.html

Hope this helps 🙂

Regards,

Rizki