topic Re: function in Application Development and Automation Discussions

function

Former Member — Tue, 06 Feb 2007 13:42:31 GMT

Dear friends

Can any one show me what is the use of below function and which parameters should pass

CONVERT_TO_LOCAL_CURRENCY

Thanks

karthik

Re: function

Former Member — Tue, 06 Feb 2007 13:44:40 GMT

Hi,

u can Translate foreign currency amount to local currency.

u have to pass the values for:

DATE

FOREIGN_AMOUNT

FOREIGN_CURRENCY

LOCAL_CURRENCY

regards,

madhu

Re: function

Former Member — Tue, 06 Feb 2007 13:44:49 GMT

Check this example:

CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'

EXPORTING DATE = BKPF-WWERT

FOREIGN_CURRENCY = BKPF-WAERS

LOCAL_CURRENCY = T001-WAERS

FOREIGN_AMOUNT = BSEG-WRBTR

RATE = BKPF-KURSF

TYPE_OF_RATE = 'M'

IMPORTING EXCHANGE_RATE = KURS

LOCAL_AMOUNT = BSEG-DMBTR

FOREIGN_FACTOR = FAKTOR-F

LOCAL_FACTOR = FAKTOR-L

FIXED_RATE = FIXKURS

EXCEPTIONS NO_RATE_FOUND = 4

NO_FACTORS_FOUND = 8.

Regards,

Ravi

Re: function

Former Member — Tue, 06 Feb 2007 13:45:00 GMT

CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'
       EXPORTING
*    CLIENT                  = 001
        DATE                    = sy-datum
         FOREIGN_CURRENCY        = wa1-WAERS " here you need to declare your foreign currency i.e USD
         LOCAL_CURRENCY          = TCURR-FCURR
         FOREIGN_AMOUNT          = wa1-DMBTR " here you need to declare your amount field.
*    RATE                    = tcurr-ukurs
        TYPE_OF_RATE            = 'M'        " check this also the average rate
*    READ_TCURR              = 'X'
      IMPORTING
        EXCHANGE_RATE           = tcurr-UKURS
*    FOREIGN_FACTOR          =
        LOCAL_AMOUNT            = wa1-TOTAL  " this is the field where the converted amt has to be displayed.
*    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
               .
 IF SY-SUBRC <> 0.
** MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
**         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

Re: function

Former Member — Tue, 06 Feb 2007 13:45:09 GMT

Hi Karthik,

Translate foreign currency amount to local currency

An amount in local currency is calculated from a specified foreign

currency amount. For this, you may either specify the translation rate

manually (Parameter RATE) or have the system determine it from table

TCURR on the basis of the rate type, date and currency key. Because the

ratios for the units of the currencies involved in the translation are

significant for this translation, table TCURF is always read by the

program, and there must be a valid entry there for the data specified.

IF exchange rate fixing is defined for the exchange rate type

TYPE_OF_RATE or an alternative exchange rate is defined for the currency

pair, this information is transferred to the calling program.

When table TCURR is read, the foreign currency key is always taken as

the first part of the key and the local currency as the second part.

For More Information you can click on the FM document in SE37

Re: function

Former Member — Tue, 06 Feb 2007 13:45:47 GMT

HI,

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

Regards

Sudheer

Re: function

Former Member — Tue, 06 Feb 2007 13:48:12 GMT

hi,

u use it to convert foreign currency(usd) to local currency (inr).

pass date , foreign amount = specify here the amount in say usd (dollars)

under foreign currency - usd

local currency - inr

and in exporting parameter u get the local amount