Function module to get Delivery item data based on order number

[Former Member]

Hi experts,

I want to know the function module for getting delivery item data based on order number. i.e. for order

related billing i have the order numbers list. i want the delivery details for those orders.. but my select statement taking so much time .. For i want to know the function module for better performance.

select vbeln

posnr

matnr

lfimg

vgbel

vgpos

from lips

into table t_lips

for all entries in p_gt_fvkdfi

where vgbel = p_gt_fvkdfi-vbeln "(order number i.e. order related billing )

and vbtyv = 'H'.

Thanks in advance

M Prasanna

[Former Member]

Hi experts,

I want to know the function module for getting delivery item data based on order number. i.e. for order

related billing i have the order numbers list. i want the delivery details for those orders.. but my select statement taking so much time .. For i want to know the function module for better performance.

select vbeln

posnr

matnr

lfimg

vgbel

vgpos

from lips

into table t_lips

for all entries in p_gt_fvkdfi

where vgbel = p_gt_fvkdfi-vbeln "(order number i.e. order related billing )

and vbtyv = 'H'.

Thanks in advance

M Prasanna

[Former Member]

HI,

I think this FM SD_DELIVERY_ITEMS_RECEIVE will suffice your requirement.

Regards,

Mansi.

[Former Member]

Hi,

I have to export sales order data based on that i want delivery item details...........for that any function module available. if yes, please give the name........

Thanks in advance

M Prasanna

[Former Member]

ck50_salesorder_item_display

try this

cheers

s.janagar

[Former Member]

Hi

That is for Costing know.... my requirement is not satisfied.....Anything else.....

Thanks in advance

Edited by: M PRASANNA on Apr 28, 2009 10:53 AM

[Former Member]

Hi,

Check this FM 'SD_DELIVERY_ITEMS_RECEIVE'

and also check this FM '/VSO/R_GET_DELIVERY_ITEMS'

Regards,

Jyothi CH.

Edited by: Jyothi Chinnabathuni on Apr 28, 2009 2:06 PM

[Former Member]

Hi,

The above function module not satisfying my requirement, I will provide sales order numbers as input and i want to get the delivery item details........Reply soon.

Thanks in advance

M Prasanna

[Former Member]

I think FM SD_DELIVERY_ITEMS_RECEIVE

may help you.

Regards,

Chetan

[Former Member]

Hi

My problem solved Thanks to u all.

Regards

M Prasanna

[Former Member]

Hi,

How you solve this problem please suggest. My requirement is same like this.

Thanks in advance.

Regards.

[Former Member]

Hi,

Use FM - RV_ORDER_FLOW_INFORMATION.

You can input SO no. and u will get total flow for that SO.

i.e. SO No. -> Delivery No -> Invoice No.

Regards

[Former Member]

hi,

Thnks.

But what i have to give in follwing parametrs there is no values of inputting sale order.Please suggest.

AUFBEREITUNG 2

BELEGTYP

COMWA

NACHFOLGER X

N_STUFEN 50

VORGAENGER X

V_STUFEN 50

Regards.

[Former Member]

Ok got the values.

Thnks a lot!

[Former Member]

HI

     I Am Also Wanted To Track The Doc. Flow. I Added Docment Num And Item Num In COMWA Structure It Works Fine.

[Former Member]

Hi,

Check for BAPI_GOODSMVT_GETDETAIL.