Exchange_Rate.sql

Source: DMF/PuC/AIF/Exchange_Rate.sql

select '20140106' as START_DATE,
       --99999999 - t.GDATU 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 --,
       
       --'DMF' AS CREATE_ID,
       --SYSDATE AS CREATE_DATETIME,
  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'
  --AND UKURS < 1
union all
select '20140106' as START_DATE,
       --99999999 - t.GDATU 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 --,
       
       --'DMF' AS CREATE_ID,
       --SYSDATE AS CREATE_DATETIME,
  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'
  --AND UKURS < 1
;
 
select distinct kurst from sap_slt_prod_pv1.TCURF ;
 
select distinct currency_code from store_add_ctrl;
 
 
USD - ok
GBP - ok
CHF - ok
EUR - ok
RSD - ok
RON - ok
HUF - ok
CZK - ok
PLN - ok
 
 
select *
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'
  --AND UKURS < 1
  order by 99999999 - t.GDATU desc