Creating Field Movement 

Use

With field movement, you can define how data/which fields is/are to transferred to and summarized in a database. Field movements contain:

You have to assign a field movement rule to each group of field movements.

Procedure

You are now in the Create Rollup <Name>: Rollup Sequence screen.

  1. Enter the name of the field movement that you want to create and choose Field Movement.

    2. The Create Rollup Field Movement: Data screen appears.

  2. Enter the following data:

– A description of the field movement

– A user exit to be performed after data is selected from the database, if required.

– A user exit to be performed before the database is updated with receiver records, if required.

– Receiver field name

The receiver field is the field to which the sender field name is assigned.

– A sender field name that is to be assigned from the source table.

The data from this field is assigned to the Rec. fld field.

– A substitution activity code

– A user exit number to be performed when the data from the sender field is moved to the receiver field during rollup execution, if required.

For more information about user exits, see User Exits and Rollups.

3. To save the field movement information, choose .

This screen contains the following additional functions:

To delete a row from the field movement information, choose .

To enter substitution information for the rollup, choose Substitutions. For further information, see Entering Substitution Processes.

To display additional entries for entering field movements, choose New Entries.

To delete all rows from the field movement information, choose Edit ® Delete All Rows.

You use the Edit ® Choose function on the Create Rollup <Name>: Rollup Sequence screen to display a field movement already defined in the rollup sequence.

Result

You have created/edited a field movement for the rollup, thus defining which data/fields are to be transferred and summarized from the source database to the receiver database.