--- title: "Value Mappings" slug: "value-mappings" updated: 2026-10-13T12:36:05Z published: 2026-10-13T12:36:05Z canonical: "skthelp.syniti.com/value-mappings" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Value Mappings This topic is related to the following sections: - [Value Mapping Config](/v1/docs/value-mapping-config) - [Check Table Values](/v1/docs/check-table-values) ## About Value Mapping Within the **Migrate > Mappings** section of Syniti Migrate, the mapping of fields that contain a check table may require a mapping from old to new values. For Mapping Action of Xref, field contains a Check Table name. The mapping also contains the field **Xref Table** which stores the Legacy Value, the Target Value, and the Load Value. Each of these fields are important to the translation from legacy to target mappings. The Check Tables require Value Mappings from the Legacy value to the Target value stored within **XTVALUEMAP** table, and if the target value is complex (which may be a concatenated string of fields) then to the Load value stored in table **LIST_TARGET_VALUE** table in the MIGRATE database. ## Prerequisites for Value Mapping - The Datasource MIGRATE must be setup properly to point to the MIGRATE Datasource Server. Refer to section [Datasource Servers](/v1/docs/datasource-servers) for details of setup for the Datasource MIGRATE. - The Datasource MIGRATE must be setup within Snapshot Management as a source datasource for SRCCONSTRUCT so that the snapshot of data within tables **LIST_TARGET_VALUE** and **XTVALUEMAP** are aligned. Refer to section [Add a CONSTRUCT Snapshot Datasource](/v1/docs/snapshot-management#add-a-construct-snapshot-datasource) for details of setup and use. - Once the Dataset fields have been Mapped and the results provide opportunity for Value Mappings (XREF mapping), the object should be setup in the and processed to import from Source to Working table rows of data. The process of inserting from the Working table to **XTVALUEMAP** table the values for each zXREF field provides the tables and rows of data for use in this process. Either the SAP Data Services XML scripting builds these rules to run in Data Services, or the Syniti Migrate ETL adds rules for this action automatically. Refer to sections within [Mapping](/v1/docs/mappings) for details on the ETL process and SAP Data Services XML scripting of rules and cross references. > [!NOTE] > Note > > SAP Data Services ETL Tool is deprecated. Use **Syniti Migrate** as the preferred ETL tool. - Within **Administer > Advanced > Value Mapping Config**, the check table may be setup for a more complicated translation from legacy to load values by adding an Import Query. Refer to section [Value Mapping Config](/v1/docs/value-mapping-config) for details of setup and refresh of check tables by Subject Area. ## Users & Roles in Value Mappings The Migration Team Developers and Mappers are responsible for managing Value Mappings as part of the Migration ETL process. | Role | Definition | | --- | --- | | Admin | The IT Lead or Team Administrator responsible for all Syniti Migrate ETL initial setup. | | Developer | The user developing the ETL process in Syniti Migrate. | | Mapper | The business user responsible for the data being imported and its correct usage within the field. | ## Working with Value Mapping Access the Value Mappings page from three sections of the Syniti Migrate application - - Within **Migrate > Mappings**, through a link from within Mappings while viewing a Mapping for XREF type (Option 1) - Within **Migrate > Mappings**, click **Options** icon stored within the Source table row of Mappings (Option 2) - Direct access to all Value Mappings tables using pathway - **Migrate > Value Mappings**. (Option 3) The user may select to process Value Mappings for a field from within the field mapping page. There are two places for access to this process - from within the XREF Mapping row, or from within the **Options** menu displayed on each row of the Sources panel. **Option 1 -** Access to the Value Mappings page through a link from within Mappings while viewing a the mapping details for action type XREF or Rule Xref as shown below: ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/bb207e2e-4ee7-436c-b9af-320183dbd49c.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=UaIxd7s5dcdxSmRFnp4Z4of4orXFslSy5zqr233n7V4%3D) Mappings: Data Mapping Details for XREF: Value Mappings link **Option 2 -** Access the Value Mappings page through the Mappings page. The user may work on Value Mappings for each Source system directly within the Migration Application. In the Sources panel, click **Options** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ee9be5f2-92e6-4117-b69a-f32ee3f6fa04.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=RfcjWAfSXohAcLdpkYWvlUNwKotcq3uuv%2Fp8otfollk%3D) icon to display options for the selected Datasource Table. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/5a0b8e90-ba2e-4df3-974e-6868b063913f.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=xDOffUG88rnnueHkxG9%2FGeF6lJWIDVlgetN3NxWIYYw%3D) Mappings: Sources Click on **Value Mappings** option. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/5846eb6f-717b-45ba-87ea-34370d64d96b.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=oiNJDa%2BphX7CK47GnHBRV8eO5ZToMLVrg4oGeYCf%2B40%3D) Mappings: Options: Value Mappings The Value Mappings page displays. At the top of the Value Mappings page, three filter panels are displayed side-by-side: **Target System**, **Check Table**, and **ZSource**. Each panel lists the available entries for that category along with a completion count (for example, `8/76`) and a badge showing how many mappings in that entry are still incomplete. First, filter to the Check Table by selecting the values using the filter panels. The top section displays the following panels: | Header | Description | | --- | --- | | Target System* | Select the required Target Datasource for the Check Table. | | ZSource* | Select the required Source Datasource for the Check Table. | | Check Table* | Select from drop down list the Check Table for this Object. (Required) | A legend at the top of the **Target System** panel indicates the status colors used throughout the panels: - **Complete:** The count of mapping rows with a Target Value populated - **In Progress:** The count of mapping rows still needing a Target Value Once a Target System, Check Table, and ZSource are selected, a path header appears above the Value Mappings grid showing the current selection. The Value Mappings grid below then loads the rows for that combination of Target System, Check Table, and ZSource. This is an active grid and rows may be Added, Edited, or Deleted as described in the following sections. The **Search** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/905b8f32-4a32-4254-aaa6-090b9f4d29f7.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=G83pjZit9wVLPmXnX%2B6K3x3%2BxxmWoS84XIrLC0X0GZg%3D) icon may be used to filter data for specific values. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image-AC8MZIUQ.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=j8%2FeCBbdI5zeh2Xxutubg4CIouu97tE%2FLe%2BTyQtgiwU%3D) Value Mappings Data **Option 3 -** View the following page by navigating to **Migrate > Value Mappings** from the Syniti Migrate Homepage. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/50fed129-8495-46b6-823e-b6adc6ada566.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=EHImriplW1GeOeCxQ8Fk%2FHZSWqU7azq3uymchojtGpE%3D) Value Mappings ## Add Legacy Values for Translation Legacy Values may be added manually by clicking the **Add** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/b216d19e-025f-4ffc-9159-f59fbded0bf9.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=fhg8m3dfbYiUlvEvZqWvP5uEs3mzkHZvPCyBZrye7Ps%3D) icon. The save is not active until a Legacy Value (Required field) has been entered. | Field | Description | | --- | --- | | Legacy Value | Enter a legacy system value not already in table. | | Legacy Description | Enter a description of the legacy value. | | Target Value | Select from the list a Target Value if known. | | Suggested Value | Provide a suggested value if the Target Value list does not provide the value needed. | | Not Applicable | Toggle used to mark the record as not relevant to translation. | Once all required fields have been added, the user either clicks **SAVE** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/d790397a-5d2b-4764-bb91-b39f65972196.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=OzOyEMK7tbDaSuN7jNYsbtnCbcGFoOxXvjhlQNzBQ9I%3D) icon or they may click **Cancel** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ce4de9ba-6669-4307-8842-3b8afb63a7dd.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=mn%2Bx1fYhEBQvj%2FWLt2SYxmatELp3zo%2BW98ZMJYGWVOQ%3D) to exit without adding. ## Edit Check Table Value Mappings To edit a row of data, click the Target Value cell for the row. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image-0Q14YQMB.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=5xwKBjFQn8hEKuy8HauQL9qvMDcmr%2Bi8vMSl0JxgGzM%3D) Value Mappings: Edit a row of data The Value Mappings panel displays the following Column Headers: | Header | Description | | --- | --- | | Legacy Value | Source Datasource value for this check table. | | Legacy Description | Source Datasource value description for this check table. | | Target Value | Target Datasource value for this check table. To modify or add a value, double-click and search for the required value. | | Suggested Value | Enter a text value to provide a suggested value. A row with only a Suggested Value (no Target Value) is still counted as **In Progress** in the status totals and panels until a Target Value is selected. | | Not Applicable | Toggle used to mark rows as not relevant for Value Mappings. | | Status | Read-only badge showing Complete, In Progress, or Not Applicable, calculated from the Target Value and Not Applicable toggle for the row. | | Created From | Table that provided this value mapping row. | | Created By | User ID who created the record. | | Created On | Date the record is created. | | Modified By | User ID who modified the record. | | Modified On | Date the record is modified. | The user may select a value from the drop-down list a **Target Value** for each **Legacy Value** provided in the list. As each row is manually updated, the row changes to dark gray indicating that this row has been updated. Once editing of the rows of data is complete, the user either clicks **SAVE** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/d790397a-5d2b-4764-bb91-b39f65972196.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=OzOyEMK7tbDaSuN7jNYsbtnCbcGFoOxXvjhlQNzBQ9I%3D) icon or they may click **RESET** button to remove all of the added changes. The Save icon if clicked produces a window to state that the data was Saved Successfully. Click **OK** button to proceed. > [!NOTE] > Note > > Records changed to add Target Values and saved update the **XTVALUEMAP** table stored in the MIGRATE database. The conversion of data points to the SRCCONSTRUCT database to pull and update the target values to the fields in the working table. Make sure to Repopulate the SRCCONSTRUCT.XTVALUEMAP table prior to running the ETL to use the latest values updated in the **XTVALUEMAP** table. In Snapshot Management, the view MIG_XTVALUEMAP has been added to the MIGRATE database. This view provides access to the LOAD_VALUE for use by the Xref Update rules. The view can be used as the source for the XTVALUEMAP snapshot from the MIGRATE database to the SRCCONSTRUCT database by updating the Snapshot System Table Name of the XTVALUEMAP snapshot to "MIG_XTVALUEMAP". The update rules can then reference the LOAD_VALUE column from the new XTVALUEMAP table in SRCCONSTRUCT. Refer to [Value Mapping Snapshot Data Stored in SRCCONSTRUCT](/v1/docs/snapshot-management#value-mapping-snapshot-data-stored-in-srcconstruct) for more information. In Value Mapping, the value that the Xref Update rule uses as the target value is now derived from the LOAD_VALUE if available, and, if there is no LOAD_VALUE, is derived from the TARGET_VALUE. Use the LOAD_VALUE field in situations where the value in the TARGET_VALUE field must be changed before being posted to the target. For example, the value in the TARGET_VALUE field can contain the value US-MN, but the value to be loaded to the target must be concatenated to MN. > [!NOTE] > Note > > This change applies to XREF Update rules created going forward, and is not applied retroactively. If you want to use the LOAD_VALUE field in existing ETL rules created prior to this release, you must: - Manually edit the existing Snapshot of the XTVALUEMAP table to reference the new MIG_XTVALUEMAP view in the Snapshot System Table Name field on the *Table* details page - Update your existing Xref Update rules to use the new code: ZFIELD = ISNULL(LOAD_VALUE, TARGET_VALUE) ## Delete Check Table Value Mappings There are a few ways to delete records no longer needed: - A single row may be deleted by clicking the **Delete** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/d72b0ccb-5911-4619-b08c-f4a8e3eac238.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=V%2FVLH59YAgfwmQs60%2FKFHSzMrdvJovLYbu3fP5yGNm4%3D) icon for the row. - To remove multiple records, select the row to highlight and click on the **Delete Selected Rows** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/d72b0ccb-5911-4619-b08c-f4a8e3eac238.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=V%2FVLH59YAgfwmQs60%2FKFHSzMrdvJovLYbu3fP5yGNm4%3D) icon in the header. - To remove all records that have no Target Values, click the **Delete Empty Values** button in the header. A message displays stating that the delete is successful. The list is updated for the total remaining rows. ## Suggested Value This field is used to supply a value for the Target Value where that Target Value is missing in the drop down list. The Suggested Value field stores the temporary value so that mapping and conversion may proceed until the target system is set with the same value for use as a Target Value An entry may be added to the Suggested Value field that is set as the Target Value during the Update rule for the XREF mapping. Notice that the Reset and Save icons are present due to the change to a row. Click **Save** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/d790397a-5d2b-4764-bb91-b39f65972196.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=OzOyEMK7tbDaSuN7jNYsbtnCbcGFoOxXvjhlQNzBQ9I%3D) icon to complete. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image-Y84V4U7U.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=MhnxhGlnWJHh%2FtmyDIfzuMR2RvyUEdjfx7B%2BxBDfm0k%3D) Value Mappings: Add a Suggested Value Once Complete, Save the rows of data as usual. The Suggested Value displays. ## Bulk Editing Should there be a need to update multiple rows of data with the same values, the user may click on the **Check box** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/90657364-03ea-499f-9bbb-0389f70eaeaf.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=deNyZZtk63lIVRSf4uzSLhAPdQZmsjbnkdojd2bYIMc%3D) icon at the Header level to mark all rows as selected. > [!NOTE] > Note > > As a option, the user may also click on multiple check box ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/90657364-03ea-499f-9bbb-0389f70eaeaf.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=deNyZZtk63lIVRSf4uzSLhAPdQZmsjbnkdojd2bYIMc%3D) icons to select some but not all rows. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image-DZ9C2DSM.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=QLuoUyNFFvdSDpSBOVfXUWVVRvyrd9I1WpQFJxRZssI%3D) Value Mappings: Bulk Edit Select Rows They can then update all rows at one time, and save them. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image-X3VFJ58P.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A05Z&se=2026-11-17T20%3A25%3A05Z&sr=b&sp=r&sig=H%2BOElNgTf6woZJuM%2BVQ3dugCBuJ07zZU1nYI5Xp40OY%3D) Value Mappings: Bulk Edit: Select target value The modified rows display with updated values for the field edited with Bulk Edit. Click **SAVE**. > [!NOTE] > Note > > Records changed to add Target Values and saved update the **XTVALUEMAP** table stored in the MIGRATE database. The conversion of data points to the SRCCONSTRUCT database to pull and update the target values to the fields in the working table. Make sure to Repopulate the SRCCONSTRUCT.XTVALUEMAP table prior to running the ETL to use the latest values updated in the **XTVALUEMAP** table. Should the updated and saved values need to be reversed, click the **RESET** button to revert back to original values. ## Reset Button Once a row of data has been modified, the **RESET** button displays as active. Should the user make multiple changes and decide they are not necessary, click the **RESET** button to default back to the saved values.