cancel
Showing results for 
Search instead for 
Did you mean: 

Net Value Currency

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (4)

Answers (4)

Former Member
0 Kudos

Sorted it.

Former Member
0 Kudos

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

Former Member
0 Kudos

You can use the FM "COVERT_TO_LOCAL_CURRENCY" at transformations level in order to convert to local currency.

Former Member
0 Kudos

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