I_ProjectStructure

DDL: I_PROJECTSTRUCTURE SQL: IPROJECTSTRUC Type: view COMPOSITE

Project Structure

I_ProjectStructure is a Composite CDS View (Dimension) that provides data about "Project Structure" in SAP S/4HANA. It reads from 1 data source (P_ProjectObject) and exposes 11 fields with key field ProjectObjectNode. It has 1 association to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
P_ProjectObject P_ProjectObject from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProjectStructureNode _ProjectStructureNode $projection.ProjectObjectNode = _ProjectStructureNode.ProjectObjectNode

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPROJECTSTRUC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view
EndUserText.label Project Structure view
VDM.viewType #COMPOSITE 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
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ProjectObjectNode ProjectObjectNode
IsActiveEntity IsActiveEntity
ProjectObjectParentNode ProjectObjectParentNode
ProjectObjectRootNode ProjectObjectRootNode
ProjectObjectInternalID ProjectObjectInternalID
ProjectObjectUUID ProjectObjectUUID
ProjectObjectExternalID ProjectObjectExternalID
ProjectObjectDescription ProjectObjectDescription
ProjectObjectType ProjectObjectType
Project Project
_ProjectStructureNode _ProjectStructureNode 
@AbapCatalog.sqlViewName: 'IPROJECTSTRUC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.privilegedAssociations:  [ '_ProjectStructureNode' ] 
@Analytics: { dataCategory: #DIMENSION }
@Metadata.allowExtensions:true
@EndUserText.label: 'Project Structure'
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'ProjectObjectNode'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.semanticKey: ['ProjectObjectExternalID', 'ProjectObjectType']
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

define view I_ProjectStructure
  as select from P_ProjectObject
  association [0..*] to I_ProjectStructureNode as _ProjectStructureNode on $projection.ProjectObjectNode = _ProjectStructureNode.ProjectObjectNode
{
      @ObjectModel.hierarchy.association: '_ProjectStructureNode'   
      key ProjectObjectNode,
          IsActiveEntity,
          ProjectObjectParentNode,
          ProjectObjectRootNode,
          ProjectObjectInternalID,
          ProjectObjectUUID,
          ProjectObjectExternalID,
          ProjectObjectDescription,
          ProjectObjectType,       
          Project,   
          _ProjectStructureNode
}

Learn More