Skip to Content
0
Former Member
Jun 14, 2011 at 10:03 AM

Ratio in Currency Conversion

1520 Views

Hi ... Can you plz clarify me on the significance of maintaining "from/to ratio" in currency conversion? I could see few threads related to that in this forum but still I am in confusion.

To my knowledge, "From/ To Ratio" is maintained in two places under currency setting in SPRO (Define Translation ratios for Currency Translation AND Enter Exchange rates), which would get stored in tables TCURR and TCURF. I have below questions pertaining to this ratio maintenance:

1. How these ratios are being considered during currency conversion? Please give me the formula used in the logic.

2. Why it is being maintained at two places?

3. Which one is the priority?

Here are some sample entries for few currecies. Local currency in our case is EUR. I couldn't come to a conclusion on how the exchange rate is getting calculated. In case of INR and IDR, it is not giving correct value. Can you please advise, whether the below entries are correct, especially for IDR --> EUR conversion?

Current conversion rates as per google site (just for your reference)

1 EUR = 64.5942438 INR

1 EUR = 9.34722906 CNY

1 EUR = 12,334.188 IDR

TCURF and TCURR entries for INR and EUR currencies:

Exch.rate type - From currency - To currency - Valid from - Ratio (from) - Ratio (to) - Alt.exch.ratety - Ex.rate valid from

EURX - EUR - INR - 81999898 - 1 - 1 - No value - 00/00/0000

EURX - INR - EUR - 81999898 - 1 - 1 - No value - 00/00/0000

Exch.rate type - From currency - To currency - Valid from - Exchange Rate - Ratio (from) - Ratio (to)

EURX - INR - EUR - 79889389 - 6,467.55200- - 100 - 1

TCURF and TCURR entries for CNY and EUR currencies:

Exch.rate type - From currency - To currency - Valid from - Ratio (from) - Ratio (to) - Alt.exch.ratety - Ex.rate valid from

EURX - CNY - EUR - 81999898 - 1 - 1 - No value - 00/00/0000

Exch.rate type - From currency - To currency - Valid from - Exchange Rate - Ratio (from) - Ratio (to)

EURX - CNY - EUR - 79889389 - 9.36962- - 100 - 1

TCURF and TCURR entries for IDR and EUR currencies:

Exch.rate type - From currency - To currency - Valid from - Ratio (from) - Ratio (to) - Alt.exch.ratety - Ex.rate valid from

EURX - EUR - IDR - 81999898 - 1 - 1 - No value - 00/00/0000

EURX - IDR - EUR - 81999898 - 1 - 1 - No value - 00/00/0000

Exch.rate type - From currency - To currency - Valid from - Exchange Rate - Ratio (from) - Ratio (to)

EURX - IDR - EUR - 79889389 - 12.31558- - 10,000 - 1

Please help.

Thanks,

Arun