Exchange rate recalculation

[Former Member]

HI All,

In the current process, the XAF/USD rate is updated daily by Bloomberg feed. However, the XAF is actually pegged to EUR, and to arrive at the USD conversion rate, we have to perform a calculation:

EUR/USD (from Bloomberg) x XAF/EUR (fixed at a rate of u201C655.957u201D) = XAF/USD.

This calculation should be performed automatically on a daily basis, and the exchange rate type M for XAF/USD should overwrite whatever Bloomberg sends daily.

The fixed rate of u201C655.957u201D XAF for 1 EUR, will not change in foreseeable future. This same since 10 yrs.

Can you please help me how can we find the solution for the above.

Thanks and regards,

SAP Care

[Former Member]

Hi

I believe, you will have to maintain translation ratios between EUR/USD and XAF/EUR. Once done, system will automatically calculate XAF/USD value

Raj

[Former Member]

HI Puskaraj,

Thanks for the reply.

I was trying to make the change as termed by you.

But the system cannot set the XAF/EUR for Ex. rate type "M" as the target currency should always be "USD" for this ex. type.

In this scenario, what should be my Ex. rate type for XAF/EUR and how can we proceed further.

Thanks and regards.

SAP Care

[Former Member]

Once you maintain translation ration as above in SPRO-SAP Netweaver-General settings-Currencies-Define translation ratio for M rate type, you can maintain exchange rates for EUR/XAF and EUR/USD for M. System will calculate XAF/USD auto.

Hope this helps

Raj

[Former Member]

Hi,

Thanks again.

1. YOu mean to say that we should not upload the XAF/USD translation ration from the Feed.

2. Calculaton:

The system will try to calculate the XAF/EUR with "M" and EUR/USD will be calculated automatically.

Ex: IF XAF/EUR = 500

and EUR/USD = 1.5

Then the conversion for the USD = 750 XAF (Is this right?)

Can you please also explain me process flow to check the same.

Thanks and regards.

SAP Care

[Former Member]

Yes, its correct.

Raj

[Former Member]

HI Pushkraj,

I have maintained the Translation ratio for XAF/EUR for ex. Rate type M

I have tried to post a Vendor Invoice with XAF currency. The company code currency is USD.

The system asks for XAF/USD exchange rate, in OB08.

If I maintain the rate here, then it takes the exchange rate given here (Lets take this as 680).

My requirement is that the earlier translation of XAF/EUR (lets take 600) and to EUR/USD(1.2) is not coming into the process, which should be 720 XAF.

Hence, the system is calculating the value of OB08 directly, but not the logical process we are trying to do.

Please help me with any inputs/changes/additions for the above.

Thanks and regards,

SAP Care