Question on using the integration rules

[A_Warhonowicz]

Hi,

I have a question about how the integration rules work. According to SAP note 1665088, when the integration rules are activated they change how data on entity level is created in group currency per scope. I read the explanation on the SAP WiKi (https://wiki.scn.sap.com/wiki/display/CPM/How+to+use+BPC+integration+rule) and the table makes sense to me.

However, in the client model I am working in, running the consolidation as a DM package, no data on scope is created by the integration rule. The script behind the package is this

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

CURRENCY = EUR,USD,CZK

RATEENTITY = GLOBAL

TID_RA = %TIME_SET%

OTHER = [SCENARIO = %SCENARIO_SET%]

*ENDRUN_PROGRAM



*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

GROUP = %SCOPE_SET%

TID_RA = %TIME_SET%

RATEENTITY = GLOBAL

OTHER = [SCENARIO = %SCENARIO_SET%]

*ENDRUN_PROGRAM



*RUN_PROGRAM CONSOLIDATION

CATEGORY = %CATEGORY_SET%

GROUP = %SCOPE_SET%

TID_RA = %TIME_SET%

OTHER = [SCENARIO = %SCENARIO_SET%]

*ENDRUN_PROGRAM

So from the note I would expect the middle part to not do anything but the bottom part to create values in group currency on the scope selected when running the consolidation.

When I run the consolidation however, either with the above script or from the consolidation monitor, no data is created / changed on the selected scope. When I change the FX rates, the group currency values on S_NONE change accordingly, but the values on scope do not change (I generated those by running the consolidation without the integration rules).

The integration rules is defined with only the adjustment type set to I on the general tab. The detail tab looks like this

The accounts are all nodes, both flows are nodes and the multiplier I000 is defined like this

The company in question is part of the group with method 10 and 100%.

Does anyone have an idea what I am missing?

Thanks,
Arnold

[former_member186338]

Please correct script text in your post - line breaks are missing!

[former_member186338]

Please provide a step by step sample:

1. Show initial data in LC

1. Run currency conversion for GROUP, show results.

2. Run Consolidation, show results.

[former_member186338]

P.S. Samples for both cases: with and without integration rule

[A_Warhonowicz]

Hi Vadim,

here's an example of what I enter and what the system turns it into.

When I delete the second *RUN_PROGRAM CURR_CONVERSION (the one with the GROUP = ...) I get the same data when the integration rules are switched on and only the EUR data on S_NONE without the integration rules.

Thanks,
Arnold

[former_member186338]

Please, remove the first not group currency conversion (for test)

Then run only ONLY GROUP Currency conversion

Show results in S_NONE and TK12

After it run only Consolidation

Show results in S_NONE and TK12

And repeat with integration rule

[A_Warhonowicz]

corrected ... they were only missing here, not in the script in the system