what is table name and field name for balance value in sales order in sap

[former_member747149]

hi i want to make FS for sales order status report .and i want balance value in report please tell me about table field name of balance value.

[Former Member]

You can get the Sales Order status in Table VBUK & VBUP at Item Level.

To achieve the Open Value , first consider the Open Quantity.Refer VBAP - KWMENG (Order Quantity) , then from LIPS - LFIMG (Delivery Quantity) , you will get the Open Quantity & then accordingly you will get the open Value.

Best Regards,

Ankur