topic Re: Currency Conversion in Application Development and Automation Discussions

Currency Conversion

Former Member — Wed, 28 Jan 2009 08:50:21 GMT

Hello,

I have a requirement where i need to convert my currency INR to USD. I used the FM ' CONVERT_TO_FOREIGN_CURRENCY'

CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'

EXPORTING

CLIENT = SY-MANDT

DATE = SY-DATUM

FOREIGN_CURRENCY = USD

LOCAL_AMOUNT = 1000

LOCAL_CURRENCY = INR

RATE = 0

TYPE_OF_RATE = 'M'

READ_TCURR = 'X'

But when i execute the program it says that "Field "USD" is unknown. It is neither in one of the specified tables". How do i rectify this error please help me out.

Can anyone tell me, in which table-field is the currency USD and INR are stored?

Regards,

Abhishek.

Re: Currency Conversion

Former Member — Wed, 28 Jan 2009 08:52:14 GMT

Hi,

Check table TCURR

Fields are FCURR and TCURR

Currency codes maintained in TCURC

Also see TCODE S_BCE_68000174 for maintaining the exchange rates

Regards

Edited by: Rajvansh Ravi on Jan 28, 2009 9:52 AM

Re: Currency Conversion

former_member217544 — Wed, 28 Jan 2009 08:53:52 GMT

Hi,

As USD, 1000, INR are constants we need to keep them in single quotes.

CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'

EXPORTING

CLIENT = SY-MANDT

DATE = SY-DATUM

FOREIGN_CURRENCY = 'USD'

LOCAL_AMOUNT = '1000'

LOCAL_CURRENCY = 'INR'

RATE = '0'

TYPE_OF_RATE = 'M'

READ_TCURR = 'X'.

Hope this will help you.

Regards,

Swarna Munukoti.

Re: Currency Conversion

Former Member — Wed, 28 Jan 2009 08:55:26 GMT

Hi,

The values to these variables should be passed in single quotes.

FOREIGN_CURRENCY = 'USD'

LOCAL_AMOUNT = '1000'

LOCAL_CURRENCY = 'INR'

RATE = '0'

Re: Currency Conversion

Former Member — Wed, 28 Jan 2009 08:56:20 GMT

In table TCURR, fields FCURR and TCURR.

Regards,

Joan

Re: Currency Conversion

Former Member — Wed, 28 Jan 2009 08:56:51 GMT

Give USD and INR in quotes as follows:

CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'
  EXPORTING
*   CLIENT                  = SY-MANDT
    DATE                    = sy-datum
    FOREIGN_CURRENCY        = 'USD'
    LOCAL_AMOUNT            = 1000
    LOCAL_CURRENCY          = 'INR'
*   RATE                    = 0
*   TYPE_OF_RATE            = 'M'
*   READ_TCURR              = 'X'
* IMPORTING
*   EXCHANGE_RATE           =
*   FOREIGN_AMOUNT          =
*   FOREIGN_FACTOR          =
*   LOCAL_FACTOR            =
*   EXCHANGE_RATEX          =
*   DERIVED_RATE_TYPE       =
*   FIXED_RATE              =
* 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.

It doesnt give error now.

Hope this helps

Regards,

Jayanthi.K

Re: Currency Conversion

Former Member — Wed, 28 Jan 2009 08:58:14 GMT

Try to use the fm CONVERT_TO_LOCAL_CURRENCY

BAPI_EXCHANGE_RATE_GETDETAIL

Re: Currency Conversion

tarangini_katta — Wed, 28 Jan 2009 08:59:54 GMT

Hi Abshiek,

Use ur functionm module like this

CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'

EXPORTING DATE = BKPF-WWERT

FOREIGN_CURRENCY = BKPF-WAERS

LOCAL_CURRENCY = T001-WAERS

LOCAL_AMOUNT = BSEG-DMBTR

RATE = BKPF-KURSF

TYPE_OF_RATE = 'M'

IMPORTING EXCHANGE_RATE = KURS

FOREIGN_AMOUNT = BSEG-WRBTR

FOREIGN_FACTOR = FAKTOR-F

LOCAL_FACTOR = FAKTOR-L

EXCEPTIONS NO_RATE_FOUND = 4

NO_FACTORS_FOUND = 8.

GO through the function module documenttaion of this FM.

there u have the clear information.

Thanks,

Re: Currency Conversion

Former Member — Wed, 28 Jan 2009 09:00:46 GMT

Hi,

Check the table TCURC...

Re: Currency Conversion

Former Member — Wed, 28 Jan 2009 09:02:48 GMT

Hi,

Maintain data in TCURR table parameter FCURR = USD, TCURR = INR.

Regards

Md.Mahaboobkhan

Re: Currency Conversion

Former Member — Wed, 28 Jan 2009 09:06:55 GMT

Jus try changing the code as :

CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'

EXPORTING

date = sy-datum

foreign_currency = 'USD'

local_amount = '1000.00'

local_currency = 'INR'

IMPORTING

FOREIGN_AMOUNT = l_amount .

IF sy-subrc <> 0.

ENDIF.

Only the above are mandatory . Also specify your fields within quotes.

Re: Currency Conversion

Former Member — Wed, 28 Jan 2009 09:13:02 GMT

Hi Swarna,

My question is partly is answered, I have given the values in quotes. But when i execute the program it does not retrieve any value. Where is the value of USD is being stored?.. Do i have to take another variable to store the USD value and print it?.

How do i do it? Can you please explain me with an example.

Please help me out.

Regards,

Abhishek.

Re: Currency Conversion

Former Member — Wed, 28 Jan 2009 09:14:46 GMT

Hi,

Check table TCURR for exchange rate

Regards

Re: Currency Conversion

Former Member — Wed, 28 Jan 2009 09:16:13 GMT

Hi Martina,

Do i have to declare the field I_amount, as you suggested. If so, what type of declaration should be given to the variable I_amount. ?

I have already taken a variable and declared it in importing-foreign amount. And i printed it at the end of the program. But the value retrived in the output is 0.00.

How do i rectify this?

Regards,

Abhishek

Edited by: abhishek sunkari on Jan 28, 2009 10:18 AM

Re: Currency Conversion

Former Member — Wed, 28 Jan 2009 10:39:40 GMT

Hi,

you can also use the below FM for the conversion

CALL FUNCTION 'CRM_CONVERT_CURRENCY'

EXPORTING

iv_exch_rate_date = sy-datlo

iv_source_currency = 'INR'

iv_local_currency = 'INR'

iv_target_currency = 'USD'

CHANGING

cv_value = lv_amnt

EXCEPTIONS

conversion_not_possible = 1

OTHERS = 2.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4 INTO lv_dummy.

ENDIF.

the value of lv_amnt, will be in INR before the FM is called & it will be converted to USD after execution

Re: Currency Conversion

SuhaSaha — Wed, 28 Jan 2009 10:49:57 GMT

Hello Abhishek,


CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'
EXPORTING
CLIENT = SY-MANDT
DATE = SY-DATUM
FOREIGN_CURRENCY = USD
LOCAL_AMOUNT = 1000
LOCAL_CURRENCY = INR
RATE = 0
TYPE_OF_RATE = 'M'   "--> Error may be because of this x-rate type
READ_TCURR = 'X'

Please check in TCURR what is the value in KURST (Exchange rate type) for the curr. conversion from INR --> USD. I doubt it is not 'M'. I will ask you to check in TCURR and modify your code accordingly:


CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'
EXPORTING
CLIENT = SY-MANDT
DATE = SY-DATUM
FOREIGN_CURRENCY = USD
LOCAL_AMOUNT = 1000
LOCAL_CURRENCY = INR
RATE = 0
TYPE_OF_RATE = TCURR-KURST
READ_TCURR = 'X'

Hope this helps.

BR,

Suhas

Re: Currency Conversion

Former Member — Wed, 28 Jan 2009 11:54:53 GMT

Hey Seemanthini,

Thanks a lot for the reply, i had a doubt regarding the variable 'lv_amount', i just wanted to know the declaration type. Should it be declared at the starting, if yes what should be the type of declaration.

Please help me out!

Regards,

Abhishek

Re: Currency Conversion

Former Member — Wed, 28 Jan 2009 11:58:25 GMT

Hi,

DATA : lv_amnt TYPE crmt_net_value.

just convert whatever amount type you have to lv_amnt type before calling conversion

regards,

Seema

Re: Currency Conversion

Former Member — Wed, 28 Jan 2009 12:33:04 GMT

Hey Suhas,

Thanks a lot for the reply, you were rite, the problem mite have occurred due to the "TYPE_OF_RATE".

Its default value is 'M' always. Like you said i have checked the KURST field value in TCURR table for INR. But am afraid there no KURST value maintained for INR in TCURR, which means that the currency cannot be converted from or into INR. If i consider any other currency in FM i used to be dipalyed in USD, The output value is being displayed, but if i take INR, the value shows as 0.

Can you suggest me in solving this query. Can you give the reason or the process to check the INR value.

Regards,

Abhishek.

Re: Currency Conversion

SuhaSaha — Wed, 28 Jan 2009 12:48:01 GMT

Hello Abhishek,

You got to have the x-rate maintained in TCURR table else this FM will not work.

I think you should consult with your functional team regarding this.

BR,

Suhas