Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question