Match and merge Accounts and Contacts coming from ECC and C4C

[former_member701491]

Hello Gurus,

We integrated SAP ECC and C4C with our SAP Marketing Cloud. And configured the Origin IDs as follow :

- SAP ERP : One per contact (Yes), For identification (Yes)

- C4C : One per contact (Yes), For identification (Yes)

- Email : One per contact (No) , For identification (Yes)

- Phone : One per contact (No) , For identification (Yes)

The accounts and contact (from ECC and C4C) are matched and merged if they have the same Email or phone. But for the ones that have no Email or phone are not merged.

Is it possible to use SAP ERP ID as a match criteria for the Accounts repicated from C4C ?

BTW : Accounts created in C4C are replicated in ECC and vice versa

Thank you

[SCHNEIDERT]

Hi Anas,

do you replicate the ERP ID from C4C to SMC? If they are in the outgoing payload from C4C I think it is possible to use them as "AdditionalID" (at least if you use the API_MKT_CORPORATE_ACCOUNT_SRV).

BR Tobias

[former_member701491]

Hi schneidert,

Thank you for you quick response.

1 - In fact yes, C4C sends ERP ID in the outgoing payload. How can I add ERP ID as an additionalID id it's already an origin ID ?

2 - Do you think the actual setting is not enough ? btw, we changed Email and phone as origin ID instead of additionalID

Best regards,

Anas

[SCHNEIDERT]

Hi ahne,

I assume you're using the standard integration? So for the replication of Business Partners like Accounts, the iFlow "Replicate Business Partner to SAP Marketing" is used. This one uses the API CUAN_BUSINESS_PARTNER_IMP_SRV. (this service does unfortunately not have the Endpoint /AdditionalIDs like the API_MKT_CORPORATE_ACCOUNT_SRV).

But in this iFlow in the Main Mapping on the right side you can see the node ImportHeaders > ImportHeader > Companies > Company > Facets > Facet

Here you can see there are the fields IdOrigin and Id. In my opinion it should be possible to map here the ERP ID that is coming out of C4C and use the same Origin which you use for the replication from SAP ERP (I assume SAP_ERP_CUSTOMER for Accounts).

That's how I would try. Let me know if this helped or if you need further assistance.

The other option would be to replace maybe SAP_C4C_BUPA as Origin with SAP_ERP_CUSTOMER and the C4C-ID with the ERP-ID, but then the information in C4C MUST fit the information in ERP, so that it would not get overwritten...

Or you can change the OData API to API_MKT_CORPORATE_ACCOUNT_SRV So it would be better to use the first approach mentioned above with the additional ID/Facet.

BR Tobias

[former_member701491]

Hello schneidert ,

Thank you very much for these solutions,

Indeed we are using the standard integration with API CUAN_BUSINESS_PARTNER_IMP_SRV,

I'll test what you suggested and keep you informed,

Best regards,

Anas

[SCHNEIDERT]

Hi ahne,

you're welcome. Hope it will work. Let me know if you need further assistance. If it helped it would be cool if you could mark answer as accepted.

BR Tobias

[former_member701491]

Hi schneidert,

Is it possible to create a custom field in Marketing Cloud and bind it to the External ECC ID coming from C4C, and make this custom field as an Additional ID ?

If so, how can we assign a Field to an Additionnal ID ?

Thanks,

Anas

[former_member226]

Hi ahne ,

Yes it is possible to assign custom field value as Additional ID in SMC. For this purpose you need to implement a BADI "Review imported Interaction Contact data"(CUAN_IMPORT_IC). With this BADI you can write a small ABAP code that will copy the content of Custom Field to Contact Facet Data(ADDITIONAL_FACET).

For more details about the code, Pls check: https://blogs.sap.com/2018/01/21/how-to-assign-interactions-to-a-contact-using-unique-ids/

[former_member701491]

Hello saurabhkabra2009

Thank you we did this but the match and merge didn't work,

I'm righting the details in a new comment, because I couldn't answer here

[former_member701491]

Hi saurabhkabra2009,

1. We created a custom field "YY1_ECC_ID_ENH"
2. We created a new additional ID : C4C_ECCEXT
3. via the Badi script below we affected the value of the custom field to the additional ID :

DATA ls_add_facet LIKE LINE OF additional_facet.

IF contact_data-YY1_ECC_ID_ENH IS NOT INITIAL.

ls_add_facet-id = contact_data-YY1_ECC_ID_ENH.

ls_add_facet-id_origin = 'C4C_ECCEXT'.

APPEND ls_add_facet TO additional_facet.

ENDIF.

4. We imported the same account from ECC (id : 34651) and from C4C (id : 1001389). In the Contact origin, we can see the same value for the Additional ID : "C4C_ECCEXT" for both accounts (Please see attachement : "ORIGINAPP.JPG"), but they are still not merged

5. For the origin ID configuration, see attachement "additionalID.JPG"

It's an urgent config to be done, any help is very welcomed,

Thanks

Best regards,

Anas

[former_member226]

Hello,

I think you forgot to attach the files ORIGINAPP.JPG and additionalID.JPG. Can you please attach them?

[former_member701491]

Hi saurabhkabra2009,

I couldn't attach 4 images, please find below the remaining screenshots

5. For the origin ID configuration, see attachement "additionalID.JPG"

[former_member701491]

Hello saurabhkabra2009,

We solved the issue. We were testing this scenario, and we assigned for many accounts the same ID by mistake. So the accounts matched but not merged.

To make this perfect, we need to assign the additionnal ID only to the accounts replicated in the moment from ECC, is it possible to that with the same custom logic :

DATA ls_add_facet LIKE LINE OF additional_facet.
IF contact_data-YY1_ECC_ID_ENH IS NOT INITIAL.
ls_add_facet-id = contact_data-YY1_ECC_ID_ENH.
ls_add_facet-id_origin = 'C4C_ECCEXT'.
APPEND ls_add_facet TO additional_facet.
ENDIF.

Best regards

[former_member226]

ideally yes this coding should work. The main idea of using this BADI is to create/append a new facet be it with the above code or with some other logical code.

[former_member1277]

Hi ahne

Do SAP ERP ID and SAP C4C ID have same ID ?

Cheers

[former_member701491]

Hi kamesh.kumarrd,

An account in C4C has an internal ID (C4C ID) and an External ID (ERP ID),

So logically, In SAP Marketing Cloud, we should be able to match the same account coming from ECC with the one coming from C4C using the External ID,

I hope I answered your question. Any help is the most welcome, thanks,

BR,

Anas

[former_member1277]

Hello Anas Houari

Thanks for the clarification. To my knowledge, standard integration does not bring the External ID of C4C account into SMC. And as Tobias pointed you have to extend the iFlows inorder to get this External ID into SMC along with C4C ID with ERP specific origin ID

I believe this may help in merging based upon BP ID.