cancel
Showing results for 
Search instead for 
Did you mean: 

Extracting Data from Product View in APO to BW

Former Member
0 Kudos

Hi,

We are trying to extract the data shown in Product View in APO in BW for reporting. We researched on the existing Business Content the closest Data Sources we got were : 0APO_PPDS_ORDER_01, 0APO_PPDS_PROD_CUST_01.

However these Data Sources not bringing Stock, Sales order, Forecast information we see on Product view. We were weighing our options and wondering if anyone else had similar requirement. We also need the pegging information associated with this deamnd.

Thanks in advance,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Srinivas,

Thanks for answering my question. We understand there are some BAPIs to extract this data and load into custom tables. We want to use the BAPIs as a last resort and were trying to research the BW Business Content if this data is available in any predefined datasources/cubes we can activate.

Thanks,

srinivas_krishnamoorthy
Active Contributor
0 Kudos

there are none to my knowledge. In IMG under PPDS Global settings, you can see that PPDS works in SNP planning area. So you can only leverage the SNP extractors to view the data through backup infocube. Product view is just a window to LC data present in order objects format.

Answers (1)

Answers (1)

srinivas_krishnamoorthy
Active Contributor
0 Kudos

Did you try using BAPI BAPI_PPDSSRVAPS_GET_IO_NODES and BAPI_PPDSSRVAPS_REQ_IO_NODES ?

For sales order BAPI_SLSRVAPS_GETLIST2

PIR --> BAPI_PIRSRVAPS_GETLIST

If you dont care of times of the orders, then you should be able to retrieve information at granularity of a day using standard SNP planning area backup. Use that for BW reporting.