Question Re: How to make cell values as BLANK(INITIAL) using a macro run in Supply Chain Management Q&A

How to make cell values as BLANK(INITIAL) using a macro run

Former Member — Tue, 15 Mar 2011 17:56:32 GMT

Hi Experts,

Need your advice on how I can make cell values in planning book as BLANK or INITIAL by using a macro. I am using SAP SCM 7.0

Thanks and Regards

Nisha

Re: How to make cell values as BLANK(INITIAL) using a macro run

rico_frenzel — Wed, 16 Mar 2011 08:29:57 GMT

Hi,

basically like this

Macro [INITIALIZE]

STEP (XXXIterations)

Row "Forecast" =

When adding the keyfigure to be initialized in the macro logic above you will get a popup to define properties of the row. Change Scope: Set the Change mode to "Initialization" and adopt. Afterwards the corresponding

row of the macro step should look like this:

Row: Forecast ( Frm M 06.2007 ) = Initial

This will reset the key figure "Forecast" to initial for all buckets

specified in the step properties.

You will find more information about handling initial values in macros in note 1068603

!!Remember!!: The keyfigure needs to allow zero values as per planning area design. Otherwise you can - of course - not initialize it because zero means initial in this case.

Best regards

Rico Frenzel

Re: How to make cell values as BLANK(INITIAL) using a macro run

gsrreddy — Fri, 02 Feb 2024 02:24:46 GMT

In the change mode some fields are missing according to key figure