Open Order Quantity for open sales orders

[Former Member]

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.

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

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