Map

Legacy Value (Source Table Fields) H

Legacy Value (Source Table Fields) V

To access this page:

  1. Select Advanced Data Migration in the Navigation pane.
  2. Select Map in the Context bar.
  3. Select Configuration >Value Mapping (Config) in the Navigation pane.
  4. Click the Sources icon for a check table.
  5. Click Vertical View for a Source.
  6. Click the Source Tables icon.

Field

Description

SOURCE

Displays the name of the Source as defined in Target Design.

SOURCE TABLE

Displays the Source table containing the field.

SOURCE FIELD

Displays the Source field containing the value.

STATUS

Displays the status of the Source field, such as whether the field is active, if value mapping is complete or if the Source field is not used. The field is used to track when a Mapper incorrectly sets a field mapping with an action of Xref. This status will leave a place holder for other users to review the setting and either activate or inactivate this Source field or table.

LEGACY DESCRIPTION TABLE

Displays the table name that stores the description field of the Source field.  Usually, the value and description are stored in the same table.

LEGACY DESCRIPTION FIELD

Displays the field name that contains the description of the Source field.

For example, the field State contains a value of GA. The description of the State field would be Georgia, and is stored in the description field.

View Values

Click to open the Legacy Value (Source Table Fields) page to view all values for the Source table that must be value mapped or removed.

Value Mappings

Click to open the Value Mapping (Legacy to Target) page to perform value mapping for the selected Source field.

Value Tracking

Click to open the Source Value Tracking page to view each Source table that has a field that has been mapped to the selected lookup table.

Refer to View the Source Tables and Fields Mapped to a Lookup Table for more information.

Remove Values

Click to remove all unmapped values from the Source table. Mapped values must be removed manually.

Values that are removed have:

NOTE: This button does not display to users assigned to the following WebApp groups:

  • Read Only

  • ValueMapper

  • FieldMapper

Refresh

Click to delete unmapped values and pull new values from the Source.

Legacy Value (Source Table Fields) V

Legacy Value (Source Table Fields) H

Field

Description

Data Source Name

Displays the database name of the Source.

Source

Displays the name of the Source as defined in Target Design.

Check Table

Displays the name of the ERP check table.

Comment

Displays user-entered comments about the selected check table.

Source Table

Displays the Source table containing the field.

NOTE: The Source table for the check table for the Rule Xref action is not automatically set. It must be entered in this field.

Source Field

Displays the Source field containing the value.

NOTE: The Source field for the check table for the Rule Xref action is not automatically set. It must be entered in this field.

Client Field

Displays the name of the field used for filtering on Client Values.  This field only applies to SAP Sources. For example: MANDT, CLIENT or MANDANT

Language Field

Displays the name of the language field in the Source table to filter description updates in one language.  This field only applies to SAP Sources.

Legacy Description Table

Displays the table name that stores the description field for the Source field.  Usually, the value and description are stored in the same table.

Legacy Description Field

Displays the field name that contains the description of the Source field.

For example, the field State contains a value of GA. The description of the State field would be Georgia, and is stored in the description field.

Legacy Description Table Key Field

Displays a key field name when the primary key of the Source table does not match the primary key of the Legacy Description Table.

Legacy Description Language Field

Displays the field in the Source table that stores the description of the language.

Additional Information

Source Field2

Displays the second Key field name (for Multi-Part Key Source table).

Source Field3

Displays the third Key field name (for Multi-Part Key Source table).

Source Field4

Displays the fourth Key field name (for Multi-Part Key Source table.

Source Field5

Displays the fifth Key field name (for Multi-Part Key Source table).

Description Update SQL

Displays the Override Download SQL if the Source Table is too complicated for auto-generated SQL commands.

Refer to the Knowledge Base article How do I use the "Description Update SQL" field? for more information.

Value Download Where Clause

Displays the where clause to append to the download of values to filter on a smaller mapping list.