Skip to Content

BPC Consolidation in SAP S/4 HANA1610

Jan 20, 2017 at 04:04 AM


avatar image

Hello All,

1) We understand that the business rules configuration for the BPC on S/4 HANA real time consolidation is same as the Standard model.
In the standard ,for the intercompany matching functionality model you execute a data manager package which links to icdata.lgf script logic.
What is the process in the real time consolidation now as script logic is no longer available.

2) Would you recommend to use composite infoprovider instead of multiproviders for the BPC data modelling?

3)If Customer wishes to do consolidation on planned data too, then how to get the planned data from Planning real time cube into consolidation real time cube?

10 |10000 characters needed characters left characters exceeded

Hi Roy:

We did setup for IC Booking in Embedded 7.5 Sp05. On execution Credit and debit audit data are generated perfectly.

But the difference is not getting generated in the difference account(ICDIFF01) and Audit(ICDFF). Is there something we are missing or a bug in the program.

Just FYI,

  • We are managing IC booking in same model as consolidation and we do not have separate model called IC Matching
  • ICDIFF01 - Account is out the Income Statement hierarchy which used to capture difference.



* Please Login or Register to Answer, Follow or Comment.

4 Answers

Roy Jin
Jan 26, 2017 at 07:05 AM

Hello Mantri,

1. For IC Matching, it will be automatically executed together with the IC Booking rule in the Consolidation Monitor.

In fact, it will be executed first and the IC Booking will follow that.

2. I will recommend to use composite provider instead of multiprovider.

The composite provider has the similar capability with multiprovider, but it is also optimized for HANA platform. More important thing is, the composite provider supports to include HANA views as the part provider which is not supported by multiprovider. That's why in real time consolidation, the architecture is to use composite provider.

Furthermore, if customer decides to implement BPC consolidation on embedded model first and move to Real Time Consolidation in the future. Using a composite provider at the first will reduce the future migration effort since the reports created on that composite provider can still be reused.

3. It depends on the structure of the planning real time cube.

If in that cube, there's no BPC consolidation required dimensions, such as Audit/Group dimension, then it's not possible to run consolidation based on that structure. You may have to copy the data from your planning cube into the consolidation model with some kind of data transformation.

If in that cube, the BPC consolidation required dimensions are all available. You can run consolidation directly on that cube by create a consolidation model based on that planning cube.

If you want the consolidation result saved in a separate consolidation real time cube, what you can do is:

  • Create a composite provider to include both the planning real time cube and the consolidation real time cube
  • Create a BPC consolidation model based on that composite provider
  • In the modeling UI, choose the consolidation real time cube as the one to store consolidated data

Please let me know if there's any further questions from your side.

Thanks a lot.


Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Roy,

Can you elaborate a bit more about item 3. I'm also interested in RTC and have a similar scenario here, where we need to run the consol for plan data as well. Our plan data's in /ERP/SFIN_R01, potentially moving forward to ACDOCP.

What's the best option? Enhance the foundation view with plan data? Add the plan in the composite provider?




Hello Lucas,

I believe there may be several options to achieve this but it is also difficult to say which is the best option.

Personally I will suggest to including the planning data (can be HANA view based on ACDOCP or a virtual infoprovider linked to your source) in the composite provider.

Because the overall structure is clear and BW will take care of the data read which will be complicated if you have to create your own foundation view.

best regards,



Hi Roy,

Thanks for the feedback, I believe going forward the best option will be enhancing the foundation view as the fields are basically the same between ACDOCs tables.

One addendum is that, ACDOCP at moment does not have the Transaction Type field (Flow) so people looking to consolidate plan in RTC should consider adding this to ACDOCP.


Mantri Krushna Feb 02, 2017 at 11:06 AM

Hello Roy,

Thanks for the detailed answers but still have questions(one has been posted By Gabriel)

Apart from Gabriel question, I have questions around Business rules

A) Business rule intercompany

Is this same as the intercompany functionality in Standard model . We need to create data sources credit1 credit 2 etc and then the rule will automatically post to these accounts?

Can we also configure offset accounts like standard model where the difference in intercompany balance get posted? But how this Business rule be called ? In standard model, we call them from BPC script

B) Cashflow Account Based Business rule
How can these account based Business rules are called in BPC optimized for S/4 HANA?

Thanks in advance

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hello Mantri,

First of all, the BPC in Real Time Consolidation uses the embedded model. But for consolidation, the same consolidation engine is reused between standard model and embedded model. Which means the configuration for the business rules and the behavior are almost the same for standard model and embedded model.

Back to your question, for Intercompany, yes, you still need to create those special audit id (data source) like credit1 and credit2.

To trigger those business rule, one option is to define a task sequence and execute the tasks via consolidation monitor. In BPC embedded model, the consolidation monitor can run all available business rules including Intercompany Booking. (This is different compared with standard model, in which only CT and Elim&Adj rules are enabled in cons monitor.)

This is the same for Account Transformation rule.

best regards,


Neeti Agarwal May 05, 2017 at 02:15 PM

For BPC optimized, SAP has the pre-delivered content but since its only for planning such as cost center, headcount etc., my understanding is that for consolidation we still need to develop modeling (infocubes, infoobjects for flow, scope etc.). Is that correct?

Also if someone is not using the consolidation manager to run consolidations (since most cases have other packages that need to be run during the consolidation process), how do we trigger those with the lack of data manager packages? Should they be run as part of a planning sequence?

Looking for more understanding in this area.

Show 1 Share
10 |10000 characters needed characters left characters exceeded


RTC will involve objects in HANA, BW, S/4 and BPC. Some of those objects are automatically generated and some you find examples, such as the foundation view. But objects like Ownership and BPC modelling you will need to develop yourself.

Check this link:

In RTC, or BPC embedded there are no more data manager packages. Business rules are triggered through the consolidation monitor. You assign the business rules to task sequences and task sequences are triggered in the consolidation monitor.

Another way consolidation rules can be triggered is through planning functions/sequences. In this case you create the planning function/sequences with type "Consolidation Rule", then attach the same to an analysis for office workbook.


lakshmi soudha kompella Jan 25 at 05:55 PM

Hello Every one,

We are creating a planning function for ( Function type Formula )allocation and would like to use Consolidation Monitor task sequence .

This is RTC Consolidation Version 1609.

Any help please .



Show 2 Share
10 |10000 characters needed characters left characters exceeded

It's better to ask a new question then to "answer" in the old!


I re opened a new question..thank you