topic Re: Open Sales Order Quantity in Application Development and Automation Discussions

Open Sales Order Quantity

Former Member — Sun, 16 Mar 2008 09:29:36 GMT

Hi,

Does anyone know what table & field is the open sales order quantity stored?

Thanks.

Re: Open Sales Order Quantity

vinod_vemuru2 — Sun, 16 Mar 2008 12:42:22 GMT

Hi Marc,

U can get the open order quantity like this.

First go to VBFA table. Give sales order number, item and document category as J(for delivery) in the fields VBELV(Preceding sales and distribution document), POSNV(Preceding item of an SD document), VBTYP_N(Document category of subsequent document) respectively. If an entry exist then that means the order has subsequent document created(Delivery in this case). If not then that order is open.

if it is open order then u can get the quantity from

VBAP-KWMENG.

Here subsequent document to the order depends on customization of ur system. In general subsequent to order will be delivery. But there is a possibility to have other than delivery as subsequent to order. So contact ur functional for more inputs on this.

Thanks,

Vinod.

Re: Open Sales Order Quantity

Former Member — Tue, 21 Jan 2020 13:31:53 GMT

the quantity from VBAP-KWMENG doesn't get updated or adjusted when there's partial delivery quantity being delivered and there's still remaining/balance/open quantity yet to be fulfilled against the SO (Sales Order).

Hence, VBAP-KWMENG is not very useful. Correct me if i'm wrong as i've tried it hands-on on the training system.