I_ProjectStructure_3

DDL: I_PROJECTSTRUCTURE_3 SQL: IPROJSTRUC3 Type: view COMPOSITE

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 (P_ProjectObject_2) and exposes 13 fields with key field ProjectObjectNode. It has 1 association to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
P_ProjectObject_2 P_ProjectObject_2 from

Parameters (2)

NameTypeDefault
P_ProjectObjectNode j_objnr
P_ProjectObjectRootNode j_objnr

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProjStrucHierarchyNode _ProjectStructureHierNode $projection.ProjectObjectNode = _ProjectStructureHierNode.ProjectObjectNode

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
ProjectObjectRootNode ProjectObjectRootNode
IsActiveEntity IsActiveEntity
ProjectObjectParentNode ProjectObjectParentNode
ProjectObjectType ProjectObjectType
ProjectObjectInternalID ProjectObjectInternalID
ProjectObjectExternalID ProjectObjectExternalID
ProjectObjectDescription ProjectObjectDescription
Project Project
WBSElement WBSElement
ProjectType ProjectType
ProjectHierarchyNodeType
_ProjectStructureHierNode _ProjectStructureHierNode 
@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,
P_ProjectObjectRootNode  : j_objnr
  as select from P_ProjectObject_2
  association [0..*] to I_ProjStrucHierarchyNode  as _ProjectStructureHierNode on $projection.ProjectObjectNode = _ProjectStructureHierNode.ProjectObjectNode
{
@ObjectModel.hierarchy.association: '_ProjectStructureHierNode'
key ProjectObjectNode, 
ProjectObjectRootNode, 
IsActiveEntity,
ProjectObjectParentNode,
ProjectObjectType,
ProjectObjectInternalID,
ProjectObjectExternalID,
ProjectObjectDescription,
//ProjectHierarchyNodeType,

Project,
WBSElement,
ProjectType,
_ProjectStructureHierNode(P_ProjectObjectNode: $parameters.P_ProjectObjectNode,P_ProjectObjectRootNode: $parameters.P_ProjectObjectRootNode).ProjectHierarchyNodeType,
_ProjectStructureHierNode       
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJSTRUCHIERARCHYNODE",
"P_PROJECTOBJECT_2"
],
"ASSOCIATED":
[
"I_PROJSTRUCHIERARCHYNODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More