on 08-16-2007 6:14 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.