---
sourceDocument: Yokohama Finance and Supply Chain
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/source-to-pay-operations

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Finance and Supply Chain

ft:clusterId :

    - stpop

bundleId :

    - stpop

workflow :

    - Employee


---

# Load data to ERP user mapping table for Source-to-Pay

# Load data to ERP user mapping table for Source-to-Pay {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Set up Source-to-Pay (S2P) and ERP User ID mapping for the integration to work. The mapping is maintained for all active users who have the procurement buyer role in ERP. These users should be used in the requisition
assignment rule.

## Before you begin

Role required: sn_shop.procurement_administrator

## Procedure

1. Navigate to AllSystem Import SetsLoad Data.
2. Select Create table and enter a label for the new table in the Label field.
3. In the Source of the import field, select File, and then click Choose File to select the source Excel spreadsheet.
4. **Optional:** If appropriate, specify the Work sheet and Header row number.
5. Click Submit.  
   The imported data is now available in the new Import Set table.
6. [Create a transform map](https://www.servicenow.com/docs/access?context=t_CreateATransformMap&version=yokohama&pubname=yokohama-integrate-applications&ft:locale=en-US) to define the field mapping between columns of the import set and columns of the target ERP User Mapping \[sn_fcms_intg_erp_user_map\] table.  
   The ERP User Mapping table maintains mapping between ERP user IDs and ServiceNow user IDs.
7. Transform the data from the import set table to the target table.  
   For more information, see [Run an import](https://www.servicenow.com/docs/access?context=t_RunImport&version=yokohama&pubname=yokohama-integrate-applications&ft:locale=en-US).
{#load-data-erp-user-mapping-psm__steps_fvs_vdt_33b}

## Result

The data is imported into the ERP User Mapping table.

## What to do next

Verify that the data records are imported into the target table. You can view the ERP user mappings by navigating to Finance - ERP IntegrationERP Users.  
Note:  
If an ERP user mapping is not required, you can deactivate it. To deactivate a mapping, in the ERP User Mapping form, select the Inactive check box.

*[\>]: and then