topic Re: currency conversion.. in Application Development and Automation Discussions

currency conversion..

Former Member — Mon, 31 Jul 2006 19:35:15 GMT

Hi All..

Can someone help how i can convert foreign currencies to USD ...

Please help me with a Function module that do not have any issues with any decimal places after conversion or the right one to convert a foriegn currency to USD ..

Appreciate your great help..

Thanks,

Kanthi..

Re: currency conversion..

Former Member — Mon, 31 Jul 2006 19:37:02 GMT

HI Kanthi,

Use the FM "CONVERT_TO_LOCAL_CURRENCY"

Regards,

Vivek

PS: Award points if helpful

Re: currency conversion..

Former Member — Mon, 31 Jul 2006 19:40:16 GMT

hi kanthi,

check this fm 'CONVERT_TO_FOREIGN_CURRENCY'

Re: currency conversion..

Former Member — Mon, 31 Jul 2006 19:42:25 GMT

Hi Kanthi,

Check out this thread for further info.

Regards,

Vivek

Re: currency conversion..

former_member181966 — Mon, 31 Jul 2006 19:42:54 GMT

FYI

Function group Function group short text

Function Module Name Short text for function module

CNIF

CNIF_CONVERT_CURRENCY2EXT

CNIF_CONVERT_CURRENCY2INT

CURR Translation Routine (e.g. for Currency)

CONVERT_CURRENCY_BY_RATE Convert currency using given rate

FAZ_INTERF_TO_ENVIRON

FAZ_CONVERT_CURRENCY

FBI5

BKK_PAYM_ITEM_CONVERT_CURRENCY

FI_TRV_WAERS_CONVERT

CONVERT_COUNTRY_CURRENCY

FTR_BAPI

MAP_CREATE_CONVERT_CURRENCY

FVEP

OPEN_PAYINS_CONVERT_CURRENCY

FVKD

CONVERT_AMOUNT_TO_CURRENCY

GMGR GM: Grant master operations

GM_CONVERT_FROM_GRANT_CURRENCY Convert Amount from Grant's Currency

GM_CONVERT_TO_GRANT_CURRENCY Convert Amount into Grant's Currency

HRBEN00UTILITY

HR_BEN_CONVERT_CURRENCY

HRCMP00GENERAL

HRCM_AMOUNT_CONVERT_CURRENCY

HRCR

HR_CONVERT_CURRENCY_RESULT

HR_CONVERT_CURRENCY_RESULT_AT

HR_CONVERT_CURRENCY_RESULT_FR

HR_CONVERT_CURRENCY_RESULT_NL

HRDC

HR_CONVERT_CURRENCY_RESULT_DE

HRHCP00_PLAN_SERVICE

HR_HCP_PLAN_CONVERT_CURRENCY

HRIA

HR_CONVERT_CURRENCY_INW

thx

Saquib

Re: currency conversion..

Former Member — Mon, 31 Jul 2006 19:43:04 GMT

Hi kanthi,

DATA: gd_fcurr TYPE tcurr-fcurr,

gd_tcurr TYPE tcurr-tcurr,

gd_date TYPE sy-datum,

gd_value TYPE i.

gd_fcurr = 'EUR'.

gd_tcurr = 'GBP'.

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,

keerthi.

Re: currency conversion..

Former Member — Mon, 31 Jul 2006 19:59:34 GMT

Hai Kanthi Reddy

Go through the following Code

Use the following F.M's

CONVERT_TO_FOREIGN_CURRENCY Convert local currency to foreign currency.

CONVERT_TO_LOCAL_CURRENCY Convert from foreign currency to local currency

Check the following Code

PARAMETERS: P_UKURS LIKE TCURR-UKURS.

DATA: BEGIN OF GI_TAB OCCURS 0,

KONWA LIKE KONP-KONWA,

STPRS LIKE MBEW-STPRS,

WAERS LIKE T001-WAERS,

END OF GI_TAB.

DATA: L_STPRS LIKE MBEW-STPRS,

L_RATE LIKE TCURR-UKURS.

IF P_UKURS IS INITIAL.

CLEAR L_RATE.

ELSE.

L_RATE = P_UKURS / 100.

ENDIF.

CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'

EXPORTING

DATE = SY-DATUM

FOREIGN_CURRENCY = GI_TAB-KONWA

LOCAL_AMOUNT = GI_TAB-STPRS

LOCAL_CURRENCY = GI_TAB-WAERS

RATE = L_RATE

IMPORTING

FOREIGN_AMOUNT = L_STPRS

EXCEPTIONS

NO_RATE_FOUND = 1

OVERFLOW = 2

NO_FACTORS_FOUND = 3

NO_SPREAD_FOUND = 4

DERIVED_2_TIMES = 5

OTHERS = 6.

CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'

EXPORTING

DATE = SY-DATUM

FOREIGN_AMOUNT = L_BELOEB

FOREIGN_CURRENCY = 'JPY'

LOCAL_CURRENCY = 'DKK'

RATE = L_RATE

TYPE_OF_RATE = 'M'

IMPORTING

EXCHANGE_RATE = L_RATE

FOREIGN_FACTOR =

LOCAL_AMOUNT = L_BELOEB

LOCAL_FACTOR =
EXCHANGE_RATEX =
FIXED_RATE =
DERIVED_RATE_TYPE =

EXCEPTIONS

NO_RATE_FOUND = 1

OVERFLOW = 2

NO_FACTORS_FOUND = 3

NO_SPREAD_FOUND = 4

DERIVED_2_TIMES = 5

OTHERS = 6.

Regards

Sreeni