Inherit Account from CBO to Contacts

[lucasmillbrodt]

Dear all,

we're currently working on integration of SAP CRM Sales Channel Data into SAP Marketing Cloud by a Custom Business Object. This works nicely, however, as Channel Data in the CRM is assigned to Accounts, in the Segmentation Mode, a Channel can only be used in the Accounts mode, as the Contact mode, the Channel data is empty.

We're looking for a possibility to inherit the Channel Data of the Accounts to Contacts. Is there a solution to accomplish this without replicating all contacts into the CBO?

Best regards

Lucas Millbrodt

[MarkusGrant · Accepted solution]

Hi lucasmillbrodt,

If you don't want to replicate all contacts into your CBO then you can achieve this by making the necessary connections from Contact -> Account -> Channel with a Custom HANA View.

We've done this for a couple of scenarios and it works well.

Kind Regards,

Markus

[lucasmillbrodt · Accepted solution]

Hi markusgrant,

yes, this looks a lot like it's fitting our use-case. Could you help me out with the data sources you use to assign the necessary connections?

Best regards

Lucas

[MarkusGrant · Accepted solution]

Hi lucasmillbrodt ,

Yes, the way we did it was to connect our CBO(s) to CUAND_CE_IC_FCET to connect your account data with your CBO account data, then join that to CUAND_CE_IC_REL (relationship type filtered by 01, is contact for) to connect all the accont data to your contacts.

In the aggregation you should then have a list of your contacts with the associated accounts and CRM sales channel data (or whatever else you want to bring in).

Hope this helps!