C4C OData V2 External ID

[skatschewitz]

Hi all

We are exploring the new C4C OData V2 service to connect a third party system to C4C. This system shall enhance customer data for customers which have been loaded initially from SAP ERP. This is because certain fields only exist in this third party system.

For identifying customers during the calls we would like to use the External ID, i.e. the SAP ERP ID as this is known to the third party system as well. Checking the documentation, we have not been able to find this field in the corporateaccount or in any other collection in https://help.sap.com/doc/d0f9ba822c08405da7d88174b304df84/LATEST/en-US/index.html.

Are there better ways then the ones explained in the following link? I would rather use the standard field instead of creating another KUT field which mirrors the External ID for not particular reason except that OData V2 is not complete... https://archive.sap.com/discussions/thread/3740377

Kind Regards
Stefan

[skatschewitz · Accepted solution]

We have checked with SAP directly and received the suggestion to build our own custom OData service as external ID is not included in the standard OData V2.

[spyros · Accepted solution]

Hallo Stefan,

I can't find the External ID field when I try to make my own OData service. Can you tell me which field I need and where I can find it?

[skatschewitz · Accepted solution]

Hi Spyros, a colleague of mine build this. Hope this helps:

[spyros · Accepted solution]

I guess the ExternalID (ERP Customer ID in my case) I need is the field ExternalKey in your Screenshot. My problem is that i can't find this field. Or am I looking at the wrong place?

[former_member376525 · Accepted solution]

Any update on how you got the ExternalKey?

skatschewitz spyros.tragas

[skatschewitz · Accepted solution]

Hi

1. use BO Name = Customer and BO Node Name = Root
2. Look for node ObjectIdentifierMapping
3. RemoteObjectID is what you are looking for

Hope this helps.

Kind Regards
Stefan

[former_member376525 · Accepted solution]

Stefan,

Thank you, that was what I was looking for!

[fabian_otto · Accepted solution]

Can you please attach a screenshot how the custom-specific OData looks like? Thx.

[skatschewitz · Accepted solution]

Hi Fabian, please see below:

In the meantime, we have found new issues which are that RemoteObjectID is neither creatable nor changable. We are now evaluating a new option to create our own external ID as KUT field and are in contact with SAP in parallel asking them to bring ObjectIdentifierMapping to standard OData V2 including feature to create and update. Another option is to use the to be depreciated SOAP web service for ObjectIdentifierMapping maitnainence.

The custom OData service is useless like shown above. We need to be able to maintain this collection to stay in standard with ID Mapping for integration and for being able to extend to Quote and Order as well as external pricing ERP integration scenarios in the future. We are building a landscape, in which material master is provided from 3rd party system whereas anything else is done with standard SAP ERP integration.

[fabian_otto · Accepted solution]

Hi Stefan, many thanks for your update.

I am facing exactly the same issues as you have described. Via OData it is currently not possible to manage external id and external system, so only SOAP left...

In our scenario ERP integration is not relevant. We are building a 3rd party integration for individual customers.

Regards
Fabian

[former_member553494]

Hey,

For the Account External ID found this ideas, that also suggest it is not there already (External Key is not the same with the External ID)

https://influence.sap.com/sap/ino/#/idea/143804/?section=sectionDetails.

https://influence.sap.com/sap/ino/#/idea/217745/?section=sectionDetails

They are still in status acknowledged so maybe we can have it delivered.

Kind regards,

CArina.