FAC_CDS_UH_REUSE_FH_NODE_PC

@AbapCatalog.sqlViewName: 'FACV_UHRUFHPC'
//@AbapCatalog.compiler.compareFilter: true

//@AccessControl.authorizationCheck: #NOT_ALLOWED

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Flexible Profit Center Hierarchy Node'

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel: {usageType: {
  dataClass: #MASTER,
  serviceQuality: #B,
  sizeCategory: #XL}
}

define view FAC_CDS_UH_REUSE_FH_NODE_PC
  as select from    hrrp_node_n
    inner join      flexhier_dir on  hrrp_node_n.hryid_42 = flexhier_dir.hryid
                                 and hrrp_node_n.hryvalto = flexhier_dir.hryvalto
    left outer join hrrp_nodet_n on  hrrp_node_n.hryid_42 = hrrp_nodet_n.hryid_42
                                 and hrrp_node_n.hrytyp   = hrrp_nodet_n.hrytyp
                                 and hrrp_node_n.nodecls  = hrrp_nodet_n.nodecls
                                 and hrrp_node_n.hrynode  = hrrp_nodet_n.hrynode
                                 and hrrp_node_n.parnode  = hrrp_nodet_n.parnode
                                 and hrrp_node_n.hryvalto = hrrp_nodet_n.hryvalto
                                 and hrrp_nodet_n.spras   = $session.system_language

{
  key    hrrp_node_n.hryid_42                                                                                         as FlexibleHierarchy,
         @VDM.lifecycle.status:    #DEPRECATED
  key    cast( '000000000000001' as hryversn preserving type )                                                        as HierarchyVersion,
  key    hrrp_node_n.kokrs                                                                                            as ControllingArea,
  key    hrrp_node_n.hrynode                                                                                          as HierarchyNode,
  key    hrrp_node_n.parnode                                                                                          as ParentNode,
  key    hrrp_node_n.hryvalto                                                                                         as ValidityEndDate,
         hrrp_node_n.hrytyp                                                                                           as HierarchyType,
         hrrp_node_n.hryvalfrom                                                                                       as ValidityStartDate,
         hrrp_node_n.nodetype                                                                                         as HierarchyNodeType,
         hrrp_node_n.nodevalue                                                                                        as HierarchyNodeValue,
         hrrp_node_n.hryseqnbr                                                                                        as HierarchySequenceNumber,
         hrrp_node_n.hrylevel                                                                                         as HierarchyLevel,
         case
           when hrrp_nodet_n.nodetxt is null or hrrp_nodet_n.nodetxt = '' then cast( hrrp_node_n.hrynode as nltxt )
           else cast( concat( hrrp_node_n.hrynode, concat(' (',concat( hrrp_nodet_n.nodetxt, ')' ) ) ) as nltxt ) end as NodeValueText,
         hrrp_nodet_n.nodetxt                                                                                         as HierarchyNodeText,
         cast( upper(hrrp_nodet_n.nodetxt) as nltxt )                                                                 as NodeTextUpper,
         cast( concat( concat( hrrp_node_n.hryid_42, '~'), hrrp_node_n.hrynode ) as fhnid )                           as HierarchyNodeID

}
where
      hrrp_node_n.hrytyp    =  '0106'
  and hrrp_node_n.nodetype  <> 'D'
  and hrrp_node_n.nodetype  <> 'L'
  and hrrp_node_n.nodevalue <> 'NOTASSIGNED';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FLEXHIER_DIR",
"HRRP_NODET_N",
"HRRP_NODE_N"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/