exch_rates.sql

Source: DMF/PuC/AIF/FelipeBkp/exch_rates.sql

select '20140106' as START_DATE,
       '21000101' AS END_DT,
       ABS(t.UKURS) as EXCHANGE_RATE,
       t.TCURR AS FROM_CURRENCY_CODE,
       t.fcurr as TO_CURRENCY_CODE, 
       'O' as RATE_TYPE       
  from sap_slt_prod_pv1.tcurr t
  left join sap_slt_prod_pv1.TCURF t2 on t2.mandt = t.mandt and t2.KURST =t.KURST and t2.FCURR =t.FCURR and t2.TCURR =t.TCURR and t2.GDATU =t.GDATU
  where 1=1
  AND 99999999 - t.GDATU = '20260101'
  and t.KURST = 'P001'
union all
select '20140106' as START_DATE,
       '21000101' AS END_DT,
       ROUND(1/ABS(t.UKURS),6) as EXCHANGE_RATE,
       t.fcurr as FROM_CURRENCY_CODE, 
       t.TCURR AS TO_CURRENCY_CODE,
       'O' as RATE_TYPE
  from sap_slt_prod_pv1.tcurr t
  left join sap_slt_prod_pv1.TCURF t2 on t2.mandt = t.mandt and t2.KURST =t.KURST and t2.FCURR =t.FCURR and t2.TCURR =t.TCURR and t2.GDATU =t.GDATU
  where 1=1
  AND 99999999 - t.GDATU = '20260101'
  and t.KURST = 'P001'
;