Skip to Content
avatar image
Former Member

How to set-up currency conversion with TCURR and TCURF

Hi,

This is very basic, but I'm lost.

I'm trying to set-up a correct currency conversion with SAP HANA Studio and useing the tables TCURR und TCURF (from BW).

But I still didn't manage to get the right ratio. Some examples:

TCURF:

MANDT:KURST:FCURR:TCURR:GDATU:UKURS;FFACT:TFACT

200;DM;CAD;EUR;79919898;1;1;;00000000


and

200;DM;AED;EUR;79919898;100;1;;00000000

TCURR:

MANDT:KURST:FCURR:TCURR:GDATU:UKURS:FFACT:TFACT

200;DM;CAD;EUR;79909168;-154,94432;0;0

and

200;DM;AED;EUR;79909069;-5,34151;0;0

What I need is an conversion rate like 1 AED = 0,23 EUR.


What I tried was something like...

( UKURS / FFACT*(-1) ) * TFACT = conversion rate

But in this case it would be for...

CAD - EUR : (-154,94432 / 1*(-1)) * 1 = 154,94432 (should be 1 EUR = 1,54 CAD)

AED - EUR : (-5,34151 / 100*(-1)) * 1 = 0,0534151 (should be 1 EUR = 5,34 AED)

What am I'm doing wrong? Why is the ration from CAD to EUR 1:1 but the UKURS is 154,xx ? The exchange rate is nearly 1:1.

Can anybody help?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 31, 2016 at 01:06 PM
    FROM TO UKURS FRACT TRACT REAL CONV
    CDF EUR 1220,545 100 1 1043,43 AED EUR 4,52 100 1 4,1857 AUD EUR 1,43 1 1 1,48 BRL EUR 432,24 100 1 4,32 LBP EUR 16,74993 100 1 1719,01 ISK EUR 142,3037 100 1 140,764 ARS EUR 1.618,95 100 1

    16,654

    Add comment
    10|10000 characters needed characters exceeded