APS_IAM_BR_CS_APS

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_IAM_BR_CS_APS.
-- 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_IAM_BRCS

CREATE VIEW APS_IAM_BR_CS_APS AS
SELECT
  CommunicationScenario.communication_scenario_id AS CommunicationScenarioId,
  CommunicationScenario.communication_scenario_type AS CommunicationScenarioType,
  case when aps_com_w_cscnt.description = '' then aps_com_w_cscnt.communication_scenario_id when aps_com_w_cscnt.description is null then aps_com_w_cscnt.communication_scenario_id else aps_com_w_cscnt.description end as Description AS descriptionendasDescription,
  CommunicationScenario.scope_dependent AS ScopeDependent,
  CommunicationScenario.iam_app_id AS IamAppId,
  CommunicationScenario.abap_language_version AS AbapLanguageVersion
FROM aps_com_w_cscn AS CommunicationScenario
INNER JOIN aps_com_c_cscn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_com_w_cscnt ON /* join condition not captured in parsed metadata */
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 */
;