cancel
Showing results for 
Search instead for 
Did you mean: 

Sales Order Open Quantity

Former Member
0 Kudos
6,371

Guys,

I want to know the open quantity(i.e. from which table it comes) for sales order as it is shown in VL03n, when we open any delivery related to the sales order and go to VL03N, we see open quantity.

In case you have worked on it. Please let me know

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

open qty = delivery qty - order qty

delivery qty - lips-lfimg

order qty - vbap-kwmeng

Former Member
0 Kudos

open qty = delivery qty - order qty will return -ve quantity.. i think its vice versa may solve the prob.

Thanks

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks

Former Member
0 Kudos

LIKP Delivery Header Data

LIPS Delivery: Item data

VBLK SD Document: Delivery Note Header

VEPVG Delivery Due Index

VBBE Sales Requirements: Individual Records

the above tables will give the follow of your field

reward points if it is usedfull ....

Girish

Former Member
0 Kudos

Hi pankaj,

The open quantity is not stored in the database .

Reason : New deliveries may be created based on the SO & then the open qty chnges --> redundant data

to get the open quantity get the total qty in the SO from VBAP

and subtract the Total delievred qty from LIPS/LIKP

This will give your open qty

Hope you find it useful

regards,

Gaurav