Extracting Target Group Members to SAP BW

[viet3000]

Hi guys,

we are extracting the CDS View I_MKT_TgtGrpIntactnCntct from SAP Marketing Cloud to SAP BW/4HANA because we need to tell the exact members (interaction contacts) of a target group for analytics purposes. Regarding that CDS View we have two questions and since we cannot look into the modelling of the CDS Views in the Cloud system, I pose the questions here for the experts:

1. Our expectation was that we only have one record for the combination of interaction contact and target group. However, we also have these combinations per InteractionContactOrigin (facets). What is the purpose of this field and why is it part of the CDS View?
2. For some values of InteractionContactOrigin, the field CreationDateTime is empty. What is the definition of CreationDateTime?

[jayce_wang · Accepted solution]

Hi Duy-Viet,

CDS Views are not only used for extracting data to BW system but also be adapted to other standard scenarios.

1. For I_MKT_TgtGrpIntactnCntct, it can be used to fetch all IDs of target group members. For example, it can be used to find all SAP_C4C_BUPA IDs of target group members easily which can be adapted to more scenarios.

I am not familiar with the BW integration, but if possible, maybe you can use SQL statement like SELECT DISTINCT to avoid duplicated interaction contact UUID.

2. As mentioned in point 1, system gets all IDs including additional IDs and technical IDs generated by system automatically. For these IDs, there are no CreationDateTime maintained. And as far as I know, the CreationDateTime (timestamp) of system IDs is used to decide whether to overwrite existing data on data import.

Hope the information above would be helpful.

Best regards,

Jayce

[viet3000 · Accepted solution]

Hi Jayce,

Big thank you for your answer. It is helpful indeed.

Best regards,

Viet