I_ProjectStructureHierNodeRltn

@AbapCatalog.sqlViewName: 'IPRJOBJHIER'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.semanticKey:  [ 'ProjectObjectExternalID', 'IsActiveEntity' ]
@EndUserText.label: 'Hierarchy for Project structure'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #XXL
@ObjectModel.usageType.dataClass: #MIXED
@AbapCatalog.preserveKey:true
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view I_ProjectStructureHierNodeRltn as select from P_ProjectObject_2
association [1..*] to I_ProjectStructureHierNodeRltn as _Parent on $projection.ProjectObjectParentNode = _Parent.ProjectObjectNode
association [0..1] to I_ProjectStructure_2         as _ProjectStructure          on $projection.ProjectObjectNode = _ProjectStructure.ProjectObjectNode
association [0..1] to I_ProjectStructureHierarchy as _ProjectStructureHierarchy on $projection.ProjectStructureHierarchy = _ProjectStructureHierarchy.ProjectStructureHierarchy
{

@ObjectModel.foreignKey.association: '_ProjectStructureHierarchy'
key cast(ProjectObjectRootNode as hryid) as ProjectStructureHierarchy,
@ObjectModel.foreignKey.association: '_ProjectStructure'
key P_ProjectObject_2.ProjectObjectNode,
@Semantics.booleanIndicator:true
P_ProjectObject_2.IsActiveEntity,
P_ProjectObject_2.ProjectObjectParentNode,
P_ProjectObject_2.ProjectObjectType,
P_ProjectObject_2.ProjectObjectInternalID,
P_ProjectObject_2.ProjectObjectExternalID,
P_ProjectObject_2.ProjectObjectDescription,
P_ProjectObject_2.Project,
P_ProjectObject_2.ProjectObjectRootNode,
P_ProjectObject_2.ProjectType,
P_ProjectObject_2.WBSElement,
cast('ProjectObjectNode' as abap.char( 20 )) as ProjectHierarchyNodeType,
_ProjectStructure,
_ProjectStructureHierarchy,
_Parent
}