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

Currency translation of consolidated result

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jun 18, 2008 at 05:02 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 02:55 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 18, 2008 at 04:05 PM

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

    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.