Controlling Area change in currency

[Former Member]

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?

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Hi Vishal,

Thanks for your reply. So changing currency of controlling area is not advisable so I'll stick to that.

Our just main concern here is that I wanted to modify some reports or edit some reports in GRR3.

For example i wanted to modify Actual/Plan 2 Currency (1SOT-001) which is used in report S_ALR_87013611, to add a Variation column, remove the cost centers under each cost element and add Total sum in the bottom of the report. When I try to modify this specific report I can't find this on GRR5. Is this possible or should I just create a new report painter to be used in cost center report? Or it is more advisable to create a Z report to cater to our needs.

Not only that we intended also to this to other reports for S_ALR_87012993, by modifying specific reports.

Sorry if my explanation isn't clear enough.

[former_member182098 · Accepted solution]

Please try with RPC0 if you want a different currency on the reports.

S_ALR_* reports are standard reports, which cannot be changed. The only change you can do it is create your own layout, but, you cannot add a different column which is not existing in the report.

GRR5 is report painter reports, meaning that you are not satisfied with S_ALR_* report, hence, created these report painter reports. If the current report painter reports are not suffice your requirements, you will have to create new report painter reports.

Regards,

Ravi

[Former Member · Accepted solution]

Hello John,

As Ravi pointed out, you cannot change the S_ALR_* reports. However, the ones you mentioned are report painter reports. You can find the exact report painter report behind the S_ALR* reports by going to Environment-->Technical Information on the selection screen of the report. I have included the screenshot for the S_ALR_87013611.

Then you can copy the standard SAP report and modify it to suit your needs.

I hope you will be able to do this and get what you and your business needs.

Regards,

Vishal.

[Former Member · Accepted solution]

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

[former_member182098]

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.