Exchange rates

[Former Member]

Hi Guruji's,

I am actually working on a report which is calculating total revenue for a compnay. Now they are calculating it in Euro , but they need this currency to be converted to USD only.

If anybody can tell me, from where i can retreive the exchange rate for currnet month, it would be of great help.

I have got some idea, that this is related to fico, and there must be some function modules to do that, please help me out on this.

Regards,

Khan

[former_member188829]

Hi,

Check these Function modules

CALCULATE_EXCHANGE_RATE

COPA_READ_EXCHANGE_RATE

[Mohamed_Mukhtar]

hi ,

Go through these links...

https://www.sdn.sap.com/irj/sdn/profile?editmode=true&userid=3775058

[Former Member]

hiii

use this function module

CURRENCY_CONVERT

CURRENCY_CONVERT_TO_EURO

thanks

[SuhaSaha]

Hello,

Infact you can get the exchange rate for the particular date )

For this use the FM 'CONVERT_TO_LOCAL_CURRENCY'.

Try this:

CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'
  EXPORTING
    DATE                    = SY-DATUM
    FOREIGN_AMOUNT          = 1.00
    FOREIGN_CURRENCY        = 'USD'
    LOCAL_CURRENCY          = 'EUR'
 IMPORTING
   EXCHANGE_RATE           = V_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.

We generally use the table TCURR to get the exchange rate. Plz make sure you know the "Exchange rate type" (KURST),

the exchng rate can be found from field UKURS.

Edited by: Suhas Saha on Aug 11, 2008 9:30 AM

[Former Member]

hii

the table name is T091C and feild is KURST.

thanks