Average Quarterly MB Exchange rate

[Former Member]

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

[Former Member]

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

[Former Member]

Dear Triple K,

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

[Former Member]

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

[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