CRM and CX Blogs by SAP
Stay up-to-date on the latest developments and product news about intelligent customer experience and CRM technologies through blog posts from SAP experts.
Showing results for 
Search instead for 
Did you mean: 
0 Kudos
Hi all,

In this blog I will show how to do the ID Mapping for Integration for Employees, that is required in C4C implementations where Integration with ERP is in scope.

The basic idea is that C4C keeps an internal ascending ID list, which in our case starts with an "8" where in ERP side, every employee is considered as a Vendor, with Account Group Z007 so it starts with a "7".

What we want, is to map these values so these system can communicate in the same language, understanding the same things, about the same person.

To do that, navigate to "APPLICATION & USER MANAGEMENT", click on "ID MAPPING FOR INTEGRATION", and then click on "Edit ID Mapping for Integration".

In the upcoming screen, in the field “Mapping of:” select the “ERP Employees

In the “System Instance ID:” field, insert the corresponding system ID of your ERP system, and click on “Go

Then click on "ID Mapping from Microsoft Excel" and save the document locally.

When the Excel file opens, (you must have downloaded that Microsoft Excel Add-in from the Downloads area inside C4C) navigate to the "SAP HYBRIS CLOUD FOR CUSTOMER" tab, and click on "Logon".

In the popup window, enter your credentials along with the URL of the tenant 

after a successful logon you should be able to see this icon saying "Log off"

Then, click on cell C4 (next to Mapping of), press "Lookup" and in the popup window, click on "Search" with an empty value.

Same actions are needed for the "System Instance ID"  cell C5.

Once done, under the Local ID column, enter the C4C internal ID for the employee you want and in the next cell, the External ID as found inside ERP.

Once done, press the "Save Data to" and the popup window will inform you for the success or failure of the process.

If the process is done correctly, you see the message

If not, please comment here or contact me personally at