on 04-21-2011 2:28 PM
Hi All,
I am getting the net value(0NET_VALUE) from sales data which does not hold a local currency. The requirement is projects with multiple currency i.e.($, EUR) need to be displayed in object currency £ while they are posted in the a aforesaid currencies.
The data gets reconciled but the currency sign is still $ & EUR any way to show the right currency sign.
Kind Regards
James
Hi,
There are two ways for your need:
1. Convert your currency fields in transformation, update rules, transfer rules with using routine. For to do so, you can find a function to convert your currency field as JB mentioned.
2.Conversion can be done in query. To to so, you can examine this article:
http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/2056ef93-2004-2d10-21ae-f973bb48d7a1
--
I can suggest second way.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorted it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, i agree with Huseyin Akturk on currency conversion at report level only if you want to have the currency conversion based on the something like current cal day irrespective of when the records with document dates were loaded .
If that is the case, using the conversion at query level is the best option or else if you want the conversion based on the loading document date at the time of load,then do it at transformations level.
This totally depends on your business requirement,
Regards,
JB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can use the FM "COVERT_TO_LOCAL_CURRENCY" at transformations level in order to convert to local currency.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
You can use the currency conversion option in the Query designer to convert it to local currency .
If you have the option of loading the data, you can use currency conversion at the transformation level also .
But your currency tables tcurr,tcurc must be properly updated with ECC.
Hope the above reply was helpful.
Thanks & Regards,
Ashutosh Singh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.