I_WBSELEMENTHIERARCHYDATA

CDS View

WBS Element Hierarchy

I_WBSELEMENTHIERARCHYDATA is a CDS View in S/4HANA. WBS Element Hierarchy. It contains 6 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 6 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_DFS_RelocationSteps view_entity from CONSUMPTION Relocation Steps List
C_DFS_RelocationStepsVH view_entity from CONSUMPTION Relocation Steps
I_PeggingWBSElmntHierNodeRltn view_entity from BASIC Pegging WBS Element Hierarchy Relation
P_ProjectObject_2 view union_all COMPOSITE Project Object
R_DFS_RelocProjWBSElmntHierTP view_entity from TRANSACTIONAL List for WBS Element Hierarchy

Fields (6)

KeyField CDS FieldsUsed in Views
KEY WBSElementInternalID WBSElementInternalID 1
LeftSiblingWBSElmntInternalID LeftSiblingWBSElmntInternalID 1
ProjectInternalID ProjectInternalID 1
RightSiblingWBSElmntInternalID RightSiblingWBSElmntInternalID 1
WBSElementChildInternalID WBSElementChildInternalID 1
WBSElementParentInternalID WBSElementParentInternalID 1 
@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