Legacy Value (Source Table Fields) H

Legacy Value (Source Table Fields) V

Use this page when Value Map Target Fields from Multiple Source Systems.

To access this page:

  1. Select dspMigrate 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.

Legacy Value (Source Table Fields) V

Legacy Value (Source Table Fields) H

Use this page when Defining Tables and Fields for Multiple Source Systems to Use in Value Mapping.

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.

Value Download Where Clause

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