R_FinWBSElementHierarchyNodeT

DDL: R_FINWBSELEMENTHIERARCHYNODET Type: view_entity BASIC

Hierarchy of WBS Element Node - Text

R_FinWBSElementHierarchyNodeT is a Basic CDS View that provides data about "Hierarchy of WBS Element Node - Text" in SAP S/4HANA. It reads from 1 data source (hrrp_nodet_n) and exposes 7 fields with key fields WBSElementHierarchy, HierarchyNode, ValidityEndDate, Language. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
hrrp_nodet_n hrrp_nodet_n from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_FinWBSElementHierarchy _Hierarchy $projection.WBSElementHierarchy = _Hierarchy.WBSElementHierarchy and $projection.ValidityEndDate = _Hierarchy.ValidityEndDate

Annotations (12)

NameValueLevelField
EndUserText.label Hierarchy of WBS Element Node - Text view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
Analytics.technicalName RFIWBSHIERNODET view
ObjectModel.representativeKey HierarchyNode view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WBSElementHierarchy
KEY HierarchyNode hrrp_nodet_n hrynode
KEY ValidityEndDate
KEY Language hrrp_nodet_n spras
HierarchyNodeText hrrp_nodet_n nodetxt
ValidityStartDate
_Hierarchy _Hierarchy 
/* 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