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:

  • Sender fields (dimensions of the source database)

  • Receiver fields (dimensions of the receiver database)

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.

  3. 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 Start of the navigation path Edit Next navigation step Delete All Rows. End of the navigation path

Note Note

You use the Start of the navigation path Edit Next navigation step Choose Next navigation step function on the End of the navigation path Create Rollup <Name>: Rollup Sequence screen to display a field movement already defined in the rollup sequence.

End of the note.

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.