I_BUDGETPERIODHIERARCHYNODE

@AbapCatalog.sqlViewName: 'IBDGTPDHN'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Budget Period Hierarchy Node'

@VDM.viewType: #BASIC
@Hierarchy.parentChild:[
{ recurse:          {   parent: 'ParentNode',   child:  'HierarchyNode'   },
  siblingsOrder:    {   by: 'HierarchyNodeSequence',    direction: 'ASC'   },
  directory:        '_Hierarchy'
  }]
@Analytics: { dataExtraction: {enabled:true} }
@ObjectModel: {
     dataCategory: #HIERARCHY,
     usageType: {
         dataClass: #MASTER,
         serviceQuality: #A,
         sizeCategory: #XL
     }
}
@ObjectModel.representativeKey: 'HierarchyNode'
@Metadata.ignorePropagatedAnnotations:true 
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #ANALYTICAL_DIMENSION, #EXTRACTION_DATA_SOURCE ]

define view I_BudgetPeriodHierarchyNode
  as select from hrrp_node   

  association [0..*] to I_BudgetPeriodHierarchyNodeT as _Text         on  $projection.BudgetPeriodHierarchy = _Text.BudgetPeriodHierarchy
                                                                      and $projection.HierarchyNode         = _Text.HierarchyNode
                                                                      and $projection.BudgetPeriod          = '' // just to show that this association is only to be followed if BudgetPeriods center is blank


  association [0..1] to I_BudgetPeriod               as _BudgetPeriod on  $projection.BudgetPeriod = _BudgetPeriod.BudgetPeriod

  association [1..1] to I_BudgetPeriodHierarchy      as _Hierarchy    on  $projection.BudgetPeriodHierarchy = _Hierarchy.BudgetPeriodHierarchy
                                                                      and $projection.ValidityEndDate       = _Hierarchy.ValidityEndDate

{
      @Consumption.filter: {mandatory : true, selectionType : #SINGLE, multipleSelections : false }
      @ObjectModel.foreignKey.association: '_Hierarchy'
  key cast( hrrp_node.hryid as fmis_hryid_budgetperiod preserving type) as BudgetPeriodHierarchy,
      @ObjectModel.text.association: '_Text'
  key hrrp_node.hrynode                                                 as HierarchyNode,
      @Consumption.filter: {mandatory : true, selectionType : #SINGLE, multipleSelections : false }
      @Semantics.businessDate.to: true
  key cast( hrrp_node.hryvalto as fis_datbi preserving type )           as ValidityEndDate,
      hrrp_node.parnode                                                 as ParentNode,
      hrrp_node.hryver                                                  as HierarchyVersion,
      @Semantics.businessDate.from: true
      cast( hrrp_node.hryvalfrom as fis_datab preserving type)          as ValidityStartDate,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_BudgetPeriodStdVH',
                     element: 'BudgetPeriod' }
        }]
      @ObjectModel.foreignKey.association: '_BudgetPeriod'
      @Consumption.filter.businessDate.at:true
      cast ( case nodetype
        when 'L' then  hrrp_node.nodevalue
        else  ''
      end as fm_budget_period )                                         as BudgetPeriod,
       @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: 'HierarchyNodeSequence'
      concat(hrrp_node.hryseqnbr, hrrp_node.hrynode)                    as SequenceNumber,
      hrrp_node.hryseqnbr                                               as HierarchyNodeSequence,
      hrrp_node.hrylevel                                                as HierarchyNodeLevel,
      hrrp_node.nodetype                                                as NodeType,

      _Text,
      _BudgetPeriod,
      _Hierarchy

}
where

      hrrp_node.nodetype <> 'D'
  and hrrp_node.hrytype  =  '0114'