P_FinancialStatementHierNode

@AbapCatalog.sqlViewName: 'PFISTMTHIRND'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private:true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_FinancialStatementHierNode
  as select from hrrp_node_n
{

  key hrrp_node_n.hryid_42                                        as FinancialStatementHierarchy,
  key hrrp_node_n.hrynode                                         as HierarchyNode,
  key hrrp_node_n.hryvalto                                        as ValidityEndDate,
      cast(hrrp_node_n.hryvalfrom as fis_datab preserving type )  as ValidityStartDate,

      hrrp_node_n.parnode                                         as ParentNode,
      @VDM.lifecycle.status:    #DEPRECATED
      cast('000000000000001' as hryversn )                        as HierarchyVersion,
      hrrp_node_n.nodecls                                         as ChartOfAccounts,
      hrrp_node_n.nodetype                                        as NodeType,

      cast( hrrp_node_n.fs_leafitem  as hrynode preserving type ) as FinancialStatementLeafItem,
      hrrp_node_n.fs_nodetype                                     as FinancialStatementNodeType,
      hrrp_node_n.hrynodeext                                      as FinStmntNodeFormattedID,

      concat(hrrp_node_n.hryseqnbr, hrrp_node_n.hrynode)          as SequenceNumber,
      cast(hrrp_node_n.sign   as hryattrvalue )                   as SignIsInverted,
      hrrp_node_n.nodevalue                                       as HierarchyNodeVal,
      hrrp_node_n.hryseqnbr                                       as HierarchyNodeSequence, //sequence in num6

      hrrp_node_n.hrylevel                                        as HierarchyLevel,
      hrrp_node_n.balind                                          as DebitCreditCode
}
where
  (
       hrrp_node_n.nodetype  =    'R'
    or hrrp_node_n.nodetype  =    'N'
    or hrrp_node_n.nodetype  =    'L'
    or hrrp_node_n.nodetype  =    'O'
    or hrrp_node_n.nodetype  =    'M'
    or hrrp_node_n.nodetype  =    'K'
    or hrrp_node_n.nodetype  =    'A'
  )
  and  hrrp_node_n.hrytyp    =    'FSVN'
  and  not hrrp_node_n.hryid like '0109/%'
  and  not hrrp_node_n.hryid like '0102/%'
  and  not hrrp_node_n.hryid like 'H109/%'

union all select from hrrp_node_n
{
  key hrrp_node_n.hryid_42                                       as FinancialStatementHierarchy,
  key cast('1COA0PLRESULTA' as hrynode)                          as HierarchyNode,
  key hrrp_node_n.hryvalto                                       as ValidityEndDate,
      cast(hrrp_node_n.hryvalfrom as fis_datab preserving type ) as ValidityStartDate,
      cast('00PLPROFIT' as parnode)                              as ParentNode,
      @VDM.lifecycle.status:    #DEPRECATED
      cast('000000000000001' as hryversn)                        as HierarchyVersion,
      hrrp_node_n.nodecls                                        as ChartOfAccounts,
      'L'                                                        as NodeType,
      cast('0COA0PLRESULTA' as hrynode)                          as FinancialStatementLeafItem,
      cast('' as fi_fsv_nodtyp)                                  as FinancialStatementNodeType,
      cast('0COA0PLRESULT    A' as fi_fsv_nodeext)               as FinStmntNodeFormattedID,

      concat(hrrp_node_n.hryseqnbr, hrrp_node_n.hrynode)         as SequenceNumber,
      hrrp_node_n.sign                                           as SignIsInverted,
      hrrp_node_n.nodevalue                                      as HierarchyNodeVal,
      hrrp_node_n.hryseqnbr                                      as HierarchyNodeSequence,  //sequence in num6

      hrrp_node_n.hrylevel                                       as HierarchyLevel,
      hrrp_node_n.balind                                         as DebitCreditCode
}
where
      hrrp_node_n.nodetype  =    'M'
  and hrrp_node_n.hrytyp    =    'FSVN'
  and not hrrp_node_n.hryid like '0109/%'
  and not hrrp_node_n.hryid like '0102/%'
  and not hrrp_node_n.hryid like 'H109/%'

union all select from hrrp_node_n
{

  key hrrp_node_n.hryid_42                                       as FinancialStatementHierarchy,
  key cast('1COA0BSRESULT1A' as hrynode)                         as HierarchyNode,
  key hrrp_node_n.hryvalto                                       as ValidityEndDate,
      cast(hrrp_node_n.hryvalfrom as fis_datab preserving type ) as ValidityStartDate,
      cast('00BSLOSS' as parnode)                                as ParentNode,
      @VDM.lifecycle.status:    #DEPRECATED
      cast('000000000000001' as hryversn)                        as HierarchyVersion,
      hrrp_node_n.nodecls                                        as ChartOfAccounts,
      'L'                                                        as NodeType,
      cast('0COA0BSRESULT1A' as hrynode)                         as FinancialStatementLeafItem,
      cast('' as fi_fsv_nodtyp)                                  as FinancialStatementNodeType,
      cast('0COA0BSRESULT   1A' as fi_fsv_nodeext)               as FinStmntNodeFormattedID,

      concat(hrrp_node_n.hryseqnbr, hrrp_node_n.hrynode)         as SequenceNumber,
      hrrp_node_n.sign                                           as SignIsInverted,
      hrrp_node_n.nodevalue                                      as HierarchyNodeVal,
      hrrp_node_n.hryseqnbr                                      as HierarchyNodeSequence,  //sequence in num6

      hrrp_node_n.hrylevel                                       as HierarchyLevel,
      hrrp_node_n.balind                                         as DebitCreditCode
}
where
      hrrp_node_n.nodetype  =    'K'
  and hrrp_node_n.hrytyp    =    'FSVN'
  and not hrrp_node_n.hryid like '0109/%'
  and not hrrp_node_n.hryid like '0102/%'
  and not hrrp_node_n.hryid like 'H109/%'

union all select from hrrp_node_n
{

  key hrrp_node_n.hryid_42                                       as FinancialStatementHierarchy,
  key cast('1COA0BSRESULT2A' as hrynode)                         as HierarchyNode,
  key hrrp_node_n.hryvalto                                       as ValidityEndDate,
      cast(hrrp_node_n.hryvalfrom as fis_datab preserving type ) as ValidityStartDate,
      cast('00BSPROFIT' as parnode)                              as ParentNode,
      @VDM.lifecycle.status:    #DEPRECATED
      cast('000000000000001' as hryversn)                        as HierarchyVersion,
      hrrp_node_n.nodecls                                        as ChartOfAccounts,
      'L'                                                        as NodeType,
      cast('0COA0BSRESULT2A' as hrynode)                         as FinancialStatementLeafItem,
      cast('' as fi_fsv_nodtyp)                                  as FinancialStatementNodeType,
      cast('0COA0BSRESULT   2A' as fi_fsv_nodeext)               as FinStmntNodeFormattedID,

      concat(hrrp_node_n.hryseqnbr, hrrp_node_n.hrynode)         as SequenceNumber,
      hrrp_node_n.sign                                           as SignIsInverted,
      hrrp_node_n.nodevalue                                      as HierarchyNodeVal,
      hrrp_node_n.hryseqnbr                                      as HierarchyNodeSequence,  //sequence in num6

      hrrp_node_n.hrylevel                                       as HierarchyLevel,
      hrrp_node_n.balind                                         as DebitCreditCode
}
where
      hrrp_node_n.nodetype  =    'A'
  and hrrp_node_n.hrytyp    =    'FSVN'
  and not hrrp_node_n.hryid like '0109/%'
  and not hrrp_node_n.hryid like '0102/%'
  and not hrrp_node_n.hryid like 'H109/%'