Custom CDS View for Customer and Contact

[mracantonius1]

Hi - I am currently creating a customer CDS view for API extraction. I want to return the Corporate Account to Contact relationship easily. I am currently using I_MKT_ContactRelationData & I_Mkt_Contact but it's not showing the relationship if I filter on the corporate account.

Is there a different data source we should use?

Cheers,

Marc

[mracantonius1 · Accepted solution]

I linked I_MKT_ContactRelationData & I_MKT_Company. The join to be used are I_MKT_ContactRelationData.RelatedInteractionContactUUID = I_MKT_Company.Company

[andreas_bettin]

Dear Marc,

the RelationData view shows unidirectional from the contact person to the account and not in both directions.

Best regards Andreas Bettin