Open Sales Order Quantity

[Former Member]

Hi,

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

Thanks.

[Former Member]

Hi,

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

Thanks.

[vinod_vemuru2]

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.

[Former Member]

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.