APS_COM_CSCN_UI

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 APS_COM_CSCN_UI.
-- 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: APS_COMCSCN_UI

CREATE VIEW APS_COM_CSCN_UI AS
SELECT
  CommunicationScenarioID,
  Description,
  CommunicationScenarioType,
  ScenarioTypeText.Description AS CommunicationScenarioTypeText,
  cast ( case when CommunicationScenarioID not like 'SAP_%' then 'X' else '' end as boole_d preserving type ) AS isCustumCommunicationScenario,
  ScopeDependent,
  ContainInbound,
  ContainOutbound,
  IsDeprecated,
  DeprecatedWithRelease,
  OBAuthenticationPSEexists,
  OBSigningPSEexists,
  OBEncryptionPSEexists,
  IBBasicAuthSupported,
  IBCertificateAuthSupported,
  IBOAuth2AuthSupported,
  OBNoneAuthSupported,
  OBBasicAuthSupported,
  OBCertificateAuthSupported,
  OBOAuth1AuthSupported,
  OBOAuth2AuthSupported,
  OBOAuth2MtlsAuthSupported,
  AllowedCaInstances,
  AllowedCaInstancesT.Description AS AllowedCaInstancesText,
  InboundTrustPSEID,
  InboundSignPSEID,
  InboundEncryptPSEID,
  InboundRoleId,
  DBMSUserRequired,
  SAPManagedUserBName,
  OutboundAuthPSEID,
  OutboundTrustPSEID,
  OutboundSignPSEID,
  OutboundEncryptPSEID,
  OutboundOAuth2ClientProfile,
  OutboundOAuth2TargetPath,
  OBOAuth2GranttypeChar,
  OutboundOAuth2GrantTypeText.Description AS OutboundOAuth2GrantTypeText,
  OutboundOAuth2MultiCfg,
  CreateTimestamp,
  IsAllowedCreateByKey,
  ABAPLanguageVersion,
  ChangeTime,
  _Component.ach AS Component,
  iam_app_id,
  InboundServices,
  OutboundServices,
  CommunicationArrangement,
  ScopeItems,
  API_Keys,
  Successors
FROM I_APS_COM_COMM_SCEN_A AS CommunicationScenario
LEFT OUTER JOIN aps_iam_w_app AS app ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_c_app AS app_scope ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN APS_COM_CSCN_API_KEY_UI AS API_Keys ON CommunicationScenarioID = API_Keys.CommunicationScenarioID  -- association [0..*]
LEFT OUTER JOIN APS_COM_CSCN_INB_UI AS InboundServices ON CommunicationScenarioID = InboundServices.communication_scenario_id  -- association [0..*]
LEFT OUTER JOIN APS_COM_CSCN_OB_UI AS OutboundServices ON CommunicationScenarioID = OutboundServices.communication_scenario_id  -- association [0..*]
LEFT OUTER JOIN APS_COM_CSCN_CA_UI AS CommunicationArrangement ON CommunicationScenarioID = CommunicationArrangement.CommunicationScenario  -- association [0..*]
LEFT OUTER JOIN aps_com_cscn_si_ui AS ScopeItems ON CommunicationScenarioID = ScopeItems.CommunicationScenarioID  -- association [0..*]
LEFT OUTER JOIN APS_COM_CSCN_CA_COUNT AS CommunicationArrangementCount ON CommunicationScenarioID = CommunicationArrangementCount.CommunicationScenarioID  -- association [0..1]
LEFT OUTER JOIN APS_COM_CSCN_EVENT_SRV_COUNT AS EventServicesCount ON CommunicationScenarioID = EventServicesCount.CommunicationScenarioID  -- association [0..1]
LEFT OUTER JOIN I_Aps_Com_Domain_Value_Text AS ScenarioTypeText ON ScenarioTypeText.Name = 'APS_COM_CSCN_TYPE' AND ScenarioTypeText.Code = CommunicationScenario.CommunicationScenarioType AND ScenarioTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Aps_Com_Domain_Value_Text AS AllowedCaInstancesT ON AllowedCaInstancesT.Name = 'APS_COM_CSCN_ALLOWED_CA_INST' AND AllowedCaInstancesT.Code = CommunicationScenario.AllowedCaInstances AND AllowedCaInstancesT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Aps_Com_Domain_Value_Text AS OutboundOAuth2GrantTypeText ON OutboundOAuth2GrantTypeText.Name = 'OA2C_GRANTTYPE' AND OutboundOAuth2GrantTypeText.Code = CommunicationScenario.OBOAuth2GranttypeChar AND OutboundOAuth2GrantTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN APS_TADIR AS _Component ON _Component.obj_name = CommunicationScenarioID AND _Component.object = 'SCO1' AND _Component.pgmid = 'R3TR'  -- association [0..1]
LEFT OUTER JOIN APS_COM_CSCN_SUCCESSOR_UI AS Successors ON CommunicationScenarioID = Successors.cscn_id  -- association [0..*]
;