Skip to Content
Author's profile photo Christoforos Verras

ID Mapping for Integration – Employees

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 c.verras@sap.com

 

Thanks,
.CV

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hello Christoforos Verras

      Thank you for detailed explanation. I have loaded employees data by using standard  template now I would like to maintain the ID mapping for those employees but I am getting below error.

       

      Thank you,

      Chandu

       

       

      Author's profile photo Former Member
      Former Member

      Hi,

      The above issue resolved by changing the external id

      Thank you

      Chandu

      Author's profile photo Christoforos Verras
      Christoforos Verras
      Blog Post Author

      That's great Former Member!

      Happy to help 🙂

      Author's profile photo Haseeb Mirza
      Haseeb Mirza

      Hello,

       

      Thank you for the blog. Is there a way to remove id mappings using the excel add-in. Keeping a blank entry is not helping as the system is expecting a value there.

       

      Thank you,

      Haseeb.

      Author's profile photo Christian Dykstra
      Christian Dykstra

       

      Hello Haseeb,

      I have the same requirement. Have you found a solution?

      Kind Regards

      Christian

      Author's profile photo Haseeb Mirza
      Haseeb Mirza

      Hello Christian,

      Unfortunately none so far, will update if I happen to find one.

       

      Haseeb.

      Author's profile photo Vincent Hoang
      Vincent Hoang

      Any luck?

      What is solution to remove ID mappings from C4C system?

       

      Thanks,

      Vincent

      Author's profile photo Haseeb Mirza
      Haseeb Mirza

      Hello Vincent,

       

      Haven't tried anything since. However I think you can try to remove the external ID using mass upload (Data Workbench). I hope it works.

       

      Haseeb.

      Author's profile photo Vincent Hoang
      Vincent Hoang

      Nice idea but not possible.
      Even creating custom ODATA doesn't expose the External ID.

      Thanks,

      Vincent

      Author's profile photo Deborah Acker
      Deborah Acker

      Hi Christoforos Verras,

      what to do if the “Lookup” feature is not working and there is no value help to chose from for the “Mapping Of” and “System Instance ID”?

      When the data is saved to C4C there is an error message saying the object reference was not defined for an object instance…

      Thank you, Deborah

       

      Author's profile photo Pallavi Bhagat
      Pallavi Bhagat

       

      Hi  Christoforos Verras,

      Is the solution for removing ID mapping available now?

      Regards,

      Pallavi

      Author's profile photo Rene Vorberg
      Rene Vorberg

      Hi at all,

      if you need to upload ID Mappings to Cloud for Customer (Sales Cloud), I recommend to use the Data Workbench.

      The feature with the Excel Plugin worked at my side only for a very limited number of records. It´s better to download the "Object Identifier Mapping" via Workbench, insert mappings in this file and then it upload again. In my case, this saved me a lot of work.

      Regards,

      René

      Author's profile photo VISHWA BETHANABOTLA
      VISHWA BETHANABOTLA

      Hello,

      In an integration scenario from CRM to C4C, how does the external id filled in automatically without any manual step?