Show TOC Entering content frame

Function documentation Attributes of Macro Elements Locate the document in its SAP Library structure


You can change the attributes of the various macro elements (macros, steps, conditions, and so on). The attributes that can be edited vary with the element type and include the periods for which the element is valid and additional functions.


For each macro element, you can change the name in the attributes.


Here you specify:

     Whether the macro can be executed directly

     Whether a confirmation prompt appears when you execute the macro

     Whether the auxiliary table is initialized when you call the macro

If the auxiliary table is not initialized when you call the macro, any values that are in the table from the execution of previous macros remain in the table and can be used in the current macro. All entries in the auxiliary table are lost when you leave the planning book.

     Which change mode is to be performed, for example, a value change or an attribute change (see Structure linkChange Mode for Key Figures)

     The level on which the macro is used

The level is defined by the current drill-down situation. This means in interactive planning that the aggregate level is the level at which you enter the planning book by making a selection. If you drill down on characteristic A, this is level 1. If you then drill down on another characteristic (characteristic B), this is level 2.

     Whether cells that have no entries (initial) are left blank or are given the value "0".

To improve performance, we recommend that you set this indicator.


This indicator does not have any effect on key figures that differentiate between initial values and zero values.

You can also assign an icon to the macro that appears in the planning table. You can then execute the macro by clicking this icon.

You also see if the macro is used as a standard macro and if so, which type and at which position the macro appears in the list for the relevant type (start, exit, level change, or default).

You can also define collective macros. These consist of other macros in the planning book. These macros are then executed automatically in the given order.


You define a macro as a collective macro when you create it, by setting the Macro type field to Collective macro. If you have already assigned other elements (steps, conditions, and so on) to it, you can no longer define the macro as a collective macro.


In the step attributes, you primarily define the time period for which the step applies. You can specify that it applies to:

     The whole period

     The past

     The future

     Freely definable

Here you can enter existing time buckets or columns. This means that the position of the column in the table remains constant, but that the dates might move. For example, the macro applies to the second time bucket in the future to the tenth time bucket in the future.


Here the time buckets are selected that contain the specified dates. The dates remain constant, but the time bucket might change. Example: The macro is valid from January 01, 2001 to June 30, 2001. You can specify whether only those periods are taken into account that are entirely in the specified time frame.

     Whether the columns at the start and end are adjusted automatically.

This function is only available if the start column or end column contains the first or last past period or the first or last future period (see SAP Note 674239).


When you create a new macro element, the attribute dialog box appears automatically. You can access it later via the context menu, or by double-clicking the element in the workspace.


Several of these functions are only available in expert mode. You can switch the export on or off by choosing Settings  ® Expert Mode On/Off. This reverts to the default the next time you enter the MacroBuilder. To save the setting in a user-specific way, choose Settings  ® Save Mode Setting.


Leaving content frame