(DV-1808) Field Mapping

Field mapping functionality gives you an option to compare table images that would be not comparable using the standard function. When table images are compared following restrictions apply:

  • Characteristic fields
    • Order in before and after image must be the same
    • Underlying data element must be the same
  • Key figure fields
    • Name must be the same while the position isn't important

Comparison of two different tables is often not possible due to these restrictions. Correctly defined field mapping gives you a better flexibility for comparing different tables.

Field mapping definition

New field mapping can be defined/edited in two ways:

  1. The first option is in the table variant definition screen. For more information about variant definition see Table Definition.
    1. Fill Field Mapping ID into the corresponding screen field.
    2. Double click on the specified name to create new field mapping. Screen for Field Mapping Definition is displayed. 
      1. If a field mapping with same name already exists, you will be redirected to the screen for Field Mapping Definition of an existing mapping. 
  2. The second option is to execute the program /DVD/EQS_TABE_FLDMAP
    1. List of available field mappings is displayed
    2. To add a new mapping, add a row to the list and provide a technical Field Mapping ID.
    3. To delete an existing mapping, remove rows from the list.
    4. To edit an existing mapping, double click on the particular row.

Field Mapping Definition screen

In Field Mapping Definition you define:

Name mapping

  • This mapping renames the output column of a table variant from value A to value B. Use this mapping to match key figure fields with a different name so they may be compared.
  • To define the name mapping enter a column name of the original table in Old Field Name and new column name in the New Field Name.

Data element mapping

  • This mapping converts values of column A from an old data element to a new data element. Use this mapping to compare a characteristic field with different data elements. The restriction of the same order of characteristics still applies for characteristic fields.
  • To define the data element mapping enter the original data element name in Old Data element and the new data element in the New Data element.

  • Use standard functions to add/remove new mappings. 
  • Change values in appropriate table columns to edit existing mappings.

You can specify renaming and conversion of table columns at once by defining values in all four fields.