topic Re: Exchange rate problem in Application Development and Automation Discussions

Exchange rate problem

former_member216914 — Mon, 10 Nov 2014 01:48:45 GMT

Dear Experts,

I have develop one report for tax (BSET) but the problem is when I translating the value to another currency with time with exchange rate in BKPF, the value is not same as translating in FB03 (Display Currency: Group Currency). Please help.

Exchange rate : 3.24897

My report :

FB03 :

My code :

WA_HWBAS-MYCURR = WA_HWBAS-HWBAS * GS_BKPF-KURS2.

Regards,

Feisal

Re: Exchange rate problem

paul_bakker2 — Mon, 10 Nov 2014 02:06:57 GMT

Hi,

It's a rounding issue. The exchange rate used in FB03 apparently uses many more decimal places.

cheers

Paul

Re: Exchange rate problem

former_member216914 — Mon, 10 Nov 2014 02:15:26 GMT

Hi Paul,

Thank for reply. Do you know where can get exchange rate same as FB03.

Regards,

Feisal

Re: Exchange rate problem

paul_bakker2 — Mon, 10 Nov 2014 02:29:12 GMT

Not offhand.. I would just debug FB03 to find out where it comes from.

good luck

Paul

Re: Exchange rate problem

Former Member — Mon, 10 Nov 2014 03:09:11 GMT

Use the same roundoff for your exchange rate field(BKPF-KURS2) as in FB03 transaction.

Re: Exchange rate problem

former_member216914 — Mon, 10 Nov 2014 06:27:27 GMT

Hi,

How to expand exchange rate (BKPF-KURS2)?

Re: Exchange rate problem

Former Member — Mon, 10 Nov 2014 09:15:11 GMT

Hi,

Assign BKPF-KURS2 to a variable which has the length specification which you need ( create a date element with the same specification with the modification in the length as you expected) and use a new variable.

Re: Exchange rate problem

DominikKraemer — Mon, 10 Nov 2014 09:43:32 GMT

Why not use the FM CONVERT_TO_FOREIGN_CURRENCY?

Re: Exchange rate problem

Former Member — Mon, 10 Nov 2014 13:20:37 GMT

It depends upon the type of rate being used. In case of indirect currency calculation, you may get the values like that.

Re: Exchange rate problem

former_member216914 — Tue, 11 Nov 2014 00:55:38 GMT

Hi Dominik,

I cannot use this function module because the exchange rate base on posting date.

Re: Exchange rate problem

former_member216914 — Tue, 11 Nov 2014 01:05:27 GMT

Hi,

Already do debugging from the beginning before post in forum. Too complicated.

Re: Exchange rate problem

former_member216914 — Tue, 11 Nov 2014 01:06:25 GMT

Its will be add more zero at behind.

Re: Exchange rate problem

DominikKraemer — Tue, 11 Nov 2014 08:11:56 GMT

Hi Ahmad,

not sure why this should be an issue? In CONVERT_TO_FOREIGN_CURRENCY you can do the conversion for any date you need -> Importing Parameter DATE

Regards,

Dominik