I_MKT_Interaction

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 I_MKT_Interaction.
-- 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 I_MKT_Interaction AS
SELECT
  cast (Persistence.db_key as cuan_cds_interaction preserving type) AS Interaction,
  cast( Persistence.id_origin as cuan_ce_origin preserving type ) AS InteractionContactOrigin,
  Persistence.id AS InteractionContactId,
  cast( Persistence.comm_medium as cuan_ce_comm_medium preserving type ) AS CommunicationMedium,
  cast( Persistence.ia_type as cuan_ce_ia_type preserving type ) AS InteractionType,
  Persistence.ia_status AS InteractionStatus,
  cast(Persistence.timestamp as cuan_api_timestamp_utc preserving type) AS InteractionTimeStampUTC,
  Persistence.source_object_type AS InteractionSourceObjectType,
  cast(Persistence.source_object_id as cuan_ce_ia_source_object_id preserving type) AS InteractionSourceObject,
  Persistence.comm_area_id AS CommunicationArea,
  Persistence.ref_org_struc AS ReferencedOrgStructure,
  Persistence.initiative_id AS CampaignID,
  Persistence.marketing_orchestration_id AS MarketingOrchestrationID,
  Persistence.quantifier AS InteractionWeightingFactor,
  Persistence.ia_reason AS InteractionReason,
  Persistence.bounce_reason AS BounceReason,
  Persistence.bounce_reason_desc AS BounceReasonName,
  Persistence.ia_language AS InteractionLanguage,
  Persistence.amount AS InteractionAmount,
  Persistence.currency AS Currency,
  Persistence.latitude AS InteractionLatitude,
  Persistence.longitude AS InteractionLongitude,
  Persistence.srid AS SpatialReferenceSystem,
  Persistence.device_type AS DeviceType,
  Persistence.device_ft AS InteractionDeviceName,
  Persistence.sw_client AS InteractionSoftwareClientName,
  Persistence.os AS InteractionOperatingSystemName,
  cast(Persistence.parent_ia_key as cuan_cds_parent_interaction preserving type) AS PrecedingInteractionUUID,
  Persistence.source_system_type AS SourceSystemType,
  Persistence.source_system_id AS SourceSystem,
  cast(Persistence.source_object_add_id as cuan_ce_ia_add_source_obj_id preserving type) AS InteractionSourceObjectAddlID,
  Persistence.source_object_status_code AS InteractionSourceObjectStatus,
  Persistence.source_data_url AS InteractionSourceDataURL,
  cast(Persistence.source_timestamp as cuan_ce_ia_src_timestamp_utc preserving type) AS InteractionSourceTimeStampUTC,
  Persistence.launch_url AS CampaignContentLinkURL,
  cast( Persistence.launch_text as cuan_cmpgn_content_link_name preserving type) AS CampaignContentLinkName,
  Persistence.referral_source AS ReferralSource,
  Persistence.referral_source_category AS ReferralSourceCategory,
  cast(Persistence.contact_key as cuan_cds_ia_contact preserving type) AS InteractionContactUUID,
  Persistence.projection_key AS InteractionCntctProjectionUUID,
  cast(Persistence.root_ia_key as cuan_cds_root_ia_uuid preserving type) AS RootInteraction,
  cast(Persistence.execution_run_key as cuan_cds_cpg_exe_run_uuid preserving type) AS CampaignExecutionRun,
  cast(Persistence.survey_response_key as cuan_cds_survey_response_uuid preserving type) AS SurveyResponseUUID,
  cast(Persistence.launch_link_key as cuan_cds_cpg_content_link_uuid preserving type) AS CampaignContentLink,
  Persistence.employee_id AS EmployeeInternalID,
  Persistence.employee_role AS EmployeeRole,
  cast(Persistence.crea_date_time as cuan_ia_crea_date_time preserving type) AS InteractionCreationUTCDateTime,
  cast(Persistence.lchg_date_time as cuan_api_last_change_date_time preserving type) AS InteractionLastChangedDateTime,
  Persistence.lchg_uname AS InteractionLastChangedByUser,
  Persistence.content_title AS InteractionContentSubject,
  Persistence.content_data AS InteractionContent,
  Persistence.utm_source AS MarketingUTMSource,
  Persistence.utm_medium AS MarketingUTMMedium,
  Persistence.utm_campaign AS MarketingUTMCampaign,
  Persistence.utm_term AS MarketingUTMTerm,
  Persistence.utm_content AS MarketingUTMContent,
  cast( cuanc_ce_ch_asgn.channel as cuan_ce_channel preserving type ) AS InteractionChannel
FROM cuand_ce_ia_rt AS Persistence
LEFT OUTER JOIN I_MKT_InteractionInterest AS _MKT_InteractionInterest ON Interaction = _MKT_InteractionInterest.Interaction  -- association [0..*]
LEFT OUTER JOIN I_IBCCommunicationMedium AS _MKT_CommMedium ON CommunicationMedium = _MKT_CommMedium.CommunicationMedium  -- association [0..1]
LEFT OUTER JOIN I_MKT_InteractionType AS _MKT_InteractionType ON InteractionType = _MKT_InteractionType.InteractionType  -- association [0..1]
LEFT OUTER JOIN I_MKT_InteractionStatus AS _MKT_InteractionStatus ON InteractionStatus = _MKT_InteractionStatus.InteractionStatus  -- association [0..1]
LEFT OUTER JOIN I_MKT_InteractionReason AS _MKT_InteractionReason ON InteractionType = _MKT_InteractionReason.InteractionType AND InteractionReason = _MKT_InteractionReason.InteractionReason  -- association [0..1]
LEFT OUTER JOIN I_IBCInteractionChannel AS _MKT_Channel ON InteractionChannel = _MKT_Channel.InteractionChannel  -- association [0..1]
LEFT OUTER JOIN I_IBCContact AS _MKT_Contact ON InteractionContactUUID = _MKT_Contact.InteractionContactUUID  -- association [0..1]
LEFT OUTER JOIN I_IBCCommFlowExecutionRun AS _IBCCommFlowExecutionRun ON CampaignExecutionRun = _IBCCommFlowExecutionRun.CommFlowExecutionRunUUID  -- association [0..1]
LEFT OUTER JOIN I_IBCCommunicationFlow AS _IBCCommunicationFlow ON CampaignID = _IBCCommunicationFlow.CommunicationFlow  -- association [0..1]
LEFT OUTER JOIN I_MKT_Contactorigin AS _MKT_ContactOrigin ON InteractionContactOrigin = _MKT_ContactOrigin.InteractionContactOrigin  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ReferencedOrgStructure AS _ReferencedOrgStructure ON ReferencedOrgStructure = _ReferencedOrgStructure.ReferencedOrgStructure  -- association [0..1]
LEFT OUTER JOIN I_CommunicationArea AS _CommunicationArea ON CommunicationArea = _CommunicationArea.CommunicationArea AND ReferencedOrgStructure = _CommunicationArea.ReferencedOrgStructure  -- association [0..1]
LEFT OUTER JOIN I_AuthorizedCommunicationArea AS _AuthCommArea ON CommunicationArea = _AuthCommArea.CommunicationArea AND ReferencedOrgStructure = _AuthCommArea.ReferencedOrgStructure  -- association [0..*]
;