how to cumulate in transit quantites in PO

[Former Member]

Hi Experts,

In my requirement they asked to me do

In Transit Qty:

Quantity in transit. Extract quantity (LIPS-LFIMG), Delivery (VBELN), material type (LIPS-

MTART) eq u201CZSPTu201D from LIPS and delivery type eq u201CLRu201D (LIKP-LFART) and good receipt not

happened (WBSTA) eq u201CAu201D from table VBUP. Cumulate all in transit quantities

Please help me how to do this logic and how to cumulate i didnt understand based on what and how i have to cumulate intransit quantities.

Thanks,

Neelima

[former_member156446]

write a select using VBFA has sales doc number delivery number.... use that in LIPS and LIKP join VBUP where (WBSTA) eq u201CAu201D .

[Former Member]

Hi,

Actually i have written the select query but i dont know how to cumulate the quantities.

Please help me regarding this.

Thanks,

Neelima

[former_member156446]

lets see the select code..