topic Re: Open Order in Application Development and Automation Discussions

Open Order

Former Member — Sat, 05 May 2007 15:20:43 GMT

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

Re: Open Order

Former Member — Sat, 05 May 2007 15:24:46 GMT

hi Mallika,

check the table VBUK field GBSTK.

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

Regards,

Santosh

Re: Open Order

Former Member — Sat, 05 May 2007 17:41:31 GMT

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