HELP IN CURRENECY

[Former Member]

hI

I WANT TO USE FM

CONVERT_TO_FOREIGN_CURRENCY

TO CALCULATE THE RATE OF DOLLAR COMPARE TO IL'S

THE PROBLEM THAT I WANT TO KNOW THE AVERAGE RATE ACCORDING TO MONTH

FOR EXAMPLE I WANT TO KNOW WHAT IS THE AVERAGE RATE BETWEEN 01012007 TO 01032007 AND I DON'T WANT TO CALL 60 TIMES TO FM

CONVERT_TO_FOREIGN_CURRENCY

MAYBE SOMEONE KNOW OTHER FM?

THANKS

HAVE NICE DAY

[Former Member]

Hi,

Check the following link:

http://www.sapbrain.com

Regards,

Bhaskar

[Former Member]

Try something like this..

REPORT  YCHATEST.

TABLES : TCURR.

DATA : V_UKURS LIKE TCURR-UKURS.

DATA : L_DATE1 LIKE SY-DATUM VALUE '20070301',
       L_DATE2  LIKE SY-DATUM VALUE '20070331',
L_FIRST(8),
L_LAST(8).

CONVERT DATE L_DATE1 INTO INVERTED-DATE L_FIRST.
CONVERT DATE L_DATE2 INTO INVERTED-DATE L_LAST.

SELECT AVG( UKURS ) FROM TCURR INTO V_UKURS
 WHERE GDATU GE L_FIRST AND GDATU LE L_LAST.


WRITE : V_UKURS.

[Former Member]

hi

use the following function module

<b>CALL FUNCTION 'BAPI_EXCHANGERATE_GETDETAIL'

EXPORTING

RATE_TYPE = 'M'

FROM_CURR = FROM_CURR

TO_CURRNCY = TO_CURR

DATE = SY-DATUM

IMPORTING

EXCH_RATE = ST_XCHGRATE

RETURN = ST_RETURN.</b>

regards

ravish

<b>plz reward if helpful</b>