Negative forecast

[Former Member]

Hi Experts,

I am on SCM 4.0, Is there way to stop the negative forecast.

I want all my negative forecast set to Zero.

Thanks,

Sunil

[Former Member]

Hi Sunil,

If you are releasing the forecast from DP to SNP then use the BADI definition '/SAPAPO/SDP_RELDATA' to change all the negative forecast to Zero.

Regards,

Siva.

[Former Member]

Hi Valavan/ Siva Prakash,

Thanks for your reply,

Valavaran - I am running Batch models to generate the forecast. and the forecast profile is 52.

Siva Prakash, My requirement is to to Zero'out in DP.

Thanks,

Sunil

[srinivas_krishnamoorthy]

Why dont you use a macro to do that ? Have a macro that reads any negative quantity and zeroes it out. You may want to use a seperate key figure for what you finally release to SNP.

[Former Member]

Hi Srinivas,

Thanks for your reply,

One thing we noticed in our monhly planing cycle for forecast generation is these macros execution takes lot of memory and time in back round and causing batch jobs to fail.

Do we have any other alternative to macro.

Thanks,

Sunil

[Former Member]

Hi Srinivas,

I am on SCM4.0,

Could please tell the detail steps involved in building the macro to Zero out the negative Values.

Thanks In Advance.

Thanks,

Sunil

[srinivas_krishnamoorthy]

Check out

http://help.sap.com/saphelp_scm40/helpdata/en/1d/310eadd0ee11d4b2e40050da385632/frameset.htm

You can have a conditional structure like below under step

If

FCST_KEYFIGURE

< 0

THEN

FCST_KEYFIGURE

= 0

The macro can run after the negative quantities are generated as a follow-up step.

If you are a beginner in macro, I would recommend you to thoroughly read the link I have given

[Former Member]

Hi Sunil - Have you tried running the macros as separate steps in your batch job and splitting your data by selection id's? One alternative is to create an ABAP which could manage the data/memory within the code.

Regards

Andy

[Former Member]

Hi Andy,

Thanks for your reply.

I tried to run the macro as separate Step in Background job with smaller selections.

Results are not saving and macro job log shows message saying "The data is not saved".

Could you please advise why in background job it is not saving the data and negative values still remains. But when i execute direcly in interactive planning I am abale to save the data.

Thanks in Advance.

sunil

[srinivas_krishnamoorthy]

Sunil

That is just a warning. I am sure the warning was displayed in yellow. Please check the results in planning book instead of the log for verification. I think you should be all set

Srinivas

[Former Member]

Hi,

Go to the planning area, in the extras menu, select the keyfigure settings and select the zero allowed tab for the keyfigures, then the macro will definetly work in the background.

Hope this helps.

Regards,

Raj

[Former Member]

Hi Srinivas/Raj,

Thanks for you reply.

Srinivas- yes I checked in interactive Planning still negative values exists.

Raj- I donot find any option as such could you please where exactly i can enable that.

Thanks,

Sunil

[srinivas_krishnamoorthy]

Since it is giving desired results in interactive mode but not in background mode, you may want to check couple of things

- are you running the macro at the same aggregation level as in interactive ?

- Did you try refreshing the screen after backround run and check the results ?

Is the "Data not saved" message type information(yellow) or error (red) ?

[Former Member]

Hi,

Go to transaction MSDP_ADMIN, double click on the planning area then go to extras in the menu bar, select keyfigure settings, find the zero allowed column and select the keyfigures as zero allowed.

The above path is for SCM 5.0, so please verify

Regards,

Rajesh

[Former Member]

the first line in the post says he is on 4.0

what you mentioned, i think, does not work pre-5.0

[Former Member]

Oops!! i didn't notice it. I dont know about SCM 4.0

Regards,

Raj

[Former Member]

Hi sunil,

I faced a similar problem for a different macro calculation.

As far as i understand the macro results(as a background activity) are not saved sometimes when the results are to be populated in the frozen horizon of the planning book

i.e data cannot be saved as history. which was my case.

Frozen horizon includes the planning start date and the offset if used in the planning book data view settings.

You check these in spool if any message for history is being displayed

Regards

Ankur

Edited by: Ankur Shrivastava on Dec 18, 2007 12:38 PM

[Former Member]

Hi Raj/Srinivas,

Thanks for Your reply.

Raj - I am on SCM 4.0 that is the reason i don't have this option.

Srinivas- At any level I am not able to save the data of Zeroout

Negative values amcro.

What I do is first run the background Job for this macro which Zero's out negative values.

Then I enter into the interactive planning to see and negative values exists.

and the message in log, you are right it is yellow and it is a warning message

Thanks for your help in advance.

Thanks,

Sunil

[Former Member]

Hi Ankur,

Thanks for your reply,

your example below is for history horizon.

I don't have anything to save in the history horizon Since the macro is to zerout the negative forecast values in the future horizon, and macro runs from Current month to next 24 months. and the planning area is initialized for 26 months.

the exact copy of my job spool is as below.

0116 Macro Zero Out Negative Values Stat1 Fcst has been executed

0116 Macro Zero Out Negative Values Final Fcst has been executed

0116 The data is not saved(this is in Yellow warning)

Thanks in advance for your help.

Thanks,

Sunil

[Former Member]

Hi Sunil,

Suggest you to select material level for macro execution in background.

Hope this helps

Regards

Ankur

[Former Member]

Hi Ankur,

I tried Executing at the material level also but still does not clear out the Negative values.

Thanks,

Sunil

[srinivas_krishnamoorthy]

Please do another thing for me.

Go to transaction /sapapo/mc8k and pull up the batch run of macro. How many yellows, greens, reds and stops do you see ? "Data not saved warning" comes when there is no change in data. Out of curiosity can you also let us know if you have any parameter IDs setup for your user/batch profile.

[Former Member]

Hi,

How your forecast is generated ? Let us know in detail

Bvn