Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

APO DP-Different univarate forecasts --> how to obtain forecast error MAD ?

Hello all,

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.

-


Forecast1

-


-


MAD1

-


-


Forecast2

-


-


MAD2

-


Forecast_n

MAD_n

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.

Question:

- 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

Former Member
Former Member replied

Hi Dominik,

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question