BPC Consolidation with Parallel Currency (Multiple Local Currency from each Entity)

[Former Member]

Dear all,

I want to ask if there is any documentation of SAP BPC with regards of consolidating of several companies which have multiple local currencies?

For example, if company A has two local currency (LC1 and LC2) and it will be consolidated into its consolidation group for each of these currencies.

Should we create two entity dimension members (Entity A_1 with LC1 and Entity A_2 with LC2) for the consolidation in SAP BPC for each consolidation process (consolidation model of LC1 and consolidation model of LC2) or is there any way for an entity member to store multiple local currencies? What is the best practice for this case?

Thanks.

Regards,

Siswono

[GregoireDesombre]

Hello,

I agree: this is a strange scenario to have multiple LC!

How do you calculate then the group currency amounts (GC=LC1*rate + LC2*rate)?

Or is the LC1 (USD) the group currency? And LC2 (SGD) the "real" local currency?

As Rahul said check the currency type in ERP and you will see that only one is LC.

Regards,

Grégoire

[former_member225135]

Hi Siswono,

As per the design of BPC, you can have one local currency for a entity. In case you want to load 2 different currencies data in same entity, you will be required to create 2 entity.

But can you explain, how can 1 single entity have 2 local currency?

Regards,

Rahul

[Former Member]

Hi Rahul,

Thanks for your prompt response.

Actually, it is part of the management consolidation reporting.

Several of their companies have activated the parallel currency in their SAP ECC.

For their group management consolidation, they are required to do management reporting by each of the local currency provided by the parallel currency.

To give a clearer picture:

Group A:

- Company A : LC1 (USD), LC2(SGD)

- Company B : LC1 (USD), LC2(SGD)

- Company C : LC1 (USD), LC2(SGD)

The consolidation would be conducted for both USD and IDR for Group A, to compare the forex of the transaction conducted in SAP ECC. That is the reason we required to load the figures for each of the currency into LC1 and LC2 for each company.

We cannot use the currency translation in SAP BPC for the management consolidation report since the currency used for the consolidation and transaction would be different.

Regards,

Siswono

[former_member225135]

Hi Siswono,

As i said in previous post, it is not possible to maintain multiple currencies for single entity. In your case, you have to create 2 different id for single entity and have to pull data in two different currency. I think you can currency type filter (ECC - 00- document currency, 10- company code currency, 30- group curerncy, etc) while pulling data and then can create a custom logic for translation in BPC

Regards,

Rahul