Join MARA-MATNR to SALES ORDER and find ONLY open sales orders?

[Former Member]

I want to join selected MARA-MATNR number to find ONLY the open Sales Orders. VBAP does not identify the status of the order line...

If I have one MARA-MATNR and join to VBAP ot VBAP-VAPMA I may find thousands of entries there. Then I have to join to VBUP to find the Status of the sales order line.

How can I do this join in one step?

Thanks Bernard

[Lakshmipathi · Accepted solution]

For information, Table VBBE will show material wise, open sale orders.

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Good morning Mr G. Lakshmipathi, The Table VBBE contains 2 lines for each material. I hacew checked the field "Open Quantity" VBBE-OMENG but just because is ZERO does not mean there is no longer a requirement.

Thanks

Bernard

[Former Member]

In Table VBBE there generally 2 lines for every Sales Order line. Just because the field Open Quantity VBBE-OMENG is zero, does NOT mean the requirement has been satisfird.

[Former Member]

Hi,

For joining diffrent tables you have to create LOGICAL DATABASE,

and on this logical database you can write ABAP query and execute report.

Kapil