Cuurency Conversion

[Former Member]

Hi,

In my sales report i get the sales amount in JPY Yen but i want in EUR.

I am using the logic like this:

standard price * billing qty = sales amount.

standard price is EUR

billing qty is JPY and sales amount in JPY.

But i need the sales amount in Local Currency (which is EUR).

Please suggest.

[ferry_lianto]

Hi,

Please check this FM.

CONVERT_TO_LOCAL_CURRENCY

CONVERT_TO_FOREIGN_CURRENCY

Regards,

Ferry Lianto

[Former Member]

Hi Rao

Please check the FMs

CONVERT_TO_FOREIGN_CURRENCY

CONVERT_TO_LOCAL_CURRENCY

CONVERT_AMOUNT_TO_CURRENCY

Regards

Caglar

[Former Member]

Hi,

Here is the simple program

DATA: gd_fcurr TYPE tcurr-fcurr,

gd_tcurr TYPE tcurr-tcurr,

gd_date TYPE sy-datum,

gd_value TYPE i.

gd_fcurr = 'JPY'.

gd_tcurr = 'EUR'.

gd_date = sy-datum.

gd_value = 10.

PERFORM currency_conversion USING gd_fcurr

gd_tcurr

gd_date

CHANGING gd_value.

• Convert value to Currency value

&----

---

*& Form currency_conversion

&----

---

• text

----

---

• -->P_GD_FCURR text

• -->P_GD_TCURR text

• -->P_GD_DATE text

• <--P_GD_VALUE text

----

---

FORM currency_conversion USING p_fcurr

p_tcurr

p_date

CHANGING p_value.

DATA: t_er TYPE tcurr-ukurs,

t_ff TYPE tcurr-ffact,

t_lf TYPE tcurr-tfact,

t_vfd TYPE datum,

ld_erate(12) TYPE c.

CALL FUNCTION 'READ_EXCHANGE_RATE'

EXPORTING

• CLIENT = SY-MANDT

date = p_date

foreign_currency = p_fcurr

local_currency = p_tcurr

TYPE_OF_RATE = 'M'

• EXACT_DATE = ' '

IMPORTING

exchange_rate = t_er

foreign_factor = t_ff

local_factor = t_lf

valid_from_date = t_vfd

• DERIVED_RATE_TYPE =

• FIXED_RATE =

• OLDEST_RATE_FROM =

EXCEPTIONS

no_rate_found = 1

no_factors_found = 2

no_spread_found = 3

derived_2_times = 4

overflow = 5

zero_rate = 6

OTHERS = 7

.

IF sy-subrc EQ 0.

ld_erate = t_er / ( t_ff / t_lf ).

p_value = p_value * ld_erate.

ENDIF.

ENDFORM. " currency_conversion

Regards

Sudheer

[Former Member]

use... CONVERT_TO_FOREIGN_CURRENCY fm thru which u can convert yen to eur.

[Former Member]

Hi Guys,

In the program before passing to the FM REUSE_ALV_GRID_DISPLAY,

I have amount as 455.05 and in the display i have 45,505.

Issue is with calculation or display of units, revenue and cost for Japan. It looks like the values were multiplied by a 100 due to the fact that there are no decimals for values expressed in Japanese Yens.

Please suggest.