Entering Substitution Activity Information

Use

A substitution activity allows you to transfer substituted data to receiver dimensions during the rollup process. A substitution activity is identified by its substitution activity code, and you enter the substitution activity code in a field movement. You can use the same substitution activity code for more than one rollup sequence.

Example Example

You could define a substitution activity called CONV to substitute the value 300000 for account numbers between 500000 and 500020 (number 1) and to substitute the value 400000 for account numbers between 600000 and 600020 (number 2). Next, you enter the substitution activity code CONV in a field movement that transfers the data for the dimension Account. When you execute your rollup, account numbers between 500000 and 500020 will be changed to and summarized under account number 300000, and account numbers between 600000 and 600020 will be changed to and summarized under 400000.

End of the example.

Procedure

You are currently in the Create Field Movement: Data screen:

  1. Choose Substitution . The Change View "Rollup Substitution": Overview screen appears.

  2. Choose New entries . The New Entries: Overview of Created Entries screen appears.

  3. Enter the following data:

  4. – Name of the substitution activity

    – A consecutive number

    – Name of the summary table (receiver table)

    – Name of the receiver field (receiver dimension)

    – Constant value (substitution value)

    The value you enter in this field will be substituted for the original value if the substitution condition is met.

    For substitution activity code CONV (above example), you could enter the value 300000.

    – User exit number, to refer the system to a rollup substitution exit

    If your substitution condition is too complicated to define here (for example, if you want to read a user-defined table), you can define the substitution in a user-defined routine called a substitution exit. Generally, if you enter a user exit, it is not necessary to enter a value in the Constant value field. For more information about user exits, see User Exits and Rollups .

    – A substitution rule

    The substitution activity (replacement by constant value or execution of a user-exit) is only executed if the rule entered for it is complied with.

    All substitution rules that are used in rollup substitution activities must be created for table GLU1 (application area GU, callup point 0002).

    For more information about creating substitution rules, see Creating Rules .

  5. To save the substitution activity, choose .

Result

You have created substitution activities. When you execute the rollup, the substituted data will be transferred to the receiver dimensions.

You can use the following additional functions in this screen:

To position the cursor on a substitution activity that has already been defined, choose .

To switch between display mode and change mode in the table view, choose .

To delete a substitution activity, select the row and choose .

To select all substitution entries for further processing, choose .

To select a block of substitution activities for further processing, choose .

To delete the selection for all selected substitution activities, choose .

Additional Processing Functions - Change View "Rollup Substitution": Overview Screen

Menu Path

Function

Table View → Save

Save the substitution activity definitions.

Table View → Transport

Prepare the table for transport under a correction number.

Table View → Print → Standard List

Print all substitution activities defined on the system.

Table View → Print → Variable List

Print specific substitution activities based on user-defined selection criteria.

Edit → New Entries

Create a new substitution activity.

Edit → Copy as

Copy a selected substitution activity.

Edit → Change Field Content

Change a selected substitution activity.

Edit → Reverse Change

Change a selected substitution activity back to its previous definition.

Goto → Next Entry

Move to the next substitution activity.

Goto → Previous Entry

Move to the previous substitution activity.

Goto → Other Entry

Move to a specific substitution activity.

Selection → By Content

View substitution activities according to the fields displayed on the screen.

Selection → All Selected Entries

View all substitution activities that have been selected.

Selection → All Changed Entries

View all substitution activities that have been changed.

Selection → All Created Entries

View all substitution activities that have just been created.

Selection → Display Deleted Entries

View all substitution activities that have just been deleted.

Utilities → Other Systems

Compare the substitution activity entries with the entries in another system (for example, a test system vs. a productive system).

Utilities → Requests (Organizer)

Call up the Workbench Organizer, for example, to maintain and display transport requests.