I_MKT_InteractionContactEvent

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_InteractionContactEvent.
-- 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_InteractionContactEvent AS
SELECT
  db_key AS InteractionContactEventUUID,
  root_key AS InteractionContactUUID,
  parent_key AS InteractionContactFacetUUID,
  id_origin AS InteractionContactOrigin,
  id AS InteractionContactId,
  event AS InteractionContactEventType,
  reason AS InteractionContactEventReason,
  timestamp AS IntactnContactEventUTCDateTime,
  matching_id_origin AS IntactnCntctMatchingOrigin,
  matching_id AS IntactnCntctMatchingId,
  matching_group_id_origin AS IntactnCntctMatchingGrpOrigin,
  matching_group_id AS IntactnCntctMatchingGrpId,
  _CONTACT_ORIGIN_DESCRIPTION.InteractionContactOriginName AS InteractionContactOriginName,
  _MATCHING_ORIGIN_DESCRIPTION.InteractionContactOriginName AS IntactnCntctMatchingOriginName,
  _MATCHING_GRP_ORIGIN_DSCRPTON.InteractionContactOriginName AS IntactnCntctMtchgGrpOriginName,
  _MKT_IntactnCntctEventType._Text.InteractionCntctEventTypeName AS InteractionCntctEventTypeName,
  _MKT_IntactnCntctEventReason._Text.IntactnCntctEventReasonName AS IntactnCntctEventReasonName
FROM cuand_ce_ic_evhs
LEFT OUTER JOIN I_MKT_Contactorigintext AS _CONTACT_ORIGIN_DESCRIPTION ON InteractionContactOrigin = _CONTACT_ORIGIN_DESCRIPTION.InteractionContactOrigin AND _CONTACT_ORIGIN_DESCRIPTION.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_MKT_Contactorigintext AS _MATCHING_ORIGIN_DESCRIPTION ON IntactnCntctMatchingOrigin = _MATCHING_ORIGIN_DESCRIPTION.InteractionContactOrigin AND _MATCHING_ORIGIN_DESCRIPTION.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_MKT_Contactorigintext AS _MATCHING_GRP_ORIGIN_DSCRPTON ON IntactnCntctMatchingGrpOrigin = _MATCHING_GRP_ORIGIN_DSCRPTON.InteractionContactOrigin AND _MATCHING_GRP_ORIGIN_DSCRPTON.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_MKT_IntactnCntctEventType AS _MKT_IntactnCntctEventType ON InteractionContactEventType = _MKT_IntactnCntctEventType.InteractionCntctEventTypeCode  -- association [1..1]
LEFT OUTER JOIN I_MKT_IntactnCntctEventReason AS _MKT_IntactnCntctEventReason ON InteractionContactEventReason = _MKT_IntactnCntctEventReason.InteractionCntctEventRsnCode  -- association [1..1]
;