topic Re: Currency Conversion in Application Development and Automation Discussions

Currency Conversion

Former Member — Fri, 09 Oct 2009 04:29:14 GMT

Hi,

I m converting Currency from USD to SAR by using FM 'CONVERT_CURRENCY_BY_RATE'.

Even though i m getting wrong value.

I hav gone through many threads to get correct solution..even though my problem not solved yet...

kindly let me knw which FM may help me out.

Regards,

Amar

Re: Currency Conversion

Former Member — Fri, 09 Oct 2009 04:35:22 GMT

Hi,

Check this Function group "SCUR" for converting Currency Amounts.

Re: Currency Conversion

Former Member — Fri, 09 Oct 2009 04:35:51 GMT

Try this FM "CONVERT_TO_LOCAL_CURRENCY"

Re: Currency Conversion

Former Member — Fri, 09 Oct 2009 04:37:05 GMT

Hi,

Check the FM CONVERT_TO_FOREIGN_CURRENCY

Vikranth

Re: Currency Conversion

former_member156446 — Fri, 09 Oct 2009 04:38:52 GMT

CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'
        EXPORTING
          date             = <fs_komv>-kdatu
          foreign_currency = komk-waerk
          local_amount     = wa_komp_o-netwr "zwavwr
          local_currency   = <fs_komv>-waers
*          rate             = <fs_komv>-kkurs
*          type_of_rate     = 'M'
        IMPORTING
          foreign_amount   = <fs_komv>-kwert
        EXCEPTIONS
          no_rate_found    = 1
          overflow         = 2
          no_factors_found = 3
          no_spread_found  = 4
          derived_2_times  = 5
          OTHERS           = 6.

Re: Currency Conversion

Former Member — Fri, 09 Oct 2009 04:39:22 GMT

Hi Vikranth and Sudhaker,

I tried the above two FM's, but if i pass any date, its giving nothing...no output...

Any other option?

Re: Currency Conversion

Former Member — Fri, 09 Oct 2009 04:43:27 GMT

HI,

Check this one CONVERT_AMOUNT_TO_CURRENCY

Re: Currency Conversion

Former Member — Fri, 09 Oct 2009 04:45:17 GMT

This message was moderated.

Re: Currency Conversion

Former Member — Fri, 09 Oct 2009 04:45:24 GMT

which date i hav to pass?

Re: Currency Conversion

kesavadas_thekkillath — Fri, 09 Oct 2009 04:49:49 GMT

link:[http://wiki.sdn.sap.com/wiki/display/Snippets/FMCurrencyConversion]

Re: Currency Conversion

former_member156446 — Fri, 09 Oct 2009 04:51:39 GMT


> which date i hav to pass?

u can use sy-datum

CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY' is used by SAP in pricing for sales Order and invoices etc..

Re: Currency Conversion

Former Member — Fri, 09 Oct 2009 04:51:50 GMT

Hi,

If u want today's rate conversion then pass sy-datum.

Re: Currency Conversion

Former Member — Fri, 09 Oct 2009 04:58:39 GMT

Hi,

I used the FM CONVERT_TO_LOCAL_CURRENCY

This is the input i have passed.

CLIENT 200

DATE 09.10.2009

FOREIGN_AMOUNT 18000

FOREIGN_CURRENCY USD

LOCAL_CURRENCY SAR

RATE 3.75

TYPE_OF_RATE M

READ_TCURR X

Its giving nothing....

even same case for the FM CONVERT_TO_FOREIGN_CURRENCY

Kidly let me knw the solution

Re: Currency Conversion

Former Member — Fri, 09 Oct 2009 05:06:08 GMT

Hi,

Please test the FMs that you are using for currency conversion in SE37. Check if the FM gives the correct value.

Re: Currency Conversion

Former Member — Fri, 09 Oct 2009 05:06:44 GMT

Venkat,

Go to table TCURR and check if there is any data for DATE you entered between these currencies. If data does not exist there than you will not get any output from FM.

Re: Currency Conversion

Former Member — Fri, 09 Oct 2009 05:08:12 GMT

Hi,

Maintain exange rate,

Exchange rates maintain daily are stored in TCURR table in R/3

Re: Currency Conversion

former_member156446 — Fri, 09 Oct 2009 05:10:35 GMT


> even same case for the FM CONVERT_TO_FOREIGN_CURRENCY
> 
> Kidly let me knw the solution

Please try this code:

DATA: lv_kwert TYPE kwert.
CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'
  EXPORTING
    date             = sy-datum
    foreign_currency = 'SAR'  " try changing as per ur req.
    local_amount     = '1800'
    local_currency   = 'SAR'
  IMPORTING
    foreign_amount   = lv_kwert
  EXCEPTIONS
    no_rate_found    = 1
    overflow         = 2
    no_factors_found = 3
    no_spread_found  = 4
    derived_2_times  = 5
    OTHERS           = 6.
WRITE: lv_kwert.

Re: Currency Conversion

Former Member — Fri, 09 Oct 2009 05:14:19 GMT

Sudhaker,

In TCURR table some of the entries found for USD to SAR.

I passes those dates to the FM.

But i m getting below error.

Exception NO_RATE_FOUND

Message ID: SG Message number: 105

Message: Enter rate 1300 / SAR rate type M for 01.01.2005 in the system settings

I m directly running these frm SE37 only

Edited by: venkat on Oct 9, 2009 7:14 AM

Re: Currency Conversion

former_member156446 — Fri, 09 Oct 2009 05:17:09 GMT

Dont try in se37.. some FM's does not work... and work perfect in se38 programs..

Re: Currency Conversion

Former Member — Fri, 09 Oct 2009 05:18:23 GMT

Hi,

I remember facing this problem when I used the FM.

Didnt quite know what the reason was. So concluded that the SAP system currency conversion rates were not in synch with the third party system.

The FM worked only between USD and INR for me.

Probably, the FM right now works only between few currencies.

Not quite sure, but I guess others will pitch in here and help you out.