R_FINWBSELEMENTHIERARCHYNODET

CDS View

Hierarchy of WBS Element Node - Text

R_FINWBSELEMENTHIERARCHYNODET is a CDS View in S/4HANA. Hierarchy of WBS Element Node - Text. It contains 6 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 6 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FinWBSElementHierarchyNodeT view_entity from BASIC Fin WBS Element Hierarchy Node - Text

Fields (6)

KeyField CDS FieldsUsed in Views
KEY HierarchyNode HierarchyNode 1
KEY Language Language 1
KEY ValidityEndDate ValidityEndDate 1
KEY WBSElementHierarchy WBSElementHierarchy 1
HierarchyNodeText HierarchyNodeText 1
ValidityStartDate ValidityStartDate 1 
/* This view selects only fro HRRP_DIRECTORY and does not consider WBSElementStructure */
@EndUserText.label: 'Hierarchy of WBS Element Node - Text'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.internalName:#LOCAL
@Metadata.ignorePropagatedAnnotations: true 
@ObjectModel.dataCategory: #TEXT
@Analytics.technicalName: 'RFIWBSHIERNODET'
@ObjectModel.representativeKey: 'HierarchyNode'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
//@ObjectModel.modelingPattern: #LANGUAGE_DEPENDENT_TEXT

//@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #LANGUAGE_DEPENDENT_TEXT ]


define view entity R_FinWBSElementHierarchyNodeT
  as select from hrrp_nodet_n
    association [1..1] to R_FinWBSElementHierarchy      as _Hierarchy      on  $projection.WBSElementHierarchy = _Hierarchy.WBSElementHierarchy                                                                           
                                                                           and $projection.ValidityEndDate     = _Hierarchy.ValidityEndDate
{
  @ObjectModel.foreignKey.association: '_Hierarchy'
  key cast(hrrp_nodet_n.hryid_42 as fis_finwbshier preserving type ) as WBSElementHierarchy,
  
  @ObjectModel.text.element: ['HierarchyNodeText']
  key hrrp_nodet_n.hrynode                                      as HierarchyNode,
  @Semantics.businessDate.to: true
  key cast(hrrp_nodet_n.hryvalto as fis_datbi preserving type )   as ValidityEndDate,
  @Semantics.language: true
  key hrrp_nodet_n.spras                                        as Language,
      @Semantics.text: true
      hrrp_nodet_n.nodetxt                                      as HierarchyNodeText,
      @Semantics.businessDate.from: true
      cast(hrrp_nodet_n.hryvalfrom as fis_datab preserving type ) as ValidityStartDate,
      
      _Hierarchy

}
where 
      hrrp_nodet_n.hrytyp =  '0110'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRRP_NODET_N"
],
"ASSOCIATED":
[
"R_FINWBSELEMENTHIERARCHY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More