on 10-20-2008 12:24 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Go thru these links :
http://help.sap.com/saphelp_nw04s/helpdata/en/80/1a682de07211d2acb80000e829fbfe/frameset.htm
http://help.sap.com/saphelp_nw04s/helpdata/en/71/f7843b49f6a40de10000000a11402f/frameset.htm
http://help.sap.com/saphelp_nw04s/helpdata/en/08/81b98b95e911d4b2ca0050da4c74dc/content.htm
Click on the links in this blog you will get info.
Hope this helps.
Edited by: Praveen G on Oct 20, 2008 7:41 AM
Hi Sony,
The solution that Praveen provided is to use a function module for the currency conversion in the update rules/transformations. You change these from the AWB and not the transaction I provided above.
"Normal" currency translations in transaction RSCUR is only used for currency translation at runtime.
If you need the KF with the translated currency in your infocube you should do this as Praveen proposed.
Hope it helps.
BR
Stefan
Hi,
How to use this Function module in my transformations.Is this function module will calculate the average rate.
If not how to calculate the average rate for the month.I'm getting daily exchange rates in my table.
I'm new for this.Could you people explain step by step how to do this.
Thanks,
Sony
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
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.