I_WBSElementHierarchyText

@AbapCatalog.sqlViewName: 'IWBSHIERT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'WBS Element Hierarchy Text'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.representativeKey: 'WBSElementHierarchy'
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #TEXT
//@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API


//Deprecated - Do not use this view

@VDM.lifecycle : {
        status:  #DEPRECATED        
   }


define view I_WBSElementHierarchyText
  as

  select from hrrp_directoryt
  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
  //key   hrrp_directoryt.hryid                           as WBSElementHierarchy,

  key cast ( hrrp_directoryt.hryid as wbshierarchy preserving type )  as WBSElementHierarchy,
        @ObjectModel.foreignKey.association: '_Language'
        @Semantics.language
  key   spras                                           as Language,
        @Semantics.businessDate.to: true
  key   hrrp_directoryt.hryvalto                        as ValidityEndDate,
        @Semantics.businessDate.from: true
        hrrp_directoryt.hryvalfrom                      as ValidityStartDate,
        @Semantics.text
        hrytxt                                          as WBSElementHierarchyText,
        _Language
}

union all

select from dd04t
//I_DataElementLabelText

association [0..1] to I_Language as _Language on $projection.Language = _Language.Language

{
  key $session.client                                   as mandt,
  key 'WBSELEMENTHIERARCHY                       '      as WBSElementHierarchy,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key cast( ddlanguage as spras )                       as Language,
      //key cast (Language as spras)                          as Language,

      @Semantics.businessDate.to: true
  key '99991231'                                        as ValidityEndDate,
      @Semantics.businessDate.from: true
      '19720101'                                        as ValidityStartDate,
      @Semantics.text: true
      cast(ddtext as fis_val_text)                      as WBSElementHierarchyText,
      //cast(ABAPDataElementDescription as fis_val_text)  as WBSElementHierarchyText,

      _Language

}
where
      rollname = 'PS_WBSH'
  //ABAPDataElement = 'PS_WBSH'

  and as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD04T",
"HRRP_DIRECTORYT"
],
"ASSOCIATED":
[
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/