Field Movements and Rollups 

Use

Field movement defines which fields are to be transferred from a sender table to an FI-SL receiver table. There are two types of field movement:

Fixed field movement

When you execute a rollup, the data from the following dimensions is automatically transferred from the source ledger(s) into the dimensions in the rollup ledger:

The data in dimensions Year and Period is determined by the period definition of the rollup ledger.

For further information, see Customizing, under Special Ledger ® Basic Settings ® Maintain Fixed Field Movement.

Variable Field Movement

If you want to include other dimensions in your rollup ledger, such as account, cost center or business area, you have to define a field movement for these dimensions.

For further information, see the Implementation Guide (IMG), under Special Ledger ® Basic Settings ® Master Date ® Maintain Field Movement.

The following fields are defined in field movement

The following graphic shows a simple field movement example. The dimensions Account, Cost Center, and Business Area are transferred from the source ledger to the rollup ledger.

 

In this example, the data from the dimensions Account, Cost Center, and Business Area, is transferred to the rollup ledger according to field movement rule WXYZ.

When field movements are not defined for dimensions, the data for those dimensions is summarized within the dimensions that have defined field movements but the dimensions themselves are not transferred to the rollup ledger.

If you selected data for the dimensions Cost Center and Account, but you have only defined a field movement for the dimension Account, then the data for the selected cost centers is summarized and included in the data for the dimension Account.

Field Movement Rule

Using the field movement rule, you define how dimensions are taken over into the rollup ledger.

If you want to take over all of your data on a one-to-one basis, you must define all of your dimensions in the rollup field movement.

When you define your field movements, you can also define a field movement so that a dimension from the sender table is transferred to a receiver dimension in the line item database, even though the dimension does not exist in the receiver summary table.

You define a field movement as follows:

The dimension Original Account does not exist in the summary table GLT1; however, the dimension could be defined in the data part of the line item database GLS1 that corresponds to the summary table GLT1. In this case, the dimension Account would be transferred to the dimension Original Account only in table GLS1.

For more information about creating field movements in Customizing, see the Maintain Field Movement.

Field Movements and Substitution Activities

You can assign a substitution activity to each field movement.

When defining a field grouping code for a rollup, you can assign a substitution activity code to a field movement. A substitution activity code identifies a substitution activity; a substitution activity transfers substituted data to receiver dimensions during the rollup process.

If you want to summarize a group of products under a product group, you can define a substitution activity that substitutes the product group for the products during the rollup process. You enter the substitution activity code for the substitution activity in the field movement.

If you are using substitution rules, you can define more than one substitution value for a substitution activity.

 

 

For more information, see Entering Substitution Activities and the Implementation Guide (IMG) under Special Ledger ® Basic Settings ® Substitution.