ACM_DT_DEPENDENCIES

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.
-- 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_DEPEND

CREATE VIEW ACM_DT_DEPENDENCIES AS
SELECT
  acmdclsrc.dclname AS dclsrc_name,
  acmrole.name AS role_name,
  acmrule.acm_operation AS operation,
  acmaspect.name AS aspect_name,
  acmaspect.aspect_type AS aspect_type,
  acmaspectpfcg.auth_object AS pfcg_authobj
FROM acmrole
INNER JOIN acmdclsrc ON /* join condition not captured in parsed metadata */
INNER JOIN acmrule ON /* join condition not captured in parsed metadata */
INNER JOIN acmdtcondition ON /* join condition not captured in parsed metadata */
INNER JOIN acmaccondition ON /* join condition not captured in parsed metadata */
INNER JOIN acmacauthview ON /* join condition not captured in parsed metadata */
INNER JOIN acmacfield 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 */
INNER JOIN acmaspect ON /* join condition not captured in parsed metadata */
INNER JOIN acmaspectpfcg ON /* join condition not captured in parsed metadata */
INNER JOIN acmasppfcgdetail ON /* join condition not captured in parsed metadata */
INNER JOIN acmacaviewdetail ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): acmrole
;