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

[Former Member]

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

[rico_frenzel]

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

[gsrreddy]

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