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:
- Select dspMigrate in the Navigation pane.
- Select Map in the Context bar.
- Select Configuration >Value Mapping (Config) in the Navigation pane.
- Click the Sources icon for a check table.
- Click Vertical View for a Source.
- 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.
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.