Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Feb 05, 2010 at 01:05 PM

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

    thanks

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Feb 05, 2010 at 10:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 06, 2010 at 01:34 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded