Skip to Content
avatar image
Former Member

Average Quarterly MB Exchange rate

Hi,

I have to create a report on sales cube which apart from data in local currency should also calculated Average Quarterly MB exchange rate and then use this Average Quarterly MB exchange rate to convert in USD.

Average Quartely Exchange rate is not stored in any table instead MB exchange rates are stored in TCURR table.

THis report will basically show the impact of Exchange rate on billing.

Let me know which is the best way to develop such report which is less hard runtime of report.

Thanks and Regards,

Naveen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Aug 20, 2007 at 02:39 AM

    Hi Naveen,

    If you want to calculate the exchange rate at report run time:

    1) Write an user exit (ABAP code) and calculate and update a row in the TCURR table.

    2) In your report always use the specific entry from TCURR.

    3) The mechanism is to calculate the exchange rate and populate before the report execution.

    Good luck, BB

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear BB,

      We are not very sure of using UserExit to fill a standard table, is it possible to create a Data Target based on Currency table which then we can use using Multicube.

      Thanks

  • avatar image
    Former Member
    Aug 20, 2007 at 04:30 AM

    Hello Naveen

    Create a currency translation type in RRC2 ( RSCURS in BI 7).

    Select the source and target currency and the exchange rate.

    Now in the query designer, KF property select the newly created translation type, you will be getting the currency conversion based on this translation type in the result.

    Thanks

    Tripple k

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Triple K,

      Exchange rate is not stored in table and hence cant use Currency Conversion factor that you are mentioning