C_MKT_InteractionAllQuery

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_InteractionAllQuery.
-- 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_InteractionAllQuery 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_Interaction.BounceReason AS BounceReason,
  _Mkt_Interaction.BounceReasonName AS BounceReasonName,
  _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.InteractionSoftwareClientName AS InteractionSoftwareClientName,
  _Mkt_Interaction.InteractionOperatingSystemName AS InteractionOperatingSystemName,
  _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,
  cast(_Mkt_Interaction.MarketingUTMSource as cuan_ce_ia_utm_param_source preserving type) AS MarketingUTMSource,
  cast(_Mkt_Interaction.MarketingUTMMedium as cuan_ce_ia_utm_param_medium preserving type) AS MarketingUTMMedium,
  cast(_Mkt_Interaction.MarketingUTMCampaign as cuan_ce_ia_utm_param_campaign preserving type) AS MarketingUTMCampaign,
  cast(_Mkt_Interaction.MarketingUTMTerm as cuan_ce_ia_utm_param_term preserving type) AS MarketingUTMTerm,
  cast(_Mkt_Interaction.MarketingUTMContent as cuan_ce_ia_utm_param_content preserving type) AS MarketingUTMContent,
  _Mkt_Interaction.InteractionContactUUID AS InteractionContactUUID,
  _Mkt_Interaction.RootInteraction AS RootInteraction,
  _Mkt_Interaction.CampaignExecutionRun AS CampaignExecutionRun,
  _Mkt_Interaction.ImportHeaderUUID AS ImportHeaderUUID,
  _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_InteractionContactType._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,
  _Mkt_Interaction._MKT_Contact.PersonFullName AS PersonFullName,
  cast( 1 as abap.int8(19) ) AS NumberOfInteractions,
  _Mkt_Interaction.IsMarkedForDeletion AS IsMarkedForDeletion,
  _MKT_Contact._MKT_Country AS _MKT_Country
FROM I_MKT_InteractionAllCube AS _Mkt_Interaction
;