Open Order

[Former Member]

hi experts i want to know the

Open Sales Order details for the combination of

company code and sales organization.

how to find out

the related tables and the fields to be used

[Former Member]

hi Mallika,

check the table VBUK field GBSTK.

If VBUK-GBSTK NE 'C' its open sales order

Regards,

Santosh

[Former Member]

Hi

Open sales order means , if you ordered 20 qty then if that 10 items are delivered

and other 10 are yet to be delivered.

means if the Order qty = Delivered qty that order is closed and if it is not equal then it is open order.

So take the Sales orders data from VBAK, and VBAP tables with the item Qty (VBAP-KWMENG).

then fetch the related delivery details from LIKP and LIPS using the link LIPS-VGBEL = VBAP-VBELN and LIPS-VGPOS = VBAP-POSNR along with the Delivery qty (LFIMG)

for each Order item equate the Order qty and Delivery qty( KWMENG and LFIMG)

if they are not equal those are all OPEN ORDERS.

Reward points if useful

regards

Anji