ACM_DT_DEPENDENCIES_ROW

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 ACM_DT_DEPENDENCIES_ROW.
-- 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: ACM_DT_DEPENDROW

CREATE VIEW ACM_DT_DEPENDENCIES_ROW AS
SELECT
  acmdclsrc.dclname AS dclsrc_name,
  acmrole.id AS role_id,
  acmrole.name AS role_name,
  acmrule.id AS rule_id,
  acmrule.acm_operation AS operation,
  case acmdtcondition.ruleid when acmrule.id then ' ' else 'X' end as is_functional_rule AS idthenelseXendasis_functional_rule,
  acmcte.id AS cte_id,
  acmcte.name AS cte_name,
  acmcte.view_type AS cte_viewtype,
  acmaspect.id AS aspect_id,
  acmaspect.name AS aspect_name,
  acmaspect.aspect_type AS aspect_type,
  acmasppfcgdetail.pos AS pfcgauth_pos
FROM acmrole
INNER JOIN acmdclsrc ON /* join condition not captured in parsed metadata */
INNER JOIN acmrule ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acmruleforelem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acmdtcondition ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acmaccondition ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acmcte ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acmctecolname ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acmctecolnampart ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acmctecolvalue ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acmaspect ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acmaspectpfcg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acmasppfcgdetail ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acmversion AS version ON /* join condition not captured in parsed metadata */
;