Skip to Content
0

Consolidation using store entity

Nov 27, 2017 at 07:22 AM

27

avatar image
Former Member

Dear Experts,

I'm bringing up a question from 2016 which I found in the archive:

https://archive.sap.com/discussions/thread/3865663

Basically I want to know if it's possible to setup BPC (without custom logic) to run consolidation with store_entity approach. Consider the following scenario:

Holding company C1000 owns 2 subsidiaries: C1100 and C1200 (both fully owned). Subsidiary company C1200 owns 1 subsidiary: C1210. For this requirement, 2 SCOPE (G dimension) members are created : G1000, G1200

The Ownership hierarchy should look like this:

[-]G1000
-C1000(H)
-C1100
[-]G1200
-C1200(H)
-C1210

I set up SCOPE.STORE_ENTITY = 'Y', SCOPE.ENTITY = 'SE_1200'. Therefore when consolidating G1200, data will be generated into SE_1200 as the store entity.

The expected function is that SE_1200 will be included in the consolidation of G1000 as a single entity, product of consolidation SCOPE G1200.

There are 4 issues in this setup:

1. CURRENCY generated in group currency, not local currency as required by Consolidation Engine
2. SCOPE generated in SCOPE=G1200, not G_NONE (non group)
3. AUDIT_TRAIL includes the elimination audit, while it should just be 'INPUT'
4. INTERCO from C1000/C1100 will be pointing to I_C1200/I_C1210. But during consolidation, it would require the INTERCO to points at I_SE_1200

All the issues above can be resolved using custom logic, but is it the only way? Is this kind consolidation approach supported in BPC or am I missing the purpose of store_entity?

Thank you in advance,

Hendry

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers