APO Tables relationship for shipment and Sales order

[Former Member]

Hello Every1,

Does any1 know APO tables for link between Sales document and Shippment created in APO

for sales & Delivery document I get the table /SAPAPO/VS_SDSHP

Now I want to link the Order Number from Connected OLTP System & Order Item from table /SAPAPO/VS_SDSHP to the shipmet

Shipment tables are

/SAPAPO/VS_SHPA

/SAPAPO/VS_LCMAP

Still I am not able to link these tables through any of fields.

Actual requirement is to create Report which maps Sales order from ERP to the shipments in APO.

Kindly let me know if any1 know how to identify relationship between these tables,.

Thanks & Regards,

Narendra.

[Former Member]

Hi Narendra,

I did not find any tables where these linkage is stored.I guess it is stored in live-cache not in any table/view.However, you can try to read the "Order Number from Connected OLTP System" using function module /sapapo/om_order_get_data (pass ORDER GUID from table /SAPAPO/VS_SDSHP ) using which you will get the linkage in output/input parameter table if it is pegged with any shipment no.you have to create SIMSESSION ID using FM /sapapo/rrp_simsession_create and pass this to above mentioned FM.

hope this helps.

Regards

Saurabh