Tables to store Forecast in APO

[former_member202214]

Dear All

we need to pull the Forecast data in third party application. we need tables in which the forecast data is stored in table.

I am not APO expert or APO user, but want to pull forecast data from APO for my application.

APO consultant told me that, their data is stored in Planning Book, then how one should pull data from planning book

Regards

Saurabh

[Former Member]

Hi,

As others mentioned, you can use a BW cube or a BAPI to extract the data. If you extract the data into BW cube, there is a standard functionality called OPENHUB in BW that lets you extract the data from BW cube to another db table or a file. Your BW counter part can help you with that.

[Former Member]

Hi Visu

Can we down load data from DP planning area by writing some queries in supply chain cock pit.

Thanks and regards

Stephen

[somnath_manna]

You can also use BAPI_PBSRVAPS_GETDETAIL2 to extract Forecast Data from APO Demand Planning module. Make sure you know the Planning Book / Data View combination as well as the Planning Version and Selection_ID which is the characteristic value combinations for which data needs to be extracted.

Please note unlike R/3 most transaction data in APO is not stored in tables but gets stored in liveCache. BAPIs or other BW extraction tools (as mentioned by Virendra) are the best way to extract transaction data from APO.

somnath

[Former Member]

Hi,

As per business scenario,Once forecast done then they will take the back up fron the planning area.

Normally in APO data is stored at live cache level at internal table so you can't extract the dat fron APO.

Most of the cases they will store the data at BW infocube and then they will manupulate the data from BW cube.

So please create the BW cube and store the data in BW cube and get it from cube,BW cube is inbuilt functinality of APO.

Create Datasource from planning area and create BW cube and assign the correct sorce system.

Regards,

Prabhu

[Former Member]

hI saurabh :

You have to get help from you BW or APO team consulatnt to do this . Actually data is stired in Live cache at Planning area level . Planning book is a subset of planning area .

Data can be extracted from planning area n transaction /SAPAPO/MSDP_ADMIN > Extras > Data Extraction Tool and Click on the Data Backup button.

But you still need to create the Export DataSource, Infosource, Update Rules and Infopackage for carrying out data extraction from the Planning Area to this Infocube. you can also get data to any legacty system by creating mapping & rules . Any BW/DP consultant can help you