Skip to Content
author's profile photo Former Member
Former Member

Controlling Area change in currency

hi guys,

I just wanted to know what is the effect of changing the currency of controlling area.

Currently the controlling area currency is USD because of its stability however, the past few months BRL currency is now showing progress and we want to make all the reports available in BRL currency.

However, I'm not sure what would be the impact of changing the currency. Can you provide what are the pros and cons?

The purpose of this change is for reporting purpose only to make the report available in both currency BRL and USD. Specifically for this report S_ALR_87013558 . Can you provide an advise for this?

Aside from that we want also to modify in the report painter in GRR3 report 1SOT-001 Actual/Plan 2 Currencies, we want to add columns for this report and modify the display to display only the cost elements not all cost centers. Is it possible to change the report painter and add our desired columns?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 24, 2012 at 10:14 PM

    Hi John,

    Is BRL your company code currency? I believe yes.

    Usually the CO currency follows the group currency in FI. This is because the management is usually at the group level. If this is your case, then it is not really advisable to change the CO currency.

    As far as reporting, if the transactions are recorded in BRL, you will get them in GRR3 and other reports.

    My reply might not be very straight. If you can give some more details on your org.structure and the related currencies, then probably we all can help.

    Regards,

    Vishal.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi John,

      1) Modifying reports

      It is indeed (as mentioned by the other colelagues) advisable to copy the standard report as a Z-report rather than make changes to the SAP report (this way you avoid the danger of your changes being overwritten after an upgrade for example).

      Transaction GRR5 is actually the transaction for creating/maintaining row and column models for use within Report Painter reports. Here you can define a number of rows (or columns) which you store as a model. In the Report Painter definition you can then insert this row/column model. I find it particularly useful for columns if I am defining several reports using the same column structure - e.g Act.Cost / Plan Cost / Variance / Variance %.Instead of having to define each of these columns in every report I can do this in GRR% and save these columns as a column model and then insert this column model into the reports.

      So you can create a report from GRR5 by hitting the 'Create report' button and then entering the library and the new name of the report (add, for example, 1SOT-001 as the reference report to copy it).

      However you can also use the transaction GRR2 (for maintaining Report Painter reports). Here all Report Painter reports are listed. Now you just need to expand the node for the library (eg 1VK), mark the standard report (eg 1SOT-001), hit the 'Copy' button and then enter a name for the new report in the 'To Report' field.

      2) Controlling area currency.

      I can also recommend the use of transaction RPC0 to determine which currency is to be displayed in the report for reports using only one currency (such as 1SIP-001). If you want to compare Controlling are acurrency with Object currency then this is better defined in the report itself, as in report 1SOT-001.

      An additional point to mention is that RPC0 is the transaction for a user to change his own settings. You can also use the transaction RPCN to set the parameters for several users at once.

      Regards,

      Thomas

  • Posted on Apr 25, 2012 at 10:07 AM

    I do not think you need to change the controlling are currency, which is definitely not advisable and possible in all cases. If tomorrow currency XYZ is progressing well and you want to see the reports in that currency??? Then there will be no end to your requirements.

    See if you can use of RPC0 transaction code and give the reporting currency on the "Report Currency" Tab.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.