Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Thanks

Ignasi

Not what you were looking for? View more on this topic or Ask a question