P_Matrix_Hier_Derivation

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 P_Matrix_Hier_Derivation.
-- 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: PHIERDERIV
-- Parameters: P_Hierarchy : hryid, P_KeyDate : datbi

CREATE VIEW P_Matrix_Hier_Derivation AS
SELECT
  elim_detail.hryid AS hryid,
  elim_detail.hryver AS hryver,
  elim_detail.nodecls AS nodecls,
  leaf_pair.leaf1 AS leaf1,
  leaf_pair.leaf2 AS leaf2,
  elim_detail.hryvalto AS hryvalto,
  elim_detail.hryvalfrom AS hryvalfrom,
  elim_detail.elim_member as elim_member AS P_Hierarchy,
  hrynode AS elim_member
FROM P_Matrix_Hier_Derivation_MaxLV
INNER JOIN P_Matrix_Hier_Leaf_Parent_Elim ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_Matrix_Hier_Leaf
;