I_WBSELEMENTSTRUCTURE

CDS View

WBS Element Structure

I_WBSELEMENTSTRUCTURE is a CDS View in S/4HANA. WBS Element Structure. 5 CDS views read from this table.

Used by 5 CDS view(s)

CDS Views using this table (5)

ViewTypeJoinVDMDescription
FINOC_RT_WBS_FILL view inner Orgl Change: Fill Runtime for WBS Elmnt
I_FinWBSElementHierarchyNode view_entity union_all COMPOSITE Fin WBS Element Hierarchy Node
I_FinWBSElementHierarchyNodeT view_entity union_all BASIC Fin WBS Element Hierarchy Node - Text
P_ProjectObject view union COMPOSITE
P_TRRMONWBSUNION view inner COMPOSITE 
@AbapCatalog: {
  sqlViewName: 'IWBSELMNTSTRUC',
  compiler.compareFilter: true
}

@AccessControl.authorizationCheck: #NOT_ALLOWED

@Analytics: { 
  dataCategory: #DIMENSION  
}

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions:true
@EndUserText.label: 'WBS Element Structure'

@ObjectModel: {
  representativeKey: 'WBSElementInternalID',
  usageType.serviceQuality: #A,
  usageType.sizeCategory : #XL,
  usageType.dataClass: #MASTER
}  

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



define view I_WBSElementStructure
  as select from prhi
  association [1..1] to I_WBSElementBasicData as _WBSElement       on $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
  association [1..1] to I_ProjectBasicData    as _Project          on $projection.ProjectInternalID = _Project.ProjectInternalID
  association [1..1] to I_WBSElementBasicData as _WBSElementParent on $projection.WBSElementParentInternalID = _WBSElementParent.WBSElementInternalID
//  association [1..1] to I_WBSElementBasicData as _WBSElementChild  on $projection.WBSElementChildInternalID = _WBSElementChild.WBSElementInternalID

{
  key posnr as WBSElementInternalID,
      psphi as ProjectInternalID,
      up    as WBSElementParentInternalID,
//      down  as WBSElementChildInternalID,

      _WBSElement,
      _Project,
      _WBSElementParent
//      _WBSElementChild

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PRHI"
],
"ASSOCIATED":
[
"I_PROJECTBASICDATA",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More