on 02-09-2009 4:43 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Visu,
thank you very much for your answer!
I will check your solution with a developer (I do not develop).
As I understand I can then use this in an BADI/User exit macro.
Another strange thing is:
When I use SE16 with table /SAPAPO/FCSTACCU and let me list all the content --> I copy PROPID from this table and want to use it explicitly in the selection screen of SE16 to show me the one entry --> it fails because in some way the long key (PROPID) is not recognized.
(Example: IOjC29Eu0JxX0800r00G60)
Thanks and Best Regards
Dominik
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.