I_MKT_CONTACTRELATION

CDS View
5 Fields 4 CDS Views

Marketing: Interaction Contact Relation

I_MKT_CONTACTRELATION is a CDS View in S/4HANA. Marketing: Interaction Contact Relation. It contains 5 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
CUAN_CampaignInteraction view left_outer Campaign Interaction View
I_MKT_ContactRelSearch view from BASIC Interaction Contact Relation Search
I_MKT_CorpAcctCntctsCube view left_outer COMPOSITE Mktg: Corp Accounts with Contacts - Cube
I_MKT_IntactnCntctScoreVal view left_outer COMPOSITE Scores of Interaction Contacts

Fields (5)

KeyField CDS FieldsUsed in Views
KEY Person InteractionContact,Person 2
InteractionContact CorporateAccountUUID 2
InteractionContactOrigin InteractionContactOrigin 1
InteractnCntctFacetMainOrigin InteractnCntctFacetMainOrigin 1
IsMainContact IsMainContact 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Marketing: Interaction Contact Relation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MKT_CONTACTRELATION (
    PERSON,
    INTERACTIONCONTACT,
    INTERACTIONCONTACTORIGIN,
    INTERACTNCNTCTFACETMAINORIGIN,
    ISMAINCONTACT,
    PRIMARY KEY (PERSON)
);

Learn More