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

CREATE VIEW I_Mkt_Interaction AS
SELECT
  cast (Persistence.db_key as cuan_cds_interaction preserving type) AS Interaction,
  Persistence.id_origin AS InteractionContactOrigin,
  Persistence.id AS InteractionContactId,
  Persistence.comm_medium AS CommunicationMedium,
  Persistence.ia_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_api_source_object_id preserving type) AS InteractionSourceObject,
  Persistence.mkt_area_id AS MarketingArea,
  Persistence.initiative_id AS CampaignID,
  Persistence.ini_version AS CampaignVersion,
  Persistence.loc_origin AS MarketingLocationOrigin,
  Persistence.loc_id AS MarketingLocation,
  Persistence.digacc_id AS DigitalAccount,
  Persistence.digacc_type AS DigitalAccountType,
  Persistence.mkt_agreementorigin AS MKT_AgreementOrigin,
  Persistence.mkt_agreementexternalid AS MKT_AgreementExternalID,
  Persistence.marketing_orchestration_id AS MarketingOrchestrationID,
  Persistence.comm_cat_id AS CommunicationCategory,
  Persistence.quantifier AS InteractionWeightingFactor,
  cast( Persistence.valuation as cuan_sentiment_value ) AS InteractionSentimentValue,
  cast( substring( cast( Persistence.valuation as abap.char(3) ),1,1) as cuan_sentiment preserving type) AS InteractionSentiment,
  Persistence.ia_reason AS InteractionReason,
  Persistence.ia_language AS InteractionLanguage,
  Persistence.is_anonymous AS InteractionIsAnonymous,
  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.processing_time AS InteractionProcessingDuration,
  Persistence.priority AS InteractionPriority,
  Persistence.source_system_type AS SourceSystemType,
  Persistence.source_system_id AS SourceSystem,
  cast(Persistence.source_object_add_id as cuan_api_add_source_object_id preserving type) AS InteractionSourceObjectAddlID,
  Persistence.source_object_status_code AS InteractionSourceObjectStatus,
  Persistence.source_data_url AS InteractionSourceDataURL,
  cast(Persistence.source_timestamp as cuan_api_source_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 InteractionContact,
  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,
  cast(tstmp_to_dats( Persistence.timestamp, 'UTC', $session.client, 'NULL' ) as cuan_utc_date preserving type) AS InteractionUTCDate,
  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,
  cuanc_ce_ch_asgn.channel 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_MKT_IA_DigitalAsset AS _MKT_IA_DigitalAsset ON Interaction = _MKT_IA_DigitalAsset.Interaction  -- association [0..*]
LEFT OUTER JOIN I_MKT_CommMedium 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_MKT_InteractionSentiment AS _MKT_InteractionSentiment ON InteractionSentiment = _MKT_InteractionSentiment.InteractionSentiment  -- association [0..1]
LEFT OUTER JOIN I_MKT_Channel AS _MKT_Channel ON InteractionChannel = _MKT_Channel.InteractionChannel  -- association [0..1]
LEFT OUTER JOIN I_Mkt_Contact AS _Mkt_Contact ON InteractionContact = _Mkt_Contact.InteractionContact  -- association [0..1]
LEFT OUTER JOIN I_MKT_CalendarDate AS _MKT_CalendarDate ON InteractionUTCDate = _MKT_CalendarDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_MKT_CampaignVersion AS _MKT_CampaignVersion ON CampaignVersion = _MKT_CampaignVersion.CampaignVersion  -- association [0..1]
LEFT OUTER JOIN I_MKT_CampaignExecutionRun AS _MKT_CampaignExecutionRun ON CampaignExecutionRun = _MKT_CampaignExecutionRun.CampaignExecutionRun  -- association [0..1]
LEFT OUTER JOIN I_Mkt_Initiative AS _Mkt_Initiative ON CampaignID = _Mkt_Initiative.CampaignID  -- 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_MKT_MarketingArea AS _MKT_MarketingArea ON MarketingArea = _MKT_MarketingArea.MarketingArea  -- association [0..1]
;