Map
Legacy Value (Source Table Fields) H
Legacy Value (Source Table Fields) V
Use this page when Value Mapping Target Fields from Multiple Source Systems and to Remove Unmapped Source Values.
To access this page:
- Select Advanced Data Migration 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.
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:
|
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
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. 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. |