topic Re: Cuurency Conversion in Application Development and Automation Discussions

Cuurency Conversion

Former Member — Thu, 19 Apr 2007 16:32:07 GMT

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.

Re: Cuurency Conversion

ferry_lianto — Thu, 19 Apr 2007 16:36:11 GMT

Hi,

Please check this FM.

CONVERT_TO_LOCAL_CURRENCY

CONVERT_TO_FOREIGN_CURRENCY

Regards,

Ferry Lianto

Re: Cuurency Conversion

Former Member — Thu, 19 Apr 2007 16:36:39 GMT

Hi Rao

Please check the FMs

CONVERT_TO_FOREIGN_CURRENCY

CONVERT_TO_LOCAL_CURRENCY

CONVERT_AMOUNT_TO_CURRENCY

Regards

Caglar

Re: Cuurency Conversion

Former Member — Thu, 19 Apr 2007 16:49:47 GMT

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

Re: Cuurency Conversion

Former Member — Thu, 19 Apr 2007 16:53:39 GMT

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

Re: Cuurency Conversion

Former Member — Thu, 19 Apr 2007 17:35:16 GMT

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.