Add Attributes to Data Source SAP_CE_INTERACTIONS

[SCHNEIDERT]

Hi all,

for the Data Source SAP_CE_INTERACTIONS there are the fields COUNTRY and CITY1 for example. So when I create an Export Definition I can add those fields and use them in the export data.

Now I need also the fields Street and House Number of the Contacts in the Source to add them to Export Definition.

Is there any other way than building a custom view?

BR Tobias

[former_member226 · Accepted solution]

Hi,

There are 2 points to consider:

1. Attributes CITY1 or COUNTRY for DS SAP_CE_INTERACTIONS comes from CUAND_CE_IA_RT which means these are interaction relevant addresses and not the contact address. Hence you might see a few times data is not exactly what you were looking from contact master data point fo view.

2. As mentioned in point 1, since these fields come from CUAND_CE_IA_RT hence it is possible to include other intraction address fields like street or House Numer for them using custom views.

[SCHNEIDERT · Accepted solution]

Hi saurabhkabra2009,

first of all thanks to you for your response.

But when importing interactions I don't add address data. So I thought it fetches these address data from the CUAND_CE_IC_ROOT table, doesn't it?

What I'm trying to do is to get the Address data (COUNTRY, CITY1, STREET and HOUSE_NUM1) of all the Contacts that have an Opt-Out for a specific Communication Category. I want to have them as Excel/CSV-Export

Therefore I would like to use the segmentation profile All Interactions, use interaction type and communication category, build a target group including the contact data for the contacts that have that interaction and export the data via Export Definition.

So do you think the data I would get for contacts are not correct?

[SCHNEIDERT · Accepted solution]

But maybe the better way to get the data I need would be to build a custom view using the CUAND_CE_MP_ROOT table and use the All Contacts Segmentation Profile, right?

[former_member226 · Accepted solution]

Hi Tobias,

I just re-validated in the system and I see that SAP donot expose CUAND_CE_IA_RT level address data as part of API or segmentation view. So, for DS SAP_CE_INTERACTIONS values comes from CUAND_CE_IC_ROOT. Hence you can ignore my last comment as it was valid only during the initial days of yMkt (maybe around 1705 or so...) You can very well use those fields from DS SAP_CE_INTERACTIONSfor extracting address information by creating a custom hana view or extending the existing view to include other address related information from CUAND_CE_IC_ROOT table.

[SCHNEIDERT · Accepted solution]

Hi Saurabh, thanks for validation!