I_IBCCommunicationFlowTrigger

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_IBCCommunicationFlowTrigger.
-- 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_IBCCommunicationFlowTrigger AS
SELECT
  cast(cuan_d_mktorc_tr.db_key as cuan_cpg_autom_trigger_uuid preserving type ) AS CommunicationFlowTriggerUUID,
  cast(cuan_d_mktorc_tr.parent_key as hpa_commfloworchestrationuuid preserving type ) AS CommFlowOrchestrationUUID,
  cast(cuan_d_mktorc_tr.trigger_type as cuan_campaigntriggertype preserving type ) AS CommunicationFlowTriggerType,
  cast(cuan_d_mktorc_tr.is_non_event as cuan_campaigntriggerisnobranch preserving type ) AS CommFlowTriggerIsNoBranch,
  cast(cuan_d_mktorc_tr.is_start_trigger as cuan_campaigntriggerisstart preserving type ) AS CommFlowTriggerIsFor1stAction,
  cast(cuan_d_mktorc_tr.ordinal_number as cuan_campaigntriggernumber preserving type) AS CommFlowTriggerSequence
FROM cuan_d_mktorc_tr
LEFT OUTER JOIN I_IBCCommFlowOrchestration AS _IBCCommFlowOrchestration ON CommFlowOrchestrationUUID = _IBCCommFlowOrchestration.CommFlowOrchestrationUUID  -- association [1..1]
LEFT OUTER JOIN I_IBCCommunicationFlowAction AS _IBCCommunicationFlowAction ON CommunicationFlowTriggerUUID = _IBCCommunicationFlowAction.CommunicationFlowTriggerUUID  -- association [0..*]
LEFT OUTER JOIN I_IBCInteractionType AS _IBCCommFlowTriggerType ON CommunicationFlowTriggerType = _IBCCommFlowTriggerType.InteractionType  -- association [1..1]
;