I_WBSElementHierarchyData

DDL: I_WBSELEMENTHIERARCHYDATA SQL: IWBSELMNTHIER Type: view BASIC

WBS Element Hierarchy

I_WBSElementHierarchyData is a Basic CDS View that provides data about "WBS Element Hierarchy" in SAP S/4HANA. It reads from 1 data source (v_prhi) and exposes 9 fields with key field WBSElementInternalID. It has 3 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
v_prhi v_prhi from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_WBSElementData_2 _WBSElement $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
[1..1] I_ProjectData_2 _Project $projection.ProjectInternalID = _Project.ProjectInternalID
[1..1] I_WBSElementData_2 _WBSElementParent $projection.WBSElementParentInternalID = _WBSElementParent.WBSElementInternalID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IWBSELMNTHIER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label WBS Element Hierarchy view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY WBSElementInternalID
ProjectInternalID
WBSElementParentInternalID
WBSElementChildInternalID
LeftSiblingWBSElmntInternalID
RightSiblingWBSElmntInternalID
_WBSElement _WBSElement
_Project _Project
_WBSElementParent _WBSElementParent 
@AbapCatalog.sqlViewName: 'IWBSELMNTHIER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'WBS Element Hierarchy'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #A,
    sizeCategory: #XL,
    dataClass: #MASTER
}

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

define view I_WBSElementHierarchyData
  as select from v_prhi
  association [1..1] to I_WBSElementData_2 as _WBSElement       on $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
  association [1..1] to I_ProjectData_2    as _Project          on $projection.ProjectInternalID = _Project.ProjectInternalID
  association [1..1] to I_WBSElementData_2 as _WBSElementParent on $projection.WBSElementParentInternalID = _WBSElementParent.WBSElementInternalID
{
  key cast ( posnr as ps_s4_pspnr preserving type )      as WBSElementInternalID,
      cast ( psphi as ps_s4_proj_pspnr preserving type ) as ProjectInternalID,
      cast ( wbs_up as ps_posnr1 preserving type )       as WBSElementParentInternalID,
      cast ( wbs_down as ps_posnr1 preserving type )     as WBSElementChildInternalID,
      cast ( wbs_left as ps_posnr1 preserving type )     as LeftSiblingWBSElmntInternalID,
      cast ( wbs_right as ps_posnr1 preserving type )    as RightSiblingWBSElmntInternalID,
      _WBSElement,
      _Project,
      _WBSElementParent
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"V_PRHI"
],
"ASSOCIATED":
[
"I_PROJECTDATA_2",
"I_WBSELEMENTDATA_2"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More