C_APS_COM_CA

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 C_APS_COM_CA.
-- 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.
-- SQL view name: CAPS_CA

CREATE VIEW C_APS_COM_CA AS
SELECT
  db_key,
  CommSyst,
  CommunicationScenario,
  CommArrgmtName,
  CommArrgmtDescription,
  CreationDateTime,
  CommArrgmtEditStatus,
  _CommunicationSystem.CommSyst AS CommSystID,
  _CommunicationSystem.CommSystName AS CommSystName,
  _CommunicationSystem.CommSystHostName AS CommSystHostName,
  _CommunicationSystem.CommSystUIHostName AS CommSystUIHostName,
  _CommunicationSystem.SAMLBAPEnabled AS CommSystSAMLBAPEnabled,
  _CommunicationScenario.Description AS CommScenarioDescription,
  CommunicationScenarioType,
  _CommunicationScenario.IsAllowedCreateByKey AS IsAllowedCreateByKey,
  _OwnSystem.CommSyst AS OwnSystemID,
  cast('' as abap.char( 256 ) ) AS OwnSystemTenantApiUrl,
  _CommunicationSystem.DestinationService AS DestinationService,
  _CommunicationSystem.IsABAPSystem AS IsSapCloudConnectorActive,
  _CreatedBy.UserDescription AS CreatedByUserName,
  CreatedByUser AS CreatedByUserID,
  LastChangeDateTime,
  _ChangedBy.UserDescription AS LastChangedByUserName,
  LastChangedByUser AS LastChangedByUserID
FROM I_APS_COM_CA_TP
LEFT OUTER JOIN C_APS_COM_CA_APIKEY AS _DestinationProperty ON db_key = _DestinationProperty.parent_key AND _DestinationProperty.InterfaceKeyID = '0001'  -- association [0..1]
LEFT OUTER JOIN C_APS_COM_CA_APIKEY AS _API_Keys ON db_key = _API_Keys.parent_key  -- association [0..*]
LEFT OUTER JOIN C_APS_COM_CA_INB_DEFAULTS AS _InboundDefaults ON db_key = _InboundDefaults.parent_key  -- association [0..1]
LEFT OUTER JOIN C_APS_COM_CA_INB_SRV AS _InboundServices ON db_key = _InboundServices.parent_key  -- association [0..*]
LEFT OUTER JOIN C_APS_COM_CA_OUTB_DEFAULTS AS _OutboundDefaults ON db_key = _OutboundDefaults.parent_key  -- association [0..1]
LEFT OUTER JOIN C_APS_COM_CA_OUT_SRV AS _OutboundServices ON db_key = _OutboundServices.parent_key  -- association [0..*]
LEFT OUTER JOIN aps_user_ddl AS _ChangedBy ON _ChangedBy.UserID = LastChangedByUserID  -- association [0..1]
LEFT OUTER JOIN aps_user_ddl AS _CreatedBy ON _CreatedBy.UserID = CreatedByUserID  -- association [0..1]
LEFT OUTER JOIN Aps_Com_Cs_D2_Root_C AS _CommunicationSystem ON _CommunicationSystem.db_key = CommSyst  -- association [0..1]
LEFT OUTER JOIN Aps_Com_Cs_D2_Root_C AS _OwnSystem ON _OwnSystem.IsOwnSystem = 'X'  -- association [1..1]
LEFT OUTER JOIN Aps_Com_Cs_D2_Inbound_C AS _InboundCommSysUser ON _InboundCommSysUser.parent_key = CommSyst  -- association [0..*]
LEFT OUTER JOIN Aps_Com_Cs_D2_Outbound_C AS _OutboundCommSysUser ON _OutboundCommSysUser.parent_key = CommSyst  -- association [0..*]
LEFT OUTER JOIN I_APS_COM_COMM_SCEN_A AS _CommunicationScenario ON _CommunicationScenario.CommunicationScenarioID = CommunicationScenario  -- association [0..1]
LEFT OUTER JOIN C_APS_COM_CA_CHANGE_DOCUMENT AS _ChangeDocument ON _ChangeDocument.CommArrangementUUID = db_key  -- association [0..*]
LEFT OUTER JOIN C_APS_COM_CA_CDOC AS _ChangeDocs ON _ChangeDocs.db_key = db_key  -- association [0..*]
;