APO DP-Different univarate forecasts --> how to obtain forecast error MAD ?
I have a question regarding 'forecast errors' when a univariate forecast was executed.
The requirement is:
I have a planning book/data view with 5 keyfigures for forecast 1 to 5 and 5 keyfigures for MAD 1 to 5.
The idea is to calculate 5 different forecasts and evaluate them (for example with MAD).
One out of the 5 forecasts will be copied then to another keyfigure ( = "Statistical forecast").
In the 'Interactive Demand Planning' I push the button to execute 'univariate forecast'.
I let forecast create for keyfigure "Forecast1" based on historical data.
--> There I can find a tab "Forecast Errors" which provides me with the MAD-value.
- Is there a possibility to take the MAD-value out of that "Forecast Errors tab" and put it in the keyfigure MAD1?
When I have then every MAD-value from the respective forecast (1 to 5) in the dataview I can use a macro to manually or automatically choose which one will be copied to "Statistical Forecast".
I hope I was able to explain what the requirement is and hopefully somebody has an idea.
Thank you very much in advance.
Edited by: Dominik Ritter on Feb 9, 2009 5:46 PM
I haven't done this in my experience but I know how to do it.
Here is how you can try:
Table: /SAPAPO/FCSTHEAD gives you the header data of forecast results. Take PROPID from this table and use table /SAPAPO/FCSTACCU to get the MAD value and populate the value using the BAPI_PBSRVAPS_CHANGEKEYFIGVAL