I_IBCCommunicationFlowBasic

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_IBCCommunicationFlowBasic.
-- 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_IBCCommunicationFlowBasic AS
SELECT
  cast(persistence.db_key as hpa_communicationflowuuid preserving type) AS CommunicationFlowUUID,
  persistence.id AS CommunicationFlow,
  persistence.name AS CommunicationFlowName,
  persistence.description AS CommunicationFlowDescription,
  persistence.comm_area_id AS CommunicationArea,
  persistence.ref_org_struc AS ReferencedOrgStructure,
  persistence.process_type AS CommunicationFlowProcessType,
  cast(persistence.crea_uname as hpa_commflowcreatedbyuser preserving type) AS CommunicationFlowCreatedByUser,
  cast(persistence.lchg_uname as hpa_commflowlastchangedbyuser preserving type) AS CommFlowLastChangedByUser,
  cast(persistence.crea_date_time as hpa_commflowcreationdatetime preserving type) AS CommFlowCreationDateTime,
  cast(persistence.lchg_date_time as hpa_commflowlastchgddatetime preserving type) AS CommFlowLastChangedDateTime,
  cast(persistence.period_start_timestmp as hpa_commflowscheduledatetime preserving type) AS CommFlowScheduleDateTime,
  cast(persistence.period_distance as hpa_commflowexecfrequencyvalue preserving type) AS CommFlowExecFrequencyValue,
  cast(persistence.period_unit as hpa_commflowexecfrequencyunit preserving type) AS CommFlowExecFrequencyUnit,
  cast(persistence.life_cycle_status as hpa_commflowlifecyclestatus preserving type) AS CommFlowLifecycleStatus,
  persistence.start_date AS CommunicationFlowStartDate,
  persistence.end_date AS CommunicationFlowEndDate,
  cast (persistence.cpg_timezone as cuan_campaign_time_zone preserving type) AS CommunicationFlowTimeZone,
  persistence.check_permission AS PermissionIsIgnored,
  persistence.origin AS CommunicationFlowOrigin
FROM cuan_d_ini_root AS persistence
LEFT OUTER JOIN I_IBCCommFlowProcessType AS _IBCCommFlowProcessType ON CommunicationFlowProcessType = _IBCCommFlowProcessType.CommunicationFlowProcessType  -- association [0..1]
LEFT OUTER JOIN I_IBCCommFlowLifeCycleStatus AS _IBCCommFlowLifeCycleStatus ON CommFlowLifecycleStatus = _IBCCommFlowLifeCycleStatus.CommFlowLifecycleStatus  -- association [1..1]
LEFT OUTER JOIN I_IBCCommunicationFlowOrigin AS _IBCCommunicationFlowOrigin ON CommunicationFlowOrigin = _IBCCommunicationFlowOrigin.CommunicationFlowOrigin  -- association [1..1]
LEFT OUTER JOIN I_IBCCommFlowRecipientList AS _IBCCommFlowRecipientList ON CommunicationFlowUUID = _IBCCommFlowRecipientList.CommunicationFlowUUID  -- association [1..*]
LEFT OUTER JOIN I_IBCCommunicationFlowInterest AS _IBCCommunicationFlowInterest ON CommunicationFlowUUID = _IBCCommunicationFlowInterest.CommunicationFlowUUID  -- association [0..*]
LEFT OUTER JOIN I_IBCCommFlowExecutionDetail AS _IBCCommFlowExecutionDetail ON CommunicationFlowUUID = _IBCCommFlowExecutionDetail.CommunicationFlowUUID  -- association [0..1]
LEFT OUTER JOIN I_User AS _IBCCommFlowCreatedByUser ON CommunicationFlowCreatedByUser = _IBCCommFlowCreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _IBCCommFlowLastChangedByUser ON CommFlowLastChangedByUser = _IBCCommFlowLastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_ReferencedOrgStructure AS _ReferencedOrgStructure ON ReferencedOrgStructure = _ReferencedOrgStructure.ReferencedOrgStructure  -- association [0..1]
LEFT OUTER JOIN I_CommunicationArea AS _CommunicationArea ON CommunicationArea = _CommunicationArea.CommunicationArea AND ReferencedOrgStructure = _CommunicationArea.ReferencedOrgStructure  -- association [0..1]
LEFT OUTER JOIN I_AuthorizedCommunicationArea AS _AuthCommArea ON CommunicationArea = _AuthCommArea.CommunicationArea AND ReferencedOrgStructure = _AuthCommArea.ReferencedOrgStructure  -- association [0..*]
LEFT OUTER JOIN E_IBCCommunicationFlow AS _Extension ON CommunicationFlowUUID = _Extension.CommunicationFlowUUID  -- association [1..1]
;