FAA_CFG_DEPR_AREA

@AbapCatalog.sqlViewName: 'FAAV_CFG_DA'
@ClientHandling.algorithm: #SESSION_VARIABLE
--@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@AbapCatalog.buffering.status: #ACTIVE
--@AbapCatalog.buffering.type: #FULL
@AbapCatalog.buffering.type: #GENERIC
@AbapCatalog.buffering.numberOfKeyFields: 2
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Configuration of Depr.Area'
define view FAA_CFG_DEPR_AREA
  as

  select from       faac_cmp_da0    as cmp_da0

    inner join      finsc_ld_cmp    as ld_cmp      on  ld_cmp.rldnr              = cmp_da0.ledger
                                                   and ld_cmp.bukrs              = cmp_da0.comp_code

    inner join      fins_tech_ledger    as ledger      on ledger.rldnr               = cmp_da0.ledger

    //--- inner join      fagl_tldgrp_map as fagl_tldgrp on  fagl_tldgrp.ldgrp         = accpr_ldgrp.ldgrp_gl

    //---                                                and fagl_tldgrp.rldnr         = cmp_da0.ledger


    inner join      faac_valview0   as valview0    on valview0.valview           = cmp_da0.valview

    inner join      faac_valview1a  as valview1a   on  valview1a.valview         = cmp_da0.valview
                                                   and valview1a.acc_principle   = ld_cmp.acc_principle
    inner join      t001            as t001        on  t001.bukrs                = ld_cmp.bukrs
    
    left outer join tacc_trgt_ldgr  as accpr_ldgrp on accpr_ldgrp.acc_principle  = ld_cmp.acc_principle
    
    left outer join faac_ap0        as ap_generic  on  ap_generic.acc_principle  = ld_cmp.acc_principle
                                                   and ap_generic.comp_code      = '*   '
    left outer join faac_ap0        as ap_specific on  ap_specific.acc_principle = ld_cmp.acc_principle
                                                   and ap_specific.comp_code     = ld_cmp.bukrs
                                                   
    left outer join faac_cmp_da0    as da_quantity on  da_quantity.comp_code       = cmp_da0.comp_code
--                                                   and da_quantity.ledger          = cmp_da0.ledger
                                                   and da_quantity.update_quantity = 'X'
{
  key cmp_da0.comp_code                                            as comp_code,
  key cmp_da0.ledger                                               as ledger,
  key cmp_da0.depr_area                                            as depr_area,
      cmp_da0.valview                                              as valview,
      cmp_da0.fisc_year_from                                       as FISC_YEAR_FROM,
      cmp_da0.fisc_year_to                                         as FISC_YEAR_TO,
      cmp_da0.depr_fisc_year_var                                   as DEPR_FISC_YEAR_VAR,
      cmp_da0.round_value                                          as round_value,
      cmp_da0.round_method                                         as round_method,
      --- if no quantity area is defined set area 01 as default quantity area
      case when da_quantity.depr_area = cmp_da0.depr_area then da_quantity.update_quantity    -- quantity area found and matching
           else case when da_quantity.depr_area <> ''     then ''                             -- quantity area found but not matching                
                     else 
                     case when cmp_da0.depr_area = '01'   then 'X'                            -- no QM area specified : 01 is default QM area
                          else                                 '' 
                          end end end                              as update_quantity,
      // --- FINSC_LD_CMP ---

      ld_cmp.periv                                                 as fisc_year_var,
      ld_cmp.acc_principle                                         as acc_principle,
      -- Chart of depreciation assigned for Acc.Principle ---
      --case ap_specific.comp_code
      --when ld_cmp.bukrs then ap_specific.depr_chart          //- specific entry found!

      --                  else ap_generic.depr_chart                 end as depr_chart_accpr,    -- old usage but doesn't match the structure FAA_S_CFG_DEPR_AREA_S4
      case ap_specific.comp_code
      when ld_cmp.bukrs then ap_specific.depr_chart          //- specific entry found!

                        else ap_generic.depr_chart                 end as depr_chart,
      --- Other configuration data from AP0
        --- Accounting Principle Settings
      case ap_specific.comp_code
      when ld_cmp.bukrs then ap_specific.use_gross_trans
                        else ap_generic.use_gross_trans            end as use_gross_trans,
      case ap_specific.comp_code
      when ld_cmp.bukrs then ap_specific.auc_version
                        else ap_generic.auc_version                end as auc_version,
      case ap_specific.comp_code
      when ld_cmp.bukrs then ap_specific.trans_downpayment
                        else ap_generic.trans_downpayment          end as trans_downpayment,
      case ap_specific.comp_code
      when ld_cmp.bukrs then ap_specific.use_group_asset
                        else ap_generic.use_group_asset            end as use_group_asset,
      case ap_specific.comp_code
      when ld_cmp.bukrs then ap_specific.depr_doc_type
                        else ap_generic.depr_doc_type              end as depr_doc_type,
      case ap_specific.comp_code
      when ld_cmp.bukrs then ap_specific.post_nbv_retirement
                        else ap_generic.post_nbv_retirement        end as post_nbv_retirement,
      case ap_specific.comp_code
      when ld_cmp.bukrs then ap_specific.revenue_distribute_method
                        else ap_generic.revenue_distribute_method  end as revenue_distribute_method,
      --- Chart of Accounts (GL) ---
      t001.ktopl                                                   as gl_account_chart,
      -- currency fields (needed for Compat-Mapping of parallel currencies) --
      ld_cmp.curtph                                                as curtph,
      #FINS_CUR_POS.'1'                                            as curposh,
      ld_cmp.curtpk                                                as curtpk,
      ld_cmp.curposk                                               as curposk,
      ld_cmp.curtpo                                                as curtpo,
      ld_cmp.curposo                                               as curposo,
      ld_cmp.curtpv                                                as curtpv,
      ld_cmp.curposv                                               as curposv,
      ld_cmp.curtpb                                                as curtpb,
      ld_cmp.curposb                                               as curposb,
      ld_cmp.curtpc                                                as curtpc,
      ld_cmp.curposc                                               as curposc,
      ld_cmp.curtpd                                                as curtpd,
      ld_cmp.curposd                                               as curposd,
      ld_cmp.curtpe                                                as curtpe,
      ld_cmp.curpose                                               as curpose,
      ld_cmp.curtpf                                                as curtpf,
      ld_cmp.curposf                                               as curposf,
      ld_cmp.curtpg                                                as curtpg,
      ld_cmp.curposg                                               as curposg,
      // --- TACC_TRGT_LDGR and FAGL_TLDGRP_MAP ---

      case when accpr_ldgrp.ldgrp_gl <> '' then accpr_ldgrp.ldgrp_gl
                                           else ld_cmp.rldnr  end  as ldgrp,
      
      // --- fagl_tldgrp.represent                                        as represent,

      'X'                                                          as represent,
      // --- FINSC_LEDGER ---

      ledger.tech_ledger                                           as tech_ledger,
      // --- FAAC_VALVIEW0 ---

      valview0.valview_type                                        as VALVIEW_TYPE,
      case valview0.valview_type  when 'C01' then ' ' 
                                  when 'C02' then ' '
                                  else 'X'                     end as xstore,
      valview0.sign_apc                                            as SIGN_APC,
      valview0.sign_nbv                                            as SIGN_nbv,
      valview0.sign_depr_ord                                       as SIGN_DEPR_ORD,
      valview0.sign_depr_spec                                      as SIGN_DEPR_spec,
      valview0.sign_depr_unpl                                      as SIGN_DEPR_unpl,
      valview0.sign_trans_reserves                                 as SIGN_trans_reserves,
      valview0.sign_reval_apc                                      as SIGN_reval_apc,
      valview0.sign_reval_depr_ord                                 as sign_reval_depr_ord,
      valview0.sign_invest_support                                 as SIGN_INVEST_SUPPORT,
      valview0.sign_interest                                       as SIGN_INTEREST,
      valview0.glo_valview_type                                    as GLO_VALVIEW_TYPE,
      // --- FAAC_VALVIEW1A ---

      valview1a.posting_type                                       as POSTING_TYPE,
      valview1a.value_takeover                                     as VALUE_TAKEOVER,
      valview1a.parameter_takeover                                 as PARAMETER_TAKEOVER,
      valview1a.is_value_identical                                 as IS_VALUE_IDENTICAL,
      valview1a.is_parameter_identical                             as IS_PARAMETER_IDENTICAL,
      valview1a.depr_calc_sequence                                 as DEPR_CALC_SEQUENCE,
      valview1a.valview_adjust                                     as VALVIEW_ADJUST,
      // --- FAAC_T093_EMU (raw) ---

      ld_cmp.curtph                                                as currency_type,
      #FAA_CURR_INDEX.'1'                                          as currency_index,
      #XFELD.' '                                                   as is_parallel_area,
      'HSL'                                                        as amount_field,
      'RHCUR'                                                      as currency_field
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAAC_AP0",
"FAAC_CMP_DA0",
"FAAC_VALVIEW0",
"FAAC_VALVIEW1A",
"FINSC_LD_CMP",
"FINS_TECH_LEDGER",
"T001",
"TACC_TRGT_LDGR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/