CUAN_IA_READ_UI

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 CUAN_IA_READ_UI.
-- 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 CUAN_IA_READ_UI AS
SELECT
  Interaction.db_key AS IA_KEY,
  Interaction.id_origin AS id_origin,
  Interaction.id AS id,
  Interaction.comm_medium AS comm_medium,
  Interaction.ia_type AS ia_type,
  Interaction.timestamp AS timestamp,
  Interaction.campaign_id AS campaign_id,
  Interaction.INI_NAME AS INITIATIVE_NAME,
  Interaction.quantifier AS quantifier,
  Interaction.ia_status AS ia_status,
  Interaction.ia_reason AS ia_reason,
  Interaction.ia_language AS ia_language,
  Interaction.amount AS amount,
  Interaction.currency AS currency,
  Interaction.latitude AS latitude,
  Interaction.longitude AS longitude,
  Interaction.srid AS srid,
  Interaction.device_type AS device_type,
  Interaction.device_ft AS device_ft,
  Interaction.sw_client AS sw_client,
  Interaction.os AS os,
  Interaction.launch_url AS launch_url,
  Interaction.launch_text AS launch_text,
  Interaction.contact_key AS contact_key,
  Interaction.root_ia_key AS root_ia_key,
  Interaction.employee_id AS employee_id,
  Interaction._dataaging AS _dataaging,
  Interaction.crea_uname AS crea_uname,
  Interaction.lchg_uname AS lchg_uname,
  Interaction.content_data AS content_data,
  _InteractionReason.ia_reason_desc AS IA_REASON_T,
  _InteractionType.ia_type_desc AS IA_TYPE_T,
  _MarketingEngagement.name AS ME_NAME,
  _CommunicationMedium.comm_medium_desc AS COMM_MEDIUM_T,
  _InteractionChannel.channel AS channel,
  _InteractionChannelText.channel_desc AS CHANNEL_T,
  _InteractionInterest._InteractionInterestText.interest_item_desc AS INTEREST_ITEM_T,
  _InteractionTag.tag AS TAG_NAME,
  _AdditionalContact.contact_key AS ADD_CONTACT_KEY,
  _InteractionProduct.object_id AS object_id,
  _InteractionProduct.db_key AS ia_prod_key,
  _InteractionProduct.quantity AS quantity,
  $session.system_date AS curr_date,
  _InteractionTypeConfig.direction AS direction,
  '' AS CAMPAIGN_ID_T,
  hextobin('00000000000000000000000000000000') AS CAMPAIGN_GUID,
  '' AS DESCRIPTION
FROM cuan_ia_read AS Interaction
LEFT OUTER JOIN I_MKT_EmployeeBusinessUser AS _Employee ON employee_id = _Employee.EmployeeInternalID  -- association [0..1]
LEFT OUTER JOIN CUAN_IA_INTEREST AS _InteractionInterest ON IA_KEY = _InteractionInterest.parent_key  -- association [0..*]
LEFT OUTER JOIN cuand_ce_ia_prod AS _InteractionProduct ON IA_KEY = _InteractionProduct.parent_key  -- association [0..*]
LEFT OUTER JOIN cuand_ce_ia_tag AS _InteractionTag ON IA_KEY = _InteractionTag.parent_key  -- association [0..*]
LEFT OUTER JOIN cuand_ce_ia_ic AS _AdditionalContact ON IA_KEY = _AdditionalContact.parent_key  -- association [0..*]
LEFT OUTER JOIN cuanc_ce_ia_rs_t AS _InteractionReason ON ia_reason = _InteractionReason.ia_reason AND ia_type = _InteractionReason.ia_type AND _InteractionReason.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN cuanc_ce_iatyp_t AS _InteractionType ON ia_type = _InteractionType.ia_type AND _InteractionType.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN cuand_me_me_root AS _MarketingEngagement ON marketing_orchestration_id = _MarketingEngagement.id  -- association [0..1]
LEFT OUTER JOIN cuanc_targetcurr AS _InteractionTargetCurrency ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN cuanc_ce_cmm_m_t AS _CommunicationMedium ON comm_medium = _CommunicationMedium.comm_medium AND _CommunicationMedium.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN cuanc_ce_ia_type AS _InteractionTypeConfig ON ia_type = _InteractionTypeConfig.ia_type  -- association [0..1]
LEFT OUTER JOIN E_MKT_INTERACTION AS _InteractionExtension ON IA_KEY = _InteractionExtension.Interaction  -- association [1..1]
;