I_ProjectHierarchyRoot

DDL: I_PROJECTHIERARCHYROOT Type: view_entity BASIC

Project Hierarchy Root

I_ProjectHierarchyRoot is a Basic CDS View that provides data about "Project Hierarchy Root" in SAP S/4HANA. It reads from 1 data source (proj) and exposes 7 fields with key field ProjectObject. It has 2 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
proj proj from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea
[0..*] I_ProfitCenter _ProfitCenter $projection.ControllingArea = _ProfitCenter.ControllingArea and $projection.ProfitCenter = _ProfitCenter.ProfitCenter

Annotations (6)

NameValueLevelField
EndUserText.label Project Hierarchy Root view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ProjectObject objnr
ControllingArea
ProfitCenter proj prctr
_ControllingArea _ControllingArea
_ProfitCenter _ProfitCenter
_ProjectObjectHierarchy _ProjectObjectHierarchy
_ProjectObject _ProjectObject 
@EndUserText.label: 'Project Hierarchy Root'
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER

define root view entity I_ProjectHierarchyRoot
  as select from proj
  association [0..1] to I_ControllingArea as _ControllingArea on  $projection.ControllingArea = _ControllingArea.ControllingArea
  association [0..*] to I_ProfitCenter    as _ProfitCenter    on  $projection.ControllingArea = _ProfitCenter.ControllingArea
                                                              and $projection.ProfitCenter    = _ProfitCenter.ProfitCenter

  composition of I_ProjectObjectHierarchy as _ProjectObjectHierarchy
  composition of I_ProjectObject          as _ProjectObject

  
{
  key objnr                                        as ProjectObject,
      @ObjectModel.foreignKey.association: '_ControllingArea'
      cast ( proj.vkokr as kokrs preserving type ) as ControllingArea,

      @ObjectModel.foreignKey.association: '_ProfitCenter'
      proj.prctr                                   as ProfitCenter,
      _ControllingArea,
      _ProfitCenter,
      _ProjectObjectHierarchy,
      _ProjectObject 
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PROJ"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA",
"I_PROFITCENTER",
"I_PROJECTOBJECT",
"I_PROJECTOBJECTHIERARCHY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More