Skip to Content
avatar image
Former Member

EXCHANGE RATES.

Hi

1) In my R/3 we are maintaining daily in V_Tcurr. I transferred all the exchange rates in my BW. Now i hav to calculate the average Exchange rate for month. How to do that?

2) After calculating average rate that has to be apply my Key Figures.How to do That?

Appreciate for your time.

points will surely awarded for the write answer.

Thanks,

Sony

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 20, 2008 at 11:28 AM

    Use Exchange rate type AS02 for monthly average.

    You can define you currency conversion type in

    RRC1 (BW 3.X)

    or RSCUR in BI 7

    Further info :http://help.sap.com/saphelp_nw04s/helpdata/en/80/1a6806e07211d2acb80000e829fbfe/content.htm

    http://help.sap.com/saphelp_nw04s/helpdata/en/ec/076f3b6c980c3be10000000a11402f/frameset.htm

    Hope this helps.

    Edited by: Praveen G on Oct 20, 2008 7:30 AM

    Add comment
    10|10000 characters needed characters exceeded

    • Use the function module for date you can give the date on the basis of which you need to get the average month rate.

      In Type of rate give AS02 and just execute.

      Check if you get the exchange rate.

      Let know if you get any exceptions.

      Hope this helps.

  • avatar image
    Former Member
    Oct 20, 2008 at 11:28 AM

    Hi Sony,

    Check out transaction RSCUR where you can create various currency translations. E.g. you can create a translation for the M cur. based on the month from the data record.

    Else search the forums for threads about currency translation / conversion. It has been discussed several times.

    Hope it helps.

    BR

    Stefan

    Add comment
    10|10000 characters needed characters exceeded