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