P_FinStmtLeafWithFuncArea

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

@VDM.private:true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'PFSLEAFFUNAREA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
define view P_FinStmtLeafWithFuncArea
  as select from    fagl_011fc               as fc_leaf

    inner join      P_Distinct_Coa_Fagl_Zc   as dis_zc on fc_leaf.versn = dis_zc.versn

    inner join      I_FunctionalArea                   on  fc_leaf.vonfb <= I_FunctionalArea.FunctionalArea
                                                       and fc_leaf.bisfb >= I_FunctionalArea.FunctionalArea

    left outer join I_FinancialStatementItem as fsitem on  fsitem.FinancialStatementVariant = fc_leaf.versn
                                                       and fsitem.FinancialStatementItem    = fc_leaf.ergsl
                                                       and fsitem.NodeType                  = 'P'
{
  key cast (concat(concat( fsitem.HierarchyNode,I_FunctionalArea.FunctionalArea ),'=') as abap.char(50) )       as HierarchyUniqueNodeID,
  key cast (concat( concat(concat( fsitem.HierarchyNode,fc_leaf.vonfb ),'-'),fc_leaf.bisfb ) as abap.char(50) ) as UniqueParentID,
  key fc_leaf.versn,
  key dis_zc.ktopl,
  key fc_leaf.ergsl,
  key I_FunctionalArea.FunctionalArea                                                                           as fkber,
      cast ('L' as seu_type)                                                                                    as type,
      cast ( '' as abap.char( 50 ))                                                                             as Description,
      fsitem.HierarchyNode                                                                                      as id
}

union all

select from       fagl_011fc               as fc_range

  inner join      I_ChartOfAccounts                  on I_ChartOfAccounts.ChartOfAccounts is not null

  left outer join I_FinancialStatementItem as fsitem on  fsitem.FinancialStatementVariant = fc_range.versn
                                                     and fsitem.FinancialStatementItem    = fc_range.ergsl
                                                     and fsitem.NodeType                  = 'P'
{
  key cast (concat( concat(concat( fsitem.HierarchyNode,fc_range.vonfb ),'-'),fc_range.bisfb ) as abap.char(50) )as HierarchyUniqueNodeID,
  key cast ( fsitem.HierarchyNode as abap.char(50) )                                                             as UniqueParentID,
  key fc_range.versn,
  key I_ChartOfAccounts.ChartOfAccounts                                                                          as ktopl,
  key fc_range.ergsl,
  key ''                                                                                                         as fkber,
      cast ('B' as seu_type)                                                                                     as type,
      cast (concat (concat (fc_range.vonfb,'-'),fc_range.bisfb) as abap.char(50) )                               as Description,
      fsitem.HierarchyNode                                                                                       as id
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHARTOFACCOUNTS",
"I_FINANCIALSTATEMENTITEM",
"I_FUNCTIONALAREA",
"P_DISTINCT_COA_FAGL_ZC",
"FAGL_011FC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/