We have a requirement to extract fixed cells information from APO demand planning books to a custom table. Want to know where is the fixed cell information stored in APO tables. Are there any standard BAPIs/Function modules to extract the same
Can you please elaborate your issue in more with the screenshot if you have..There is a BAPI to read data from DP Planning Book which is stored in Livecache not in any database table.
@Saurabh - Thanks for your response. The issue that I am facing is I want to know the which cells ( which time period ) are fixed in a given planning book. Could you please tell me the BAPI name you are referring to
BAPI name is BAPI_PBSRVAPS_GETDETAIL2 which will give you the values of FIXING_INFO in table parameter KEY_FIGURE_VALUE, If the particular cell is Fixed then it will give value as '1' in the output for that time period (PERIOD_BEGIN to PERIOD_END).Possible values in the filed Fixing Info are as below.
No Fixing Exists
1
Some Fixings Exist
2
All structurally aggregated buckets are fixed
3
All time-based aggregated buckets of this level are fixed
4
All structurally and all time-based aggr. buckets are fixed
I hope this is helpful information for your issue..
READ_OPTIONS input parameter is optional.Possible values are (Yes = 'X', No = ' '), which you can skip. For Date from and Date To, you can refer a documentation provided with this BAPI.
Example for Date_from and Date_to as per documentation.
Time period type calendar day: 20010120 for January 20 2001
Time period type calendar week: 30.2002 for the 30th calendar week of the year 2002
Time period type calendar month: 10.2002 for October 2002
Time period type calendar year: 2002 for the year 2002
Also, you can provide PLANNINGBOOK, DATA_VIEW, PLANNING_VERSION,Group By, KEY_FIGURE_SELECTION as an input to this BAPI to get the desired output.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.