How can we get exchange rates for the given date range?

[former_member326875]

Hi All,

I had a requirement where I have to fetch a months all daily exchange rate between specific currencies and calculate the average out of it. Can anyone help me with any FM that can give all the exchange rates for the given date range and between given currencies?

[Sandra_Rossi]

I can find many answers in SAP Web site:

get exchange rates for the given date range site:sap.com

[former_member326875 · Accepted solution]

Sorry for updating late. I got the FM for the same where we can pass multiple from currency, multiple to currency, multiple exchange rate types and multiple dates for which we want exchange rates.

It will give all possible and available combination of 'from currency', 'to currency', 'Exchange rate type' for all valid dates in given dates.

The FM is 'FM_EXCHANGERATE_GETDETAILS'.

Closing the thread.

Abhijeet Uttarwar

[RaymondGiuseppi]

It would be easier to read data from TCURC (rate) and TCURF (conversion factors)

You could also use FM VIEW_GET_DATA on the maintenance view V_TCURR passing your selection criteria in DBA_SELLIST table parameter.

NB: Field GDATU is an inverted date (descending <> ascending order, statements such as CONVERT DATE dat1 INTO INVERTED-DATE dat2.)

[RaymondGiuseppi]

Typo corrected, thx

[Dominik_Tylczynski]

Hello nilesh.shah8

Check out the BAPI functions:

• BAPI_EXCHRATE_GETCURRENTRATES
• BAPI_EXCHANGERATE_GETDETAIL

Best regards

Dominik Tylczynski

[former_member326875]

Hi 3a9e4ce873a94034b33dc62b0ce600ee,

BAPI_EXCHRATE_GETCURRENTRATES - can provide multiple output but at input we can only pass single date to it. So can't use for my requirement.

BAPI_EXCHANGERATE_GETDETAIL - This FM also can't take more than one date or date range.

Thanks for the reply.

[RobertVit]

Hi,

mainly it is table tcurr and tcurrf