Show TOC

Procedure documentationAssigning Comparison Tables Locate this document in the navigation structure

 

In the assignment, you specify which data fields in the tables in the first system you want to compare with which data fields in the tables in the second system and which data fields are used as comparison keys. You assign this assignment a name with which you can later identify it.

You also create fixed and variables filters that you use to restrict the comparison. For fixed filters, you specify the data field and the exact value of the filter as soon as you create the comparison object. For example, you specify the restriction Country="DE" when you create the comparison object.

For variable filters, you specify when you create the comparison object that a certain data field is to be used as a variable filter, for example the Country data field. The variable filters are displayed in the comparison instance, where you can specify values for them, such as Country="DE". This allows you to create multiple comparison instances for the same comparison object and specify different filter values for each – for example, Country="DE" for one comparison instance and Country="US" for another comparison instance.

Prerequisites

You have created a comparison object and, if you have created more than one table for each system, you have defined the foreign keys between the tables.

Procedure

  1. Choose   Comparison Object   Maintenance Mode Data Model   Maintain Mapping  .

  2. Define the assignment by dragging the arrows provided between the tables from left to right.

    A dialog box is displayed for each assignment.

  3. Enter the following data:

    • Tag Name: Enter a name for the assignment.

    • Comparison Key No.: You create at least one comparison key for the comparison and specify the sequence of the comparison keys.

      Enter 1, 2, 3, and so on, to define the sequence of the comparison keys.

      Enter 0 to select the data fields for the actual comparison.

  4. Variable Filter: Enter a value to indicate that the assignment is a fixed filter.

    Enter X to indicate that the assignment is a variable filter.

    If you do not want to use the assignment as a filter, leave the field empty.

  5. Save your entries.

Note Note

Choose No Changes to Data Model Allowed to lock the comparison tables and prevent them from being changed inadvertently, for example.

End of the note.

Result

You have defined the assignment between the data fields of the comparison tables.

Now create the function module for the comparison.