I_UniversalHierNode

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 I_UniversalHierNode.
-- 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: IUHNODE

CREATE VIEW I_UniversalHierNode AS
SELECT
  node_id AS UniversalHierNodeID,
  ver_id AS UniversalHierarchyVersionID,
  node_pid AS UniversalHierNodeParentID,
  node_rid AS UniversalHierNodeRefID,
  node_type AS UniversalHierNodeType,
  node_entity AS UniversalHierNodeEntity,
  node_level AS UniversalHierNodeLevel,
  node_seq AS UniversalHierNodeSequence,
  node_order AS UniversalHierNodeDisplayOrder,
  node_sgn AS UniversalHierNodeSign,
  node_vldfm AS UniversalHierNodeValidFrom,
  node_vldto AS UniversalHierNodeValidTo,
  node_lval AS UniversalHierNodeLowValue,
  node_hval AS UniversalHierNodeHighValue,
  created_at AS UniversalHierNodeCreatedAt,
  created_by AS UniversalHierNodeCreatedBy,
  updated_at AS UniversalHierNodeUpdatedAt,
  updated_by AS UniversalHierNodeUpdatedBy
FROM uhdt_node
LEFT OUTER JOIN I_UniversalHierNodeText AS _Text ON UniversalHierNodeID = _Text.UniversalHierNodeID  -- association [0..*]
LEFT OUTER JOIN I_UniversalHierVersion AS _Version ON UniversalHierarchyVersionID = _Version.UniversalHierarchyVersionID  -- association [1..1]
LEFT OUTER JOIN I_UniversalHierClassFieldVal AS _ClFdValue ON UniversalHierNodeID = _ClFdValue.UniversalHierObjectID  -- association [0..*]
;