I_ProjectStructure_3

DDL: I_PROJECTSTRUCTURE_3 SQL: IPROJSTRUC3 Type: view COMPOSITE Package: ODATA_PS_COST_PROJLINEITEM

Project Structure for Line Items

I_ProjectStructure_3 is a Composite CDS View that provides data about "Project Structure for Line Items" in SAP S/4HANA. It reads from 1 data source (I_ProjStrucHierarchyNode) and exposes 13 fields with key field ProjectObjectNode. It has 1 association to related views. Part of development package ODATA_PS_COST_PROJLINEITEM.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_ProjStrucHierarchyNode I_ProjStrucHierarchyNode from

Parameters (1)

NameTypeDefault
P_ProjectObjectNode j_objnr

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_ProjStrucHierarchyNode _Parent $projection.ProjectStructureHierarchy = _Parent.ProjectStructureHierarchy

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IPROJSTRUC3 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.allowExtensions true view
EndUserText.label Project Structure for Line Items view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey ProjectObjectNode view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ProjectObjectNode ProjectObjectNode
ProjectStructureHierarchy ProjectStructureHierarchy
IsActiveEntity IsActiveEntity
ProjectObjectParentNode ProjectObjectParentNode
ProjectObjectType ProjectObjectType
ProjectObjectInternalID ProjectObjectInternalID
ProjectObjectExternalID ProjectObjectExternalID
ProjectObjectDescription ProjectObjectDescription
ProjectHierarchyNodeType ProjectHierarchyNodeType
Project Project
HierarchyParentNodeVal
_Parent _Parent
_ProjectStructure _ProjectStructure 
@AbapCatalog.sqlViewName: 'IPROJSTRUC3'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.allowExtensions:true
@EndUserText.label: 'Project Structure for Line Items'
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API
@ObjectModel.representativeKey: 'ProjectObjectNode'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.semanticKey: ['ProjectObjectExternalID', 'ProjectObjectType']
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_ProjectStructure_3 
with parameters
P_ProjectObjectNode               : j_objnr
  
as select from I_ProjStrucHierarchyNode(P_ProjectObjectNode: $parameters.P_ProjectObjectNode) as hierarchy
association [1..*] to I_ProjStrucHierarchyNode as _Parent on $projection.ProjectStructureHierarchy = _Parent.ProjectStructureHierarchy
{
key ProjectObjectNode,  
ProjectStructureHierarchy,
IsActiveEntity,
ProjectObjectParentNode,
ProjectObjectType,
ProjectObjectInternalID,
ProjectObjectExternalID,
ProjectObjectDescription,
ProjectHierarchyNodeType,
Project,
_Parent(P_ProjectObjectNode:$parameters.P_ProjectObjectNode)[HierarchyNodeOrdinalNumber = 1].ProjectObjectExternalID as HierarchyParentNodeVal,

_Parent,
_ProjectStructure
       
}

Learn More