cancel
Showing results for 
Search instead for 
Did you mean: 

Currency translation of consolidated result

Former Member
0 Kudos

Hello,

In my recent practice Customers quite often want to perform currency translation of consolidated figures from GC to so called "Presentation currency"

I kown that the standard approach is:

- change GC in global parameters

- if needed, copy PL 00-10 to the new GC

- redo consolidations for all other posting levels.

Customers are usually not happy with this as they have to do a lot of additional work, for exapmple do manual postings of 20, 30 PL in the new GC.

I want to ask SDM members if they also encounter such requests and, if so, what are the ways to resolve the issue.

I usually do the following:

1. Upload consolidated data from Virtual ICube to Basic(2) ICube (consolidation logic is applied)

2. Upload by dadastream data from Basic(2) ICube into a different version andd different GC into Cons Cube

During the upload I perform some transformations:

- GC -> LC (GC is set to 0 for future CT)

- All companies are replaced by 1 company which represents Group (we can have severeal Groups and thus several "representatives")

- PL is set to 00 (automatic by loading)

3. Run currency translation for the representative company (restriction: it's impossible to use historical rates from ODSs of investments and Equity)

4. Cons monitor of this different version consists of few tasks: Upload, Translate, Validate

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Let me summarize the data flow in your workaround:

Local currency figures -> full cycle of consolidation/eliminations -> group currency ->

consolidated figures (GC) are pretended to be LC again, all of them as figures of one consolidated unit ->

Currency translation from a new LC to presentation currency -> no eliminations (no other data transformation at all).

It looks for me that the other way of getting reports in a presentation currency might be simply a BEx-report with translating figures from GC to PC on the fly. Think it will be rather accurate, because all nuances were accounted for already in GC.

Former Member
0 Kudos

1) Using multilpe GC is the standard way. In this case the customer has to redo all consolidations for the second GC, but he just wants to translate consolidated result for the entire Group into another currency without any addinional consolidations

2) Using on-the fly translation in BEx, I can't get CTR accounts (or CTR movement types fo FA) filled which is achieved by BCS currency translation

Former Member
0 Kudos

If you use the multicube scenario, I would load the data via virtual in basic cube with during this loading the translation (via some abap coding) from GC euro to GC dollars (for example). Be aware that the versioning must be different so you can select separately euro's or dollars. BW is also able to do currency translation.

dan_sullivan
Active Contributor
0 Kudos

I agree with Bobby. That is the purpose of providing for multiple group currencies.

Former Member
0 Kudos

Can't the use of multiple group currencies fullfill your needs?