How to find delivery date of SO using FM?

[Former Member]

Hi Experts,

How do we find out the 'SO Delivery' date using a FM.

I have SO number, looking a way to get SO details including Delivery Date.

I do not have GUID of SO but SO number only which returns from pegging details.

Thanks..

SD

[rupesh_brahmankar3]

Dear,

Sales order are created in ECC (R/3) and cf to APO so better extract the delivery date in ECC.

Else try the BAPI_SLSRVAPS_GETLIST or /sapapo/dm_ordid_get_order. If you have order number /GUID of that number from table /SAPAPO/VS_SDSHP.

Also refer this link,

http://scn.sap.com/thread/1938849

Regards,

R.Brahmankar

[rajkj]

Hi Shibu,

You can try the BAPI - BAPI_SLSRVAPS_GETLIST2 - to retrieve a SO based on the order number. The table parameter 'ORDER_SELECTION' allows you to specify a single or multiple order numbers.

Thanks,
Rajesh

[Former Member]

Hi Rajesh,

Thanks for the answer but i couldn't find a "Delivery date" field in the BAPI. I need to populate this value in a report. Looking for a FM which return Delivery Date.

Thanks..

Shibu

[rajkj]

Hi Shibu,

We won't get data directly from the livecache. It is required to get first the order ids (internal to APO) and then, pass them to liveCache again to read the order.

1. The given BAPI will return the order ids based on order numbers

2. Use another FM /SAPAPO/OM_ORDER_GET_DATA to get the sales order's header data. The table parameter type /SAPAPO/OM_ORDER_EXT_STR gives you the requested time stamp (START_FIRST_ACT i.e. /SAPAPO/OM_START_FIRST_ACT).

Probably, the following livecache t.codes helpful to you.

a. /sapapo/om16 - data browser - gives you the order key or id

b. /sapapo/om19 - Live Cache Browser - gives you the order

Thanks,
Rajesh

Updated to correct the function module and field name.