I_IBCCommFlowOrchestration

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_IBCCommFlowOrchestration.
-- 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_IBCCommFlowOrchestration AS
SELECT
  cast(cuan_d_mktorc_rt.db_key as hpa_commfloworchestrationuuid preserving type ) AS CommFlowOrchestrationUUID,
  cuan_d_mktorc_rt.initiative_id AS CommunicationFlow,
  cuan_d_mktorc_rt.comm_area_id AS CommFlowCommunicationArea,
  cuan_d_mktorc_rt.ref_org_struc AS CommFlowRefcdOrgStructure
FROM cuan_d_mktorc_rt
LEFT OUTER JOIN I_IBCCommunicationFlowTrigger AS _IBCCommunicationFlowTrigger ON CommFlowOrchestrationUUID = _IBCCommunicationFlowTrigger.CommFlowOrchestrationUUID  -- association [0..*]
LEFT OUTER JOIN I_IBCCommunicationFlow AS _IBCCommunicationFlow ON CommunicationFlow = _IBCCommunicationFlow.CommunicationFlow  -- association [1..1]
LEFT OUTER JOIN I_IBCCommFlowExecutionDetail AS _IBCCommFlowExecutionDetail ON CommFlowOrchestrationUUID = _IBCCommFlowExecutionDetail.CommFlowOrchestrationUUID  -- association [0..1]
LEFT OUTER JOIN I_ReferencedOrgStructure AS _ReferencedOrgStructure ON CommFlowRefcdOrgStructure = _ReferencedOrgStructure.ReferencedOrgStructure  -- association [0..1]
LEFT OUTER JOIN I_CommunicationArea AS _CommunicationArea ON CommFlowCommunicationArea = _CommunicationArea.CommunicationArea AND CommFlowRefcdOrgStructure = _CommunicationArea.ReferencedOrgStructure  -- association [0..1]
LEFT OUTER JOIN I_AuthorizedCommunicationArea AS _AuthCommArea ON CommFlowCommunicationArea = _AuthCommArea.CommunicationArea AND CommFlowRefcdOrgStructure = _AuthCommArea.ReferencedOrgStructure  -- association [0..*]
;