Skip to Content
avatar image
Former Member

Open Order Quantity for open sales orders

Is there a standard SAP Report that gives the open order quantity for every open sales order. "Open" is defined as any order quantity that has not shipped. Delivery creation is not the same as shipment. VA05 Report does not contain enough information to calculate the open order quantity for an ERP-based backlog report.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 18, 2010 at 03:01 AM

    Try VA05 schedule lines standar variant...include status fields and both ordered qty and confirmed qty. In SAP standard system order status, status A means open orders fully (Nothing shipped, everything opened). Status B means in process orders (Partially processed - shipped). Status C means complete orders (Nothing opened). As there is no delivered qty in VA05, you need to download to excel the file and calculate the difference between both qty fields for each A and B status. That is a way to get the missing qty to be delivered or open qty as you stated.

    Hope it helps.

    Jorge Fernandez

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 17, 2010 at 11:05 PM

    I am not sure of standard SAP report. But if you can try you can do a query . Please try T Code SQVI for tables VBBE / LIKP & LIPS, and get the details.

    Hope this helps

    Sai

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 18, 2010 at 03:37 AM

    Hi Steve,

    You can do one thing, 1st go to VA05 take the open orders and then put these order in table VBEP. There you can get the idea how much you have delivered and how much are left.

    Regards,

    MT

    Add comment
    10|10000 characters needed characters exceeded