I_FinWBSElementHierarchyNodeT

DDL: I_FINWBSELEMENTHIERARCHYNODET Type: view_entity BASIC

Fin WBS Element Hierarchy Node - Text

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

4 data source(s) 12 fields

Data Sources (4)

SourceAliasJoin Type
I_Language _Language cross
I_WBSElementBasicData _WBSElement inner
I_WBSElementStructure I_WBSElementStructure union_all
R_FinWBSElementHierarchyNodeT R_FinWBSElementHierarchyNodeT from

Associations (1)

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

Annotations (13)

NameValueLevelField
EndUserText.label Fin WBS Element Hierarchy Node - Text view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
Analytics.technicalName IIWBSHIERNODET view
Analytics.dataExtraction.enabled true view
ObjectModel.representativeKey HierarchyNode view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY WBSElementHierarchy R_FinWBSElementHierarchyNodeT WBSElementHierarchy
KEY HierarchyNode R_FinWBSElementHierarchyNodeT HierarchyNode
KEY ValidityEndDate R_FinWBSElementHierarchyNodeT ValidityEndDate
KEY Language R_FinWBSElementHierarchyNodeT Language
HierarchyNodeText R_FinWBSElementHierarchyNodeT HierarchyNodeText
ValidityStartDate R_FinWBSElementHierarchyNodeT ValidityStartDate
KEY HierarchyNode I_WBSElementBasicData WBSElement
KEY ValidityEndDate
KEY Language I_Language Language
HierarchyNodeText I_WBSElementBasicData WBSDescription
ValidityStartDate
_Hierarchy _Hierarchy 
@EndUserText.label: 'Fin WBS Element Hierarchy Node - Text'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AccessControl.authorizationCheck: #MANDATORY
@Metadata.ignorePropagatedAnnotations: true 
@ObjectModel.dataCategory: #TEXT
@Analytics.technicalName: 'IIWBSHIERNODET'
@Analytics: { dataExtraction.enabled: true }
@ObjectModel.representativeKey: 'HierarchyNode'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.modelingPattern: #LANGUAGE_DEPENDENT_TEXT
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #LANGUAGE_DEPENDENT_TEXT, #EXTRACTION_DATA_SOURCE ]

define view entity I_FinWBSElementHierarchyNodeT
  as select from R_FinWBSElementHierarchyNodeT
                                
   association [1..1] to I_FinWBSElementHierarchy      as _Hierarchy      on  $projection.WBSElementHierarchy = _Hierarchy.WBSElementHierarchy                                                                           
                                                                           and $projection.ValidityEndDate     = _Hierarchy.ValidityEndDate                                
{
      @ObjectModel.foreignKey.association: '_Hierarchy'
  key R_FinWBSElementHierarchyNodeT.WBSElementHierarchy,
  key R_FinWBSElementHierarchyNodeT.HierarchyNode,
      @Semantics.businessDate.to: true  
  key R_FinWBSElementHierarchyNodeT.ValidityEndDate,
      @Semantics.language: true
  key R_FinWBSElementHierarchyNodeT.Language,
      @Semantics.text: true
      R_FinWBSElementHierarchyNodeT.HierarchyNodeText,
      @Semantics.businessDate.from: true
      R_FinWBSElementHierarchyNodeT.ValidityStartDate,
      _Hierarchy

}

union all

select from  I_WBSElementStructure
  inner join I_WBSElementBasicData as _WBSElement on I_WBSElementStructure.WBSElementInternalID = _WBSElement.WBSElementInternalID
  cross join I_Language            as _Language
     association [1..1] to I_FinWBSElementHierarchy      as _Hierarchy      on  $projection.WBSElementHierarchy = _Hierarchy.WBSElementHierarchy                                                                           
                                                                           and $projection.ValidityEndDate     = _Hierarchy.ValidityEndDate  
{
  key 'WBSELEMENTHIERARCHY                       '  as WBSElementHierarchy,
  key _WBSElement.WBSElement                        as HierarchyNode,
  key '99991231'                                    as ValidityEndDate,
  key _Language.Language                            as Language,
      _WBSElement.WBSDescription                    as HierarchyNodeText,
      '19000101'                                    as ValidityStartDate,
      
      _Hierarchy
}
where
  I_WBSElementStructure.WBSElementParentInternalID is not null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LANGUAGE",
"I_WBSELEMENTBASICDATA",
"I_WBSELEMENTSTRUCTURE",
"R_FINWBSELEMENTHIERARCHYNODET"
],
"ASSOCIATED":
[
"I_FINWBSELEMENTHIERARCHY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More