Can not find fields in a CDS view

[j_cortesp]

Hi,

I´m trying to test the creation of interactions (POST method) with the API_MKT_INTERACTION_SRV service throught Postman. I have created some interactions this way and the service is working well. Also using GET method I receive the interactions whit all fields that I created vía Postman.

In this creation I´m using to entities, one for products (InteractionProducts) and the other for additional objects (InteractionAdditionalObjects) and all the fields are filled well when request GET.

So I need to know in which view this fields data are storaged because I try to find this in I_Mkt_Interaction view but can´t find. Thank you in advance.

JD

[former_member226 · Accepted solution]

Hi,

You can find the corresponding fields directly in the "Browse Interaction Data" app under the "Data Stewardship" group on the Home page.

If you are specifically looking for data using CDS view where you can see Interaction and its related product then you have to create a custom CDS view using I_Mkt_Interaction as primary and I_MKT_InteractionProduct as Secondary(Associated) data source. Once done then you can create analytical query for external consul[tion.

Thanks

Saurabh

[Former Member]

Hi Saurabh, thank you for replying.

You are right, in the "Browse interaction data" app I can see the fields under "Additional Object References" section, the data it´s correct (attachment 1). But neither in I_Mkt_Interaction view and I_MKT_InteractionProduct view those fields exists. So, create an association between this views will not show this fields. I found a view named A_MKT_InteractionAdditionalObj in "View browser" (attachment 2) but this view doesn´t exist in "custom CDS views" (attachment 3).

interactionerrorv1.jpginteractionerrorv2.jpginteractionerrorv3.jpgI need to create a query (first a view) to see the Interactions and the interaction additional objects fields. Thank you in advance. JD

[former_member226]

Hi Juan,

Got your point. For additional objects ,as per me, I believe SAP hasn't released any CDS view which can be used for reporting purposes.

You may need to raise an idea or reach out to SAP support if they can do somehting from backend for you.

Thanks

Saurabh