convert_to_local_currency

[Former Member]

hi,

i am using the function module CONVERT_TO_LOCAL_CURRENCY as below ,its giving me an error 'Enter rate USD/1000 rate type M for 31.01.2007 in the system settings' .

090 M CAD USD 79989481 1.53290- 0 0

the above is the value that is maintained in the TCURR table...do i need to maintain this in some other table as well?

CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'

EXPORTING

CLIENT = SY-MANDT

date = sy-datum

foreign_amount = 'CAD'

foreign_currency = 'USD'

local_currency = amount

RATE = 0

TYPE_OF_RATE = 'M'

READ_TCURR = 'X'

IMPORTING

• EXCHANGE_RATE =

• FOREIGN_FACTOR =

LOCAL_AMOUNT = Local

plz guide me on this.

Regards

Syed

[Former Member]

copy paste this and try out

CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'
EXPORTING
CLIENT = SY-MANDT
date = sy-datum
foreign_amount = amount                    " changed here
foreign_currency = 'CAD'
local_currency = 'USD'
RATE = 0
TYPE_OF_RATE = 'M'
READ_TCURR = 'X'
IMPORTING
* EXCHANGE_RATE =
* FOREIGN_FACTOR =
LOCAL_AMOUNT = Local

[Former Member]

Hi Syed

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 = 'CAD'

LOCAL_CURRENCY = 'USD'

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

[Former Member]

Hi,

just check the exchange rates maintained in the system settings as per the date.

and exporting the exchange rate.

Regards,

Pavan.

[Former Member]

Hi,

Thanks for ur help

Regards