I_UniversalHierVersion

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_UniversalHierVersion.
-- 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: IUHVRSN

CREATE VIEW I_UniversalHierVersion AS
SELECT
  ver_id AS UniversalHierarchyVersionID,
  ver_pid AS UniversalHierVersParentID,
  ver_status AS UniversalHierVersStatus,
  ver_vldfm AS UniversalHierVersValidFrom,
  ver_vldto AS UniversalHierVersValidTo,
  ver_msg AS UniversalHierVersMsg,
  ver_nbr AS UniversalHierVersNumber,
  ver_idx AS UniversalHierVersIndex,
  hier_hid AS UniversalHierHierarchyID,
  hier_catg AS UniversalHierHierarchyType,
  updated_at AS UniversalHierVersUpdatedAt,
  updated_by AS UniversalHierVersUpdatedBy,
  created_at AS UniversalHierVersCreatedAt,
  created_by AS UniversalHierVersCreatedBy,
  locked_by AS UniversalHierVersLockedBy,
  locked_at AS UniversalHierVersLockedAt,
  uhdt_vrsn.allow_legacy_tcode_usage AS UniversalHierVersIsAllowLegacy,
  uhdt_catg.hrrp_hrytype AS HierarchyType
FROM uhdt_vrsn
LEFT OUTER JOIN uhdt_catg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UniversalHierNode AS _Node ON UniversalHierarchyVersionID = _Node.UniversalHierarchyVersionID  -- association [1..*]
LEFT OUTER JOIN I_UniversalHierClassFieldVal AS _ClFdValue ON UniversalHierarchyVersionID = _ClFdValue.UniversalHierObjectID  -- association [0..*]
LEFT OUTER JOIN I_UniversalHierHierarchy AS _Hierarchy ON UniversalHierHierarchyID = _Hierarchy.UniversalHierHierarchyID AND UniversalHierHierarchyType = _Hierarchy.UniversalHierHierarchyType  -- association [1..*]
;