topic Re: difference between open quantity and delivery quantity in Application Development and Automation Discussions

difference between open quantity and delivery quantity

Former Member — Wed, 16 Nov 2005 09:31:28 GMT

Hi all,

Please anybody explain me the difference between open quantity and delivery quantity My question is both are same in the value or different I need to report these 2 fields based on date.

open quantity is available in table vbbe

delivery quantity available in table lips.

for open quantity i have one select statement.

for delivery quantity i have another select statement.

i want to club these 2 fields into a single report.

please clarify my doubt.

regards

chandu

Re: difference between open quantity and delivery quantity

Former Member — Wed, 16 Nov 2005 09:37:42 GMT

Hi,

Open quantity is nothing but the quantity which we have at the DAY starts.

Delivered quantity means which was delivered on that DAY.

So Opening qty - Delivered qty = Closing qty for a DAY.

Again this Closing qty will be the Opening qty for next DAY.

*********

I think based on POSNR u need to club both the quantity in single report.

select vbeln posnr matnr omeng mbdat into itab from VBBE where....

select vbeln posnr matnr lfimg mbdat into itab1 from lips where....

loop at itab.

read table itab1 with key....

move:....to itab2.

endloop.

*********************

Thanks.

I hope this will help you.

Message was edited by: Deepak333 k

Re: difference between open quantity and delivery quantity

Former Member — Wed, 16 Nov 2005 09:41:43 GMT

Hi,

Open Qty is the one in which the Goods Issue is not yet done. So you can make a Goods Issue on what ever the Qty you pick up from the Open Qty.

The tables you need are LIKP : Delivery header data

LIPS : Delivery Item data

VBBE

So you need to join these tables by choosing a common key field among them.

So that you can retrieve the data.

If you dont find any common key field in these 2 tables LIPS & VBBE then try to link the same with any other table like LIKP.

Re: difference between open quantity and delivery quantity

Former Member — Wed, 16 Nov 2005 09:55:32 GMT

Hi,

Sample example...........

select vbeln posnr matnr omeng mbdat into itab from VBBE where....

select vbeln posnr matnr lfimg mbdat into itab1 from lips where....

loop at itab.

read table itab1 with key....

move:....to itab2.

endloop.

Thanks.