I_IBCCommFlowExecutionDetail

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_IBCCommFlowExecutionDetail.
-- 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_IBCCommFlowExecutionDetail AS
SELECT
  cast(cuand_cpgexedets.mkt_orc_rt_db_key as hpa_commfloworchestrationuuid preserving type ) AS CommFlowOrchestrationUUID,
  cast(cuand_cpgexedets.campaign_key as hpa_communicationflowuuid preserving type) AS CommunicationFlowUUID,
  cuand_cpgexedets.execution_status AS CommFlowExecutionStatus,
  cast(cuand_cpgexedets.execution_status_date as hpa_commflowlastexecdatetime preserving type) AS CommFlowLastExecutionDateTime,
  cast(cuand_cpgexedets.next_execution_date as hpa_commflownextexecdatetime preserving type) AS CommFlowNextExecutionDateTime
FROM cuand_cpgexedets
LEFT OUTER JOIN I_IBCCommunicationFlow AS _IBCCommunicationFlow ON CommunicationFlowUUID = _IBCCommunicationFlow.CommunicationFlowUUID  -- association [1..1]
LEFT OUTER JOIN I_IBCCommFlowOrchestration AS _IBCCommFlowOrchestration ON CommFlowOrchestrationUUID = _IBCCommFlowOrchestration.CommFlowOrchestrationUUID  -- association [1..1]
LEFT OUTER JOIN I_IBCCommFlowExecutionStatus AS _IBCCommFlowExecutionStatus ON CommFlowExecutionStatus = _IBCCommFlowExecutionStatus.CommFlowExecutionStatus  -- association [1..1]
;