fiscds_ldcmpcurr

@AbapCatalog.sqlViewName: 'FISV_LDCMP_CUR'
@EndUserText.label: 'Currencies of Company Code and Ledger'
@ObjectModel.usageType.serviceQuality: #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view  fiscds_ldcmpcurr as select from
(((((
((((((((( finsc_ld_cmp inner      join t001  on finsc_ld_cmp.bukrs = t001.bukrs ) 
                       inner      join t000  on finsc_ld_cmp.mandt = t000.mandt )   
                       left outer join t005  on t001.land1 = t005.land1 )
                       left outer join t880  on t001.rcomp = t880.rcomp )      
                       left outer join tka02 on finsc_ld_cmp.bukrs = tka02.bukrs )
                       left outer join tka01 on tka02.kokrs = tka01.kokrs ) 
                       left outer join finsc_001a as finsc_001a_osl
                                             on  ( finsc_ld_cmp.bukrs = finsc_001a_osl.bukrs or finsc_001a_osl.bukrs = '' ) 
                                             and finsc_ld_cmp.curtpo = finsc_001a_osl.curtype )    
                       left outer join finsc_001a as finsc_001a_vsl
                                             on  ( finsc_ld_cmp.bukrs = finsc_001a_vsl.bukrs or finsc_001a_vsl.bukrs = '' ) 
                                             and finsc_ld_cmp.curtpv = finsc_001a_vsl.curtype )                                                 
                       left outer join finsc_001a as finsc_001a_bsl
                                             on  ( finsc_ld_cmp.bukrs = finsc_001a_bsl.bukrs or finsc_001a_bsl.bukrs = '' ) 
                                             and finsc_ld_cmp.curtpb = finsc_001a_bsl.curtype )                                                
                       left outer join finsc_001a as finsc_001a_csl
                                             on  ( finsc_ld_cmp.bukrs = finsc_001a_csl.bukrs or finsc_001a_csl.bukrs = '' ) 
                                             and finsc_ld_cmp.curtpc = finsc_001a_csl.curtype )                                             
                       left outer join finsc_001a as finsc_001a_dsl
                                             on  ( finsc_ld_cmp.bukrs = finsc_001a_dsl.bukrs or finsc_001a_dsl.bukrs = '' ) 
                                             and finsc_ld_cmp.curtpd = finsc_001a_dsl.curtype )                                             
                       left outer join finsc_001a as finsc_001a_esl
                                             on  ( finsc_ld_cmp.bukrs = finsc_001a_esl.bukrs or finsc_001a_esl.bukrs = '' ) 
                                             and finsc_ld_cmp.curtpe = finsc_001a_esl.curtype )                                             
                       left outer join finsc_001a as finsc_001a_fsl
                                             on  ( finsc_ld_cmp.bukrs = finsc_001a_fsl.bukrs or finsc_001a_fsl.bukrs = '' ) 
                                             and finsc_ld_cmp.curtpf = finsc_001a_fsl.curtype )                                             
                       left outer join finsc_001a as finsc_001a_gsl
                                             on  ( finsc_ld_cmp.bukrs = finsc_001a_gsl.bukrs or finsc_001a_gsl.bukrs = '' ) 
                                             and finsc_ld_cmp.curtpg = finsc_001a_gsl.curtype )                                                                                                                                                                                    
{
  finsc_ld_cmp.rldnr,
  finsc_ld_cmp.bukrs,
  finsc_ld_cmp.curtph  as curtp,
  // cast( '10' as abap.char(2)) as curtp,

  t001.waers           as hwaer,
  //t001.rcomp,

  //t001.land1,

  //

  //t001a.curtp,

  //t001a.curtp2,

  //

  //t000.mwaer as waer_30,

  //

  //t005.curin as waer_50,

  //t005.curha as waer_40,

  //

  //t880.curr as waer_60,


  // HWAE2 --> case("CURTP",'30',"WAER_30",'40',"WAER_40",'50',"WAER_50",'60',"WAER_60",' ')

  // HWAE3 --> case("CURTP2",'30',"WAER_30",'40',"WAER_40",'50',"WAER_50",'60',"WAER_60",' ')


  finsc_ld_cmp.curtpk  as curtp2,
  case finsc_ld_cmp.curtpk when '10' then t001.waers
                           when '11' then t001.waers
                           when '12' then t001.waers
                           when '20' then tka01.waers
                           when '30' then t000.mwaer
                           when '31' then t000.mwaer
                           when '32' then t000.mwaer
                           when '40' then t005.curha
                           when '41' then t005.curha
                           when '42' then t005.curha
                           when '50' then t005.curin
                           when '60' then t880.curr
                 else cast( '' as abap.cuky(5))
  end                  as hwae2,
  finsc_ld_cmp.curposk as curpos2,


  // Free Defined Currency 1

  finsc_ld_cmp.curtpo  as curtp3,
  case finsc_ld_cmp.curtpo when '10' then t001.waers
                           when '11' then t001.waers
                           when '12' then t001.waers
                           when '20' then tka01.waers
                           when '30' then t000.mwaer
                           when '31' then t000.mwaer
                           when '32' then t000.mwaer
                           when '40' then t005.curha
                           when '41' then t005.curha
                           when '42' then t005.curha
                           when '50' then t005.curin
                           when '60' then t880.curr
                           when finsc_001a_osl.curtype then case
                                                              when finsc_001a_osl.waers <> '' and finsc_001a_osl.waers is not null then finsc_001a_osl.waers
                                                              else cast( '' as abap.cuky(5))
                                                              end
                 else cast( '' as abap.cuky(5))
  end                  as hwae3,

  // Free Defined Currency 2

  finsc_ld_cmp.curtpv  as curtp4,
  case finsc_ld_cmp.curtpv when '10' then t001.waers
                           when '11' then t001.waers
                           when '12' then t001.waers
                           when '20' then tka01.waers
                           when '30' then t000.mwaer
                           when '31' then t000.mwaer
                           when '32' then t000.mwaer
                           when '40' then t005.curha
                           when '41' then t005.curha
                           when '42' then t005.curha
                           when '50' then t005.curin
                           when '60' then t880.curr
                           when finsc_001a_vsl.curtype then case
                                                              when finsc_001a_vsl.waers <> '' and finsc_001a_vsl.waers is not null then finsc_001a_vsl.waers
                                                              else cast( '' as abap.cuky(5))
                                                              end
                 else cast( '' as abap.cuky(5))
  end                  as hwae4,

  // Free Defined Currency 3

  finsc_ld_cmp.curtpb  as curtp5,
  case finsc_ld_cmp.curtpb when '10' then t001.waers
                           when '11' then t001.waers
                           when '12' then t001.waers
                           when '20' then tka01.waers
                           when '30' then t000.mwaer
                           when '31' then t000.mwaer
                           when '32' then t000.mwaer
                           when '40' then t005.curha
                           when '41' then t005.curha
                           when '42' then t005.curha
                           when '50' then t005.curin
                           when '60' then t880.curr
                           when finsc_001a_bsl.curtype then case
                                                              when finsc_001a_bsl.waers <> ''  and finsc_001a_bsl.waers is not null then finsc_001a_bsl.waers
                                                              else cast( '' as abap.cuky(5))
                                                              end
                 else cast( '' as abap.cuky(5))
  end                  as hwae5,


  // Free Defined Currency 4

  finsc_ld_cmp.curtpc  as curtp6,
  case finsc_ld_cmp.curtpc when '10' then t001.waers
                           when '11' then t001.waers
                           when '12' then t001.waers
                           when '20' then tka01.waers
                           when '30' then t000.mwaer
                           when '31' then t000.mwaer
                           when '32' then t000.mwaer
                           when '40' then t005.curha
                           when '41' then t005.curha
                           when '42' then t005.curha
                           when '50' then t005.curin
                           when '60' then t880.curr
                           when finsc_001a_csl.curtype then case
                                                              when finsc_001a_csl.waers <> ''  and finsc_001a_csl.waers is not null then finsc_001a_csl.waers
                                                              else cast( '' as abap.cuky(5))
                                                              end
                 else cast( '' as abap.cuky(5))
  end                  as hwae6,

  // Free Defined Currency 5

  finsc_ld_cmp.curtpd  as curtp7,
  case finsc_ld_cmp.curtpd when '10' then t001.waers
                           when '11' then t001.waers
                           when '12' then t001.waers
                           when '20' then tka01.waers
                           when '30' then t000.mwaer
                           when '31' then t000.mwaer
                           when '32' then t000.mwaer
                           when '40' then t005.curha
                           when '41' then t005.curha
                           when '42' then t005.curha
                           when '50' then t005.curin
                           when '60' then t880.curr
                           when finsc_001a_dsl.curtype then case
                                                              when finsc_001a_dsl.waers <> ''  and finsc_001a_dsl.waers is not null then finsc_001a_dsl.waers
                                                              else cast( '' as abap.cuky(5))
                                                              end
                 else cast( '' as abap.cuky(5))
  end                  as hwae7,

  // Free Defined Currency 6

  finsc_ld_cmp.curtpe  as curtp8,
  case finsc_ld_cmp.curtpe when '10' then t001.waers
                           when '11' then t001.waers
                           when '12' then t001.waers
                           when '20' then tka01.waers
                           when '30' then t000.mwaer
                           when '31' then t000.mwaer
                           when '32' then t000.mwaer
                           when '40' then t005.curha
                           when '41' then t005.curha
                           when '42' then t005.curha
                           when '50' then t005.curin
                           when '60' then t880.curr
                           when finsc_001a_esl.curtype then case
                                                              when finsc_001a_esl.waers <> ''  and finsc_001a_esl.waers is not null then finsc_001a_esl.waers
                                                              else cast( '' as abap.cuky(5))
                                                              end
                 else cast( '' as abap.cuky(5))
  end                  as hwae8,

  // Free Defined Currency 7

  finsc_ld_cmp.curtpf  as curtp9,
  case finsc_ld_cmp.curtpf when '10' then t001.waers
                           when '11' then t001.waers
                           when '12' then t001.waers
                           when '20' then tka01.waers
                           when '30' then t000.mwaer
                           when '31' then t000.mwaer
                           when '32' then t000.mwaer
                           when '40' then t005.curha
                           when '41' then t005.curha
                           when '42' then t005.curha
                           when '50' then t005.curin
                           when '60' then t880.curr
                           when finsc_001a_fsl.curtype then case
                                                              when finsc_001a_fsl.waers <> ''  and finsc_001a_fsl.waers is not null then finsc_001a_fsl.waers
                                                              else cast( '' as abap.cuky(5))
                                                              end
                 else cast( '' as abap.cuky(5))
  end                  as hwae9,

  // Free Defined Currency 8

  finsc_ld_cmp.curtpg  as curtp10,
  case finsc_ld_cmp.curtpg when '10' then t001.waers
                           when '11' then t001.waers
                           when '12' then t001.waers
                           when '20' then tka01.waers
                           when '30' then t000.mwaer
                           when '31' then t000.mwaer
                           when '32' then t000.mwaer
                           when '40' then t005.curha
                           when '41' then t005.curha
                           when '42' then t005.curha
                           when '50' then t005.curin
                           when '60' then t880.curr
                           when finsc_001a_gsl.curtype then case
                                                              when finsc_001a_gsl.waers <> ''  and finsc_001a_gsl.waers is not null then finsc_001a_gsl.waers
                                                              else cast( '' as abap.cuky(5))
                                                              end
                 else cast( '' as abap.cuky(5))
  end                  as hwae10,
  
  
  // Functional Currency

cast( case when finsc_ld_cmp.functional_currency <> '  ' then finsc_ld_cmp.functional_currency
                                                         else finsc_ld_cmp.curtph           
      end                                    
      as fis_functional_currole 
     ) as curtp11,
  case finsc_ld_cmp.functional_currency when '10' then t001.waers
                                        when '11' then t001.waers
                                        when '12' then t001.waers
                                        when '20' then tka01.waers
                                        when '30' then t000.mwaer
                                        when '31' then t000.mwaer
                                        when '32' then t000.mwaer
                                        when '40' then t005.curha
                                        when '41' then t005.curha
                                        when '42' then t005.curha
                                        when '50' then t005.curin
                                        when '60' then t880.curr
                                        when '  ' then t001.waers       // Functional Currency = '  '  ==>  = '10'

                           when finsc_001a_osl.curtype then case
                                                              when finsc_001a_osl.waers <> '' and finsc_001a_osl.waers is not null then finsc_001a_osl.waers
                                                              else cast( '' as abap.cuky(5))
                                                              end
                           when finsc_001a_vsl.curtype then case
                                                              when finsc_001a_vsl.waers <> '' and finsc_001a_vsl.waers is not null then finsc_001a_vsl.waers
                                                              else cast( '' as abap.cuky(5))
                                                              end    
                           when finsc_001a_bsl.curtype then case
                                                              when finsc_001a_bsl.waers <> ''  and finsc_001a_bsl.waers is not null then finsc_001a_bsl.waers
                                                              else cast( '' as abap.cuky(5))
                                                              end
                           when finsc_001a_csl.curtype then case
                                                              when finsc_001a_csl.waers <> ''  and finsc_001a_csl.waers is not null then finsc_001a_csl.waers
                                                              else cast( '' as abap.cuky(5))
                                                              end                                                                                                                                                                                                                
                           when finsc_001a_dsl.curtype then case
                                                              when finsc_001a_dsl.waers <> ''  and finsc_001a_dsl.waers is not null then finsc_001a_dsl.waers
                                                              else cast( '' as abap.cuky(5))
                                                              end                                                        
                           when finsc_001a_esl.curtype then case
                                                              when finsc_001a_esl.waers <> ''  and finsc_001a_esl.waers is not null then finsc_001a_esl.waers
                                                              else cast( '' as abap.cuky(5))
                                                              end
                           when finsc_001a_fsl.curtype then case
                                                              when finsc_001a_fsl.waers <> ''  and finsc_001a_fsl.waers is not null then finsc_001a_fsl.waers
                                                              else cast( '' as abap.cuky(5))
                                                              end                                                              
                           when finsc_001a_gsl.curtype then case
                                                              when finsc_001a_gsl.waers <> ''  and finsc_001a_gsl.waers is not null then finsc_001a_gsl.waers
                                                              else cast( '' as abap.cuky(5))
                                                              end                                                                                                                                                                                                                                  
                 else cast( '' as abap.cuky(5))
  end                  as hwae11  

}   
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINSC_001A",
"FINSC_LD_CMP",
"T000",
"T001",
"T005",
"T880",
"TKA01",
"TKA02"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/