C_MKT_InteractionQuery

DDL: C_MKT_INTERACTIONQUERY Type: view_entity CONSUMPTION
73 Fields 1 Data Sources

Mktg: Interactions

C_MKT_InteractionQuery is a Consumption CDS View that provides data about "Mktg: Interactions" in SAP S/4HANA. It reads from 1 data source (I_MKT_InteractionCube) and exposes 73 fields with key field InteractionUUID.

Data Sources (1)

SourceAliasJoin Type
I_MKT_InteractionCube _Mkt_Interaction from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Mktg: Interactions view
Search.searchable true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (73)

KeyFieldSource TableSource FieldDescription
KEY InteractionUUID I_MKT_InteractionCube InteractionUUID NodeID
InteractionContactOrigin
InteractionContactOriginName
InteractionContactId I_MKT_InteractionCube InteractionContactId
CommunicationMedium
CommunicationMediumName
InteractionType
InteractionTypeName
InteractionStatus I_MKT_InteractionCube InteractionStatus
InteractionStatusName
InteractionTimeStampUTC I_MKT_InteractionCube InteractionTimeStampUTC
InteractionSourceObjectType I_MKT_InteractionCube InteractionSourceObjectType
InteractionSourceObject I_MKT_InteractionCube InteractionSourceObject
CommunicationArea I_MKT_InteractionCube CommunicationArea
ReferencedOrgStructure I_MKT_InteractionCube ReferencedOrgStructure
CommunicationAreaName
CampaignID I_MKT_InteractionCube CampaignID
MarketingOrchestrationID I_MKT_InteractionCube MarketingOrchestrationID
InteractionWeightingFactor I_MKT_InteractionCube InteractionWeightingFactor
InteractionReason I_MKT_InteractionCube InteractionReason
InteractionReasonName
InteractionLanguage I_MKT_InteractionCube InteractionLanguage
InteractionAmount I_MKT_InteractionCube InteractionAmount
Currency I_MKT_InteractionCube Currency Valuation Crcy
CurrencyShortName
InteractionLatitude I_MKT_InteractionCube InteractionLatitude
InteractionLongitude I_MKT_InteractionCube InteractionLongitude
SpatialReferenceSystem I_MKT_InteractionCube SpatialReferenceSystem
DeviceType I_MKT_InteractionCube DeviceType
InteractionDeviceName I_MKT_InteractionCube InteractionDeviceName
PrecedingInteractionUUID I_MKT_InteractionCube PrecedingInteractionUUID
SourceSystemType I_MKT_InteractionCube SourceSystemType
SourceSystem I_MKT_InteractionCube SourceSystem Connected System ID
InteractionSourceObjectAddlID I_MKT_InteractionCube InteractionSourceObjectAddlID
InteractionSourceObjectStatus I_MKT_InteractionCube InteractionSourceObjectStatus
InteractionSourceTimeStampUTC I_MKT_InteractionCube InteractionSourceTimeStampUTC
CampaignContentLinkName I_MKT_InteractionCube CampaignContentLinkName
InteractionContactUUID I_MKT_InteractionCube InteractionContactUUID NodeID
RootInteraction I_MKT_InteractionCube RootInteraction
CampaignExecutionRun I_MKT_InteractionCube CampaignExecutionRun NodeID
CampaignContentLink I_MKT_InteractionCube CampaignContentLink
InteractionCreationUTCDateTime I_MKT_InteractionCube InteractionCreationUTCDateTime
InteractionLastChangedDateTime I_MKT_InteractionCube InteractionLastChangedDateTime
InteractionLastChangedByUser I_MKT_InteractionCube InteractionLastChangedByUser
InteractionContentSubject I_MKT_InteractionCube InteractionContentSubject
InteractionChannel
InteractionChannelName
InteractionContactType I_MKT_InteractionCube InteractionContactType
InteractionContactTypeName
InteractionDirection I_MKT_InteractionCube InteractionDirection
InteractionDirectionName
Country
CountryName
FullName
NumberOfInteractions
_MKT_Country _MKT_Contact _MKT_Country
_Mkt_InteractionDirection _Mkt_InteractionDirection
_Mkt_ContactType _Mkt_ContactType
_MKT_InteractionInterest _MKT_InteractionInterest
_MKT_CommMedium _MKT_CommMedium
_MKT_InteractionType _MKT_InteractionType
_MKT_InteractionStatus _MKT_InteractionStatus
_CommunicationArea _CommunicationArea
_MKT_InteractionReason _MKT_InteractionReason
_MKT_Contact _MKT_Contact
_MKT_Channel _MKT_Channel
_IBCCommFlowExecutionRun _IBCCommFlowExecutionRun
_IBCCommunicationFlow _IBCCommunicationFlow
_MKT_ContactOrigin _MKT_ContactOrigin
_Currency _Currency
_MKT_Product _MKT_Product
_MKT_InteractionTag _MKT_InteractionTag
_AuthCommArea _AuthCommArea

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_MKT_InteractionQuery.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_MKT_InteractionQuery AS
SELECT
  _Mkt_Interaction.InteractionUUID AS InteractionUUID,
  cast( _Mkt_Interaction.InteractionContactOrigin as cuan_ce_origin preserving type ) AS InteractionContactOrigin,
  _MKT_ContactOrigin._Text[1: Language=$session.system_language].InteractionContactOriginName AS InteractionContactOriginName,
  _Mkt_Interaction.InteractionContactId AS InteractionContactId,
  cast( _Mkt_Interaction.CommunicationMedium as cuan_ce_comm_medium preserving type ) AS CommunicationMedium,
  _MKT_CommMedium._Text[1: Language=$session.system_language].CommunicationMediumName AS CommunicationMediumName,
  cast( _Mkt_Interaction.InteractionType as cuan_ce_ia_type preserving type ) AS InteractionType,
  _MKT_InteractionType._Text[1: Language=$session.system_language].InteractionTypeName AS InteractionTypeName,
  _Mkt_Interaction.InteractionStatus AS InteractionStatus,
  _MKT_InteractionStatus._Text[1: Language=$session.system_language].InteractionStatusName AS InteractionStatusName,
  _Mkt_Interaction.InteractionTimeStampUTC AS InteractionTimeStampUTC,
  _Mkt_Interaction.InteractionSourceObjectType AS InteractionSourceObjectType,
  _Mkt_Interaction.InteractionSourceObject AS InteractionSourceObject,
  _Mkt_Interaction.CommunicationArea AS CommunicationArea,
  _Mkt_Interaction.ReferencedOrgStructure AS ReferencedOrgStructure,
  _CommunicationArea._Text[1: Language=$session.system_language].CommunicationAreaName AS CommunicationAreaName,
  _Mkt_Interaction.CampaignID AS CampaignID,
  _Mkt_Interaction.MarketingOrchestrationID AS MarketingOrchestrationID,
  _Mkt_Interaction.InteractionWeightingFactor AS InteractionWeightingFactor,
  _Mkt_Interaction.InteractionReason AS InteractionReason,
  _MKT_InteractionReason._Text[1: Language=$session.system_language].InteractionReasonName AS InteractionReasonName,
  _Mkt_Interaction.InteractionLanguage AS InteractionLanguage,
  _Mkt_Interaction.InteractionAmount AS InteractionAmount,
  _Mkt_Interaction.Currency AS Currency,
  _Currency._Text[1: Language = $session.system_language].CurrencyShortName AS CurrencyShortName,
  _Mkt_Interaction.InteractionLatitude AS InteractionLatitude,
  _Mkt_Interaction.InteractionLongitude AS InteractionLongitude,
  _Mkt_Interaction.SpatialReferenceSystem AS SpatialReferenceSystem,
  _Mkt_Interaction.DeviceType AS DeviceType,
  _Mkt_Interaction.InteractionDeviceName AS InteractionDeviceName,
  _Mkt_Interaction.PrecedingInteractionUUID AS PrecedingInteractionUUID,
  _Mkt_Interaction.SourceSystemType AS SourceSystemType,
  _Mkt_Interaction.SourceSystem AS SourceSystem,
  _Mkt_Interaction.InteractionSourceObjectAddlID AS InteractionSourceObjectAddlID,
  _Mkt_Interaction.InteractionSourceObjectStatus AS InteractionSourceObjectStatus,
  _Mkt_Interaction.InteractionSourceTimeStampUTC AS InteractionSourceTimeStampUTC,
  _Mkt_Interaction.CampaignContentLinkName AS CampaignContentLinkName,
  _Mkt_Interaction.InteractionContactUUID AS InteractionContactUUID,
  _Mkt_Interaction.RootInteraction AS RootInteraction,
  _Mkt_Interaction.CampaignExecutionRun AS CampaignExecutionRun,
  _Mkt_Interaction.CampaignContentLink AS CampaignContentLink,
  _Mkt_Interaction.InteractionCreationUTCDateTime AS InteractionCreationUTCDateTime,
  _Mkt_Interaction.InteractionLastChangedDateTime AS InteractionLastChangedDateTime,
  _Mkt_Interaction.InteractionLastChangedByUser AS InteractionLastChangedByUser,
  _Mkt_Interaction.InteractionContentSubject AS InteractionContentSubject,
  cast( _Mkt_Interaction.InteractionChannel as cuan_ce_channel preserving type ) AS InteractionChannel,
  _MKT_Channel._Text[1: Language=$session.system_language].InteractionChannelName AS InteractionChannelName,
  _Mkt_Interaction.InteractionContactType AS InteractionContactType,
  _Mkt_ContactType._Text[1: Language=$session.system_language].InteractionContactTypeName AS InteractionContactTypeName,
  _Mkt_Interaction.InteractionDirection AS InteractionDirection,
  _Mkt_InteractionDirection._Text[1: Language=$session.system_language].InteractionDirectionName AS InteractionDirectionName,
  _Mkt_Interaction._MKT_Contact.Country AS Country,
  _MKT_Contact._MKT_Country._Text[1: Language=$session.system_language].CountryName AS CountryName,
  _Mkt_Interaction._MKT_Contact.FullName AS FullName,
  cast( 1 as abap.int8(19) ) AS NumberOfInteractions,
  _MKT_Contact._MKT_Country AS _MKT_Country
FROM I_MKT_InteractionCube AS _Mkt_Interaction
;

Learn More