I_ProjectStructureHierNodeRltn

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_ProjectStructureHierNodeRltn.
-- 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: IPRJOBJHIER

CREATE VIEW I_ProjectStructureHierNodeRltn AS
SELECT
  cast(ProjectObjectRootNode as hryid) AS ProjectStructureHierarchy,
  P_ProjectObject_2.ProjectObjectNode AS ProjectObjectNode,
  P_ProjectObject_2.IsActiveEntity AS IsActiveEntity,
  P_ProjectObject_2.ProjectObjectParentNode AS ProjectObjectParentNode,
  P_ProjectObject_2.ProjectObjectType AS ProjectObjectType,
  P_ProjectObject_2.ProjectObjectInternalID AS ProjectObjectInternalID,
  P_ProjectObject_2.ProjectObjectExternalID AS ProjectObjectExternalID,
  P_ProjectObject_2.ProjectObjectDescription AS ProjectObjectDescription,
  P_ProjectObject_2.Project AS Project,
  P_ProjectObject_2.ProjectObjectRootNode AS ProjectObjectRootNode,
  P_ProjectObject_2.ProjectType AS ProjectType,
  P_ProjectObject_2.WBSElement AS WBSElement,
  cast('ProjectObjectNode' as abap.char( 20 )) AS ProjectHierarchyNodeType
FROM P_ProjectObject_2
LEFT OUTER JOIN I_ProjectStructureHierNodeRltn AS _Parent ON ProjectObjectParentNode = _Parent.ProjectObjectNode  -- association [1..*]
LEFT OUTER JOIN I_ProjectStructure_2 AS _ProjectStructure ON ProjectObjectNode = _ProjectStructure.ProjectObjectNode  -- association [0..1]
LEFT OUTER JOIN I_ProjectStructureHierarchy AS _ProjectStructureHierarchy ON ProjectStructureHierarchy = _ProjectStructureHierarchy.ProjectStructureHierarchy  -- association [0..1]
;