APS_COM_CS_AUTH_F

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_CS_AUTH_F.
-- 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_COM_CS_A_F

CREATE VIEW APS_COM_CS_AUTH_F AS
SELECT
  instance.scenario_id AS ScenarioId,
  default.Objct AS ObjectId,
  instance.uuid AS ParentId,
  default.Field AS Field,
  text.FieldText AS Description,
  case when actvt.activity_field = default.Field then 'X' when default.Field = 'ACTVT' then 'X' else '' end as IsActvt AS FieldACTVTthenXelseendasIsActvt
FROM aps_com_cs_auth_default AS default
INNER JOIN aps_com_w_scnaui AS instance ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_au AS actvt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_auth_field_ddl AS text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_com_cs_auth_v AS _authValues ON _authValues.ParentId = instance.uuid AND _authValues.Field = default.Field  -- association [0..*]
;