I_WBSElementSortHierNodeRltn_2

DDL: I_WBSELEMENTSORTHIERNODERLTN_2 SQL: IWBSSORTHIERND2 Type: view BASIC

Parent Child Relationship for Sort WBS

I_WBSElementSortHierNodeRltn_2 is a Basic CDS View that provides data about "Parent Child Relationship for Sort WBS" in SAP S/4HANA. It reads from 2 data sources (I_ProjectBasicData, v_prhi) and exposes 8 fields with key fields ProjectObjectRootNode, WBSElementInternalID. It has 2 associations to related views.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_ProjectBasicData proj inner
v_prhi v_prhi from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_WBSElementSortHierNodeRltn_2 _Parent $projection.WBSElementInternalID = _Parent.RightSiblingWBSElmntInternalID
[0..1] I_ProjectObjectHierarchy_2 _ProjectObjectHierarchy $projection.ProjectObjectRootNode = _ProjectObjectHierarchy.ProjectObjectRootNode

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IWBSSORTHIERND2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Parent Child Relationship for Sort WBS view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ProjectObjectRootNode I_ProjectBasicData ProjectObject
KEY WBSElementInternalID
ProjectInternalID
WBSElementParentInternalID
LeftSiblingWBSElmntInternalID
RightSiblingWBSElmntInternalID
_Parent _Parent
_ProjectObjectHierarchy _ProjectObjectHierarchy 
@AbapCatalog.sqlViewName: 'IWBSSORTHIERND2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Parent Child Relationship for Sort WBS'
define view I_WBSElementSortHierNodeRltn_2
  as select from v_prhi
    inner join   I_ProjectBasicData as proj on v_prhi.psphi = proj.ProjectInternalID
  association [0..1] to I_WBSElementSortHierNodeRltn_2 as _Parent on $projection.WBSElementInternalID = _Parent.RightSiblingWBSElmntInternalID
  association [0..1] to I_ProjectObjectHierarchy_2 as _ProjectObjectHierarchy on  $projection.ProjectObjectRootNode = _ProjectObjectHierarchy.ProjectObjectRootNode
{
  key proj.ProjectObject                                       as ProjectObjectRootNode,
  key cast( v_prhi.posnr as ps_s4_pspnr preserving type )      as WBSElementInternalID,
      cast( v_prhi.psphi as ps_s4_proj_pspnr preserving type ) as ProjectInternalID,
      cast( v_prhi.wbs_up as ps_s4_pspnr preserving type )     as WBSElementParentInternalID,
      cast( v_prhi.wbs_left as ps_s4_pspnr preserving type )   as LeftSiblingWBSElmntInternalID,
      cast( v_prhi.wbs_right as ps_s4_pspnr preserving type )  as RightSiblingWBSElmntInternalID,
      //Associations

      _Parent,
      _ProjectObjectHierarchy
}

Learn More