2758271 - How to update Employee Key Mapping Table - SuccessFactors Integrations

The Employee Key Mapping (PAOCFEC_EEKEYMAP) table must be updated after employee data was replicated from SAP ERP HCM to Employee Central. This is necessary to prevent new personnel numbers being created during the next data replication from Employee Central to SAP ERP HCM for employees whose data was migrated or replicated from SAP ERP HCM to Employee Central.

Replicating Employee Data from SAP ERP HCM to Employee Central Using SAP Cloud Platform Integration as the Middleware

The table maps an employee's unique identifiers from the SAP ERP HCM system and from Employee Central. This key mapping table is updated when User ID, Personnel Number, and Third Party Employee ID are populated during the replication of data to Employee Central. When the BiB is disabled, the replication process use the PAOCFEC_EEKEYMAP key mapping table.

When you enable the BiB mode in the V_ECPAO_CONSTANT view, the ECPAO_EE_KMAP and ECPAO_OBJPS_KMAP key mapping tables are used. The update of the key mapping table ECPAO_EE_KMAP does not depend on the actual replication status. The key mapping tables are updated irrspective of the replication status of any entities. If the employee already has records in the old key mapping table (PAOCFEC_EEKEYMAP), then the new key mapping table ECPAO_EE_KMAP will not be populated (even when BiB switch is set to X). If there is no key mapping in the old table, only then the new key mapping table will be populated. For example: Even if the user entity replication fails, the key mapping table will be updated if the User ID and Person ID external are available.

If you use the Web service-based data replication (when BIB mode is disabled), the employee key mapping table is updated automatically. If you use the CSV file-based data replication, you must update the table manually. To do so, carry out the steps described below. This is procedure is applicable only if the BIB mode is disabled.

Steps for CSV data replication:

1. Go to the Update Employee Key Mapping Table (ECPAO_KEYMAP_UPD) transaction to run the Update Key Values Mapping Table with Manually Replicated Employee Data (ECPAO_EEREPCSV_EEKEYMAP_UPDATE) program;
2. On the selection screen, specify the employee and Employee Central instance for which the employee key mapping table is to be updated, then click Execute;

3. The program updates the employee key mapping table with the following key values:
   ○ Employee ID from Employee Central
   ○ Employment ID from Employee Central
   ○ Work agreement ID from Employee Central
   ○ User ID from Employee Central
   ○ Personnel number from SAP ERP HCM
   ○ Company code from SAP ERP HCM
   ○ Central person from SAP ERP HCM

Note: When BIB is enabled, the new key mapping table is updated automatically by the infoporter for both web service and csv based replication.

Find more information on the guide: Replicating Employee Data from SAP ERP HCM to Employee Central Using SAP Cloud Platform Integration as the Middleware

PAOCFEC_EEKEYMAP; Employee Key Mapping; CPI, how to update, Table, ECPAO_EE_KMAP, ECPAO_OBJPS_KMAP, ECPAO_EEREPCSV_EEKEYMAP_UPDATE, ECPAO_KEYMAP_UPD , KBA , LOD-SF-INT , Integrations , LOD-SF-INT-SAP , Please use LOD-EC-INT* , How To