C_MKT_InteractionQuery

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.
-- SQL view name: CMKTINTACTNQ

CREATE VIEW C_MKT_InteractionQuery AS
SELECT
  _Mkt_Interaction.InteractionUUID AS InteractionUUID,
  _Mkt_Interaction.InteractionContactOrigin AS InteractionContactOrigin,
  _MKT_Contactorigin._Text[1: Language=$session.system_language].InteractionContactOriginName AS InteractionContactOriginName,
  _Mkt_Interaction.InteractionContactId AS InteractionContactId,
  _Mkt_Interaction.CommunicationMedium AS CommunicationMedium,
  _MKT_CommMedium._Text[1: Language=$session.system_language].CommunicationMediumName AS CommunicationMediumName,
  _Mkt_Interaction.InteractionType 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.MarketingArea AS MarketingArea,
  _MKT_MarketingArea._Text[1: Language=$session.system_language].MarketingAreaName AS MarketingAreaName,
  _Mkt_Interaction.CampaignID AS CampaignID,
  _Mkt_Interaction.CampaignVersion AS CampaignVersion,
  _Mkt_Interaction.MarketingLocationOrigin AS MarketingLocationOrigin,
  _Mkt_Interaction.MarketingLocation AS MarketingLocation,
  _Mkt_Interaction.DigitalAccount AS DigitalAccount,
  _Mkt_Interaction.DigitalAccountType AS DigitalAccountType,
  _Mkt_Interaction.MKT_AgreementOrigin AS MKT_AgreementOrigin,
  _Mkt_Interaction.MKT_AgreementExternalID AS MKT_AgreementExternalID,
  _Mkt_Interaction.MarketingOrchestrationID AS MarketingOrchestrationID,
  _Mkt_Interaction.InteractionWeightingFactor AS InteractionWeightingFactor,
  _Mkt_Interaction.InteractionSentimentValue AS InteractionSentimentValue,
  _Mkt_Interaction.InteractionSentiment AS InteractionSentiment,
  _MKT_InteractionSentiment._Text[1: Language=$session.system_language].InteractionSentimentName AS InteractionSentimentName,
  _Mkt_Interaction.InteractionReason AS InteractionReason,
  _MKT_InteractionReason._Text[1: Language=$session.system_language].InteractionReasonName AS InteractionReasonName,
  _Mkt_Interaction.InteractionLanguage AS InteractionLanguage,
  _Mkt_Interaction.InteractionIsAnonymous AS InteractionIsAnonymous,
  _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.InteractionUTCDate AS InteractionUTCDate,
  _Mkt_Interaction.InteractionCreationUTCDateTime AS InteractionCreationUTCDateTime,
  _Mkt_Interaction.InteractionLastChangedDateTime AS InteractionLastChangedDateTime,
  _Mkt_Interaction.InteractionLastChangedByUser AS InteractionLastChangedByUser,
  _Mkt_Interaction.InteractionContentSubject AS InteractionContentSubject,
  _Mkt_Interaction.InteractionChannel 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.InteractionUTCYear AS InteractionUTCYear,
  _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
;