FAA_CFG_CMP_DA

@AbapCatalog.sqlViewName: 'FAAV_CFG_CMP_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 Depreciation Areas after REDESIGN'
define view FAA_CFG_CMP_DA 

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      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 faat_cmp_da     as cmp_da        on  cmp_da.comp_code          = ld_cmp.bukrs
                                                   and cmp_da.ledger             = ld_cmp.rldnr
                                                   and cmp_da.depr_area          = cmp_da0.depr_area   
                                                   
  left outer join faac_cmp_da0    as da_v_takeover on  da_v_takeover.comp_code   = cmp_da0.comp_code
                                                   and da_v_takeover.ledger      = cmp_da0.ledger
                                                   and da_v_takeover.valview     = valview1a.value_takeover
                                                           
  left outer join faac_cmp_da0    as da_p_takeover on  da_p_takeover.comp_code   = cmp_da0.comp_code
                                                   and da_p_takeover.ledger      = cmp_da0.ledger
                                                   and da_p_takeover.valview     = valview1a.parameter_takeover   
  
  left outer join faac_cmp_da0    as da_quantity   on  da_quantity.comp_code       = cmp_da0.comp_code
                                                   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,
      
      case when cmp_da0.depr_fisc_year_var <> '' then cmp_da0.depr_fisc_year_var
           else                                       ld_cmp.periv
           end                                                     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,
          
      // --- 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,
      valview0.glo_pt_assetreportedict                             as GLO_PT_ASSETREPORTEDICT,
      
      // --- 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,
      
      // --- TRANSFER RULES 

      da_v_takeover.depr_area                                      as VALUE_TAKEOVER_AREA,
      da_p_takeover.depr_area                                      as PARAMETER_TAKEOVER_AREA,
      
      // --- FAAC_T093_EMU (raw) ---

      ld_cmp.curtph                                                as currency_type,
      t001.waers                                                   as currency,
      #FAA_CURR_INDEX.'1'                                          as currency_index,
      #XFELD.' '                                                   as is_parallel_area,
      'HSL'                                                        as amount_field,
      'RHCUR'                                                      as currency_field,
      
      // --- Master Data from FAAT_CMP_DA

      cmp_da.closed_fisc_year                                      as closed_fisc_year 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAAC_CMP_DA0",
"FAAC_VALVIEW0",
"FAAC_VALVIEW1A",
"FAAT_CMP_DA",
"FINSC_LD_CMP",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/