Does exist any report that combines sales orders related to purchasing orders?
One of my customers wants to find a report to shows at the same time sales order documents and purchasing orders created in relation to sales order by MRP .
I am exploring to create a QUERY in SQ01/SQ02 and SQ03 but it seems a complex issue.
The business scenrio is like this.
Firtst, my customer enters sales orders (one item only) and purchasing requisiitions are created by MRP for each one of the sales orders.
Second , purchasing orders are created for each purchasing requisition (one item only) .
My customer maintains an Excel sheet to show relationships between sales orders and purchasing orders, but it needs maintenance. He also includes billing information in the same excel.
I am trying to create a query inSQ01/SQ02 and SQ03 but I am stuck with a few problems:
1) which tables should include the query?
VBAK (Sales Document :Header)
VBAP (Sales Document : Item Info)
VBFA Sales Document Flow)
VBRP (Billing: Item Data)
EKKO Purchasing Document Header
EKPO Purchasing Document Item
LIPS ( SHIPPING )
2) relations between this tables
Can some body give some guidelines?