How to extract OPENING DATE information in /SAPAPO/RRP3 to BW?

[Former Member]

Hi All,

I would like to extract OPENING DATE information in transaction code /SAPAPO/RRP3 to BW. Has anyone tried doing this before?

Thank you.

Regards,

Joy

[Former Member]

Hi Joy

We are using  /SAPAPO/EFPL_ORD_NET_GET this FM will give you the entire pegging relationship for any order in the live-cache. While extracting this information you get all the order details with all the required dates.

you need to paas the values to this FM as below.

I_SIMVERID   = active version 000

I_SIMSESSID = simsession ID you can create using FM /sapapo/RRP_SIMSESSION_CREATE

I_ORDERS_TAB= in this table,you need to pass the CHAR22 GUID of any order like planned/sales order/pur.req..

Thanks

Amol

[Former Member]

Hi Joy

I am not sure exactly what you meant by opening date. it may be availability date or start date?

The data in SNP/PPDS is in livecache and you have to use a FM like BAPI_MOSRVAPS_GETLIST2 to read the data from livecache. One way is to write a program that reads the data and spits out a flat file that you can load into BW.