Understanding Consolidation of Investment (COI) in SAP S/4HANA Finance for group reporting – Part I

[former_member612862]

Purpose

Purpose of this blogpost is to provide overview on the Consolidation of Investment (COI) in SAP S/4HANA Finance for group reporting solution.

SAP S/4HANA Finance for group reporting supports below approaches for COI

• Rule Based Consolidation


• Activity Based Consolidation (supported from 1909 release)

In this blogpost we shall understand more on the Activity based consolidation - direct share without cross holding scenario 

What will you learn from this blogpost

• Introduction to the concept of Consolidation of investment (COI)


• Different accounting techniques used for consolidation


• Introduction to Activity based consolidation in SAP S/4HANA Finance for group reporting


• Configuration and Fiori activities for COI in SAP S/4HANA Finance for group reporting


• Benefits and Limitation from SAP S/4HANA Finance for group reporting

Introduction

During the consolidation process the Group must eliminate all the transactions that has occurred during the period between different entities within the same group e.g intercompany sales, intercompany purchases etc.

Similarly, the group is also supposed to eliminate any investment between entities within the group i.e Consolidation of Investment (COI)

In the process, a parent company's investments are eliminated against the stockholder’s equity of a subsidiary.

Different Accounting techniques used for Consolidation

There are 2 popular methods of consolidation that are widely used across all industries

1.Purchase method

In this method the Financial statement of the subsidiary is combined with the group. Each line from assets and liabilities are considered and added to the group BS

e.g :  Unit A and Unit B are part of the Group ABC

Unit A is the parent unit investing 70 % in subsidiary Unit B via Purchase method

Below you can see the Financial statements of each unit individually and of group ABC where Unit B is consolidated using Purchase method

2. Equity method

In this method the Financial statement of the subsidiary is NOT combined with the group. Instead changes in subsidiary equity or equity holdings adjustments for the equity-method investee unit result in an adjustment of investment book values in the consolidation of investments. The equity units are not displayed in reporting.

e.g :  Unit A and Unit B are part of the Group ABC

Unit A is the parent unit investing 30 % in subsidiary Unit B via Equity method

Below you can see the Financial statements of each unit individually and of group ABC where Unit B is consolidated using Equity method

Note: Some organization also use Proportionate method of consolidation. We are not covering this method in this blogpost

Introduction to Activity based consolidation in SAP S/4HANA Finance for group reporting

During the time span of the investment relationship between different entities in the group, different activities (events) can occur that require elimination and adjustments in consolidation. The following activities are supported by SAP S/4HANA Finance for group reporting for the consolidation of investments:

Activity Number	Description
01	First consolidation
02	Subsequent consolidation
05	Increase in capitalization
06	Decrease in capitalization
07	Step acquisition
08	Partial transfer
09	Total transfer
10	Partial divestiture
11	Total divestiture
16	Horizontal merger
24	Update of retained earnings merger

 

Consolidation Methods and Scenarios supported by SAP S/4HANA Finance for group reporting

SAP S/4HANA Finance for group reporting supports both direct share method and group share method. Within both these methods it supports with cross holding and without cross holding scenarios

In this blogpost we cover only direct share method without / with cross holding scenario.

Configuration and Fiori activities for COI

1.Configuration settings for COI is part of below SPRO node.

 

 

2.Consolidation task group mapped to the version should be S21. S21 task group has task for Activity based consolidation. You can verify same in below SPRO nodes

 

 

 

 

(NOTE: For examples used in this blogpost we are using standard best practice delivered setting.)

3.Create Consolidation Group. Ensure field for consolidation frequency is updated.

 

4. Create Consolidation units

 

5. Assign consolidation units to Consolidation Group indicating consolidation method, start date of first assignment, period for first consolidation etc

 

Parent Unit e.g

 

Subsidiary with Purchase method e.g

Subsidiary with Equity method e.g

 

Note: SAP gives below options for consolidation methods. In this blog we emphasize more on the direct share options highlighted in green

 

Data specifications to be considered for using COI

1.Supplement below additional detail for COI against investment FS items (171000 for Equity method and 172100 for Purchase method)

1. 
   
   
   
   1. Investee unit (Field from ACDOCU – COICU)
   
   
   2. Activity type (Field from ACDOCU– COIAC)
   
   
   3. Percentage of Investment (Field from ACDOCU – MSL)
   
   
   4. Base Unit as PRC ((Field from ACDOCAU– RUNIT)
   
   
   
   

Below is an example of upload file which contains additional information for COI

Note: For First Consolidation, activity type 01 should be mentioned against the Equity FS item 311000 in the investee unit so that Equity / Share Capital information is also considered for Consolidation

Note: In case of integrated units where investment / equity amounts are flowing from underlying S4 system, you need to only supplement the information for holding % and activity type. This can be done by posting a manual journal entry via Post group journal entry app or also via flat file as well 

Note: It is recommended to use GRDC to upload data into Group reporting.

2. Ensure FS items has correct FS item roles, Break down category to allow % entry, NCI target attribute and all selections are available to support COI related postings.

Below are some of the FS items from standard consolidation chart of account Y1 that are used in all our examples and are relevant for COI



 

Refer to below link from sap help for more details:

https://help.sap.com/viewer/4ebf1502064b406c964b0911adfb3f01/2021.000/en-US/cc8f7d8e0ee14ff7bfad7875...

Example for COI without cross holding

Scenario for period 01 (period 012.2019)

• In group ABC, Unit A is the Parent unit. Unit B & Unit C are subsidiary units


• Unit A has 70 % holding in Unit B via Purchase Method


• Unit A has 30% holding in Unit C via Equity Method


• Since this is first period of consolidation the activity type will be 01- First consolidation


• We cover both Purchase and Equity method of consolidation

Below sample data was used for period 012.2019

Upload above transaction data with activity type, percentage holding and equity details and execute data monitor tasks (in the example we have loaded all the data in EUR hence CT task is not executed)

 

Below is the individual BS for each unit before executing any of the Consolidation tasks. The calculation for net income can be verified against the manual BS screen shot shared above

We proceed to execute tasks in Consolidation monitor to elimination inter unit investments

a) Task 2060 – Preparation Consolidation Group Change

Task log below indicates that since this is the first consolidation the record type A (acquisition) is used.

Refer below link from SAP help for more details on this task

https://help.sap.com/viewer/4ebf1502064b406c964b0911adfb3f01/2020.000/en-US/1cb4def471234e1ab0c039d2...

b) Task 2141 – Calculate Group share %

This task calculates Group share for each Unit. Since this example doesn’t have any cross holding the direct share and group share % is same

Refer below link from SAP help for more details on this task

https://help.sap.com/viewer/4ebf1502064b406c964b0911adfb3f01/2020.000/en-US/79940df720e24c29b1569dda...

c) Task 2101 – Consolidation of Investment (Activity Based)

This task calculates goodwill/ capital reserve & NCI on investment via purchase method and any gain/loss of investment for investment via Equity method.

The task log shows postings that would be made along with the calculations for each subsidiary, each investment method and each activity. Since this is first consolidation there is only 1 activity type i.e First consolidation

Details from log for Investment in Unit B

 

Details from log for investment in Unit C

 

Refer below link from SAP help for more details on this task:

https://help.sap.com/viewer/4ebf1502064b406c964b0911adfb3f01/2020.000/en-US/9453a9b45c1a41f08f16924f...

Each task is updated with the date and time of execution and user can always refer back to task log later for reference

The consolidated Balance sheet for Group ABC for period 12.2019 after First consolidation shows below values

Asset:

Liabilities:

Manual Calculation for consolidated BS

 

Scenario for period 02 (period 001.2020)

1. Subsequent consolidation


2. Step Acquisition

Before loading data in period 01.2020, we executed Balance carry forward to get opening balances for the period.

Trial balance for the sample data used for period 001.2020 and Manual BS as of 001.2020 after considering transaction for period 001.2020 is as below

Upload file had below values for the Step acquisition in Unit C and subsequent acquisition for Unit B

After uploading the data for period 01.2020 and completing all the steps from data monitor, we get below information for Balance sheet for period 001.2020. This can be compared with the manual BS above

We executed Consolidation Monitor for period 001.2020 and below are the logs from different tasks

1) Task 2060 – Preparation for Cons Group Change

2) Task 2141 – Calculate Group Shares % (PL30)

3) Task 2101 – Consolidation of Investment (Activity based)

Details for Unit B

Details of Unit C

Consolidated BS for group ABC as of period 001.2020 is as below

Assets:

Liabilities:

Manual Calculation for consolidated BS as of 001.2020 is as below

Benefits and Limitations of SAP S/4HANA Finance for group reporting 

Benefits

• SAP S/4HANA Finance for group reporting covers most of the types of COI scenarios


• With introduction of activity based consolidation this tool simplifies the approach for consolidation of investment


• With introduction of flat group structure consolidation process for different sub group becomes more flexible. This design is more scalable and provides for organization changes.

Limitations

• SAP S/4HANA Finance for group reporting has Out of the Box solution for Purchase method and Equity method however for Proportionate consolidation a new re-classification has to be created as per customer requirement


• Currently no out of box solution available for change in method of consolidation from Purchase to Equity or vice versa. Could be part of future releases. Please keep checking roadmap for further updates on this point

Final note:

This is not an exhaustive list of scenarios however a small attempt to give some insight on how few different Consolidation of Investment scenarios can be achieved in SAP S/4HANA Finance for group reporting.

In the next part of this blogpost we shall cover Activity Based COI - direct share approach with cross holding scenario.

You can refer below link to understand Consolidation of Investment via Rule based approach

https://help.sap.com/viewer/4ebf1502064b406c964b0911adfb3f01/2021.000/en-US/5ce06895106a463ca073fdda...

Lastly I would like to thank my colleague prasadatmakuri  who persuaded me to write this blogpost and our mentor gayathrikrish  for her valuables inputs and guidance.

 

Part II :

Understanding Consolidation of Investment (COI) in SAP S/4HANA Finance for group reporting – part II

https://blogs.sap.com/2022/03/01/understanding-consolidation-of-investment-coi-in-sap-s-4hana-financ...

 

[PrasadAtmakuri]

Wonderful blog Vinitha.. Thanks for putting efforts to write this up and sharing knowledge..

Looking forward for next blog

 

Thanks & Regards

Prasad

 

[Yuval]

Thanks for sharing, it is clearly presented

What about Sub consolidation? Can you please elaborate on this process in Group Reporting?

Thx

[rahulfico]

Nice and detailed blog Vinitha. Thanks for sharing knowledge.

[gayathrikrish]

Great work Vinitha! This blog will help many of our community members.

Thanks

Gayathri

[former_member385027]

A very good blog Vinitha. I can imagine the efforts it takes to pull out such a blog. Thanks for that.

I can use this blog as a ready reckoner.

Eagerly looking forward for your next blog.

[Ajeet]

Very detailed and well articulated Blog, this would definitely help many colleagues, thanks Vinitha for sharing your knowledge  👍🏻

[1870988]

Excellent, Vinitha!

[krishnaprasad123]

very informative and useful vinitha.. great job

[former_member612862]

Thanks !!!

[former_member612862]

Thanks !!!

[former_member612862]

Thanks ajeetkumar.agarwal !!!

[former_member612862]

Thanks madhusudhantc !!!

[former_member612862]

Thanks gayathrikrish !!!

[former_member612862]

Thanks prasadatmakuri

[former_member612862]

Thanks yuval.danovich .

[former_member612862]

Thanks Rahul

[leticial_locatelli]

Great blog! Thanks for sharing.

[anilkaalla]

Fabolous job! Very well articulated!!

Can you also please provide more insights on using the business case on First and subsequent consolidations?

[RaviYadav]

Grateful for sparing time and efforts to write about a lesser known task of SAP S/4HANA Group Reporting i.e. Consolidation of Investment. This blog will not only help in gaining understanding of C/I, but will provide necessary confidence to explore more scenarios of C/I. Hope you find time soon to write about other scenarios of C/I like capital changes, transfers and divestitures. Thanks a ton Vinitha for writing this blog.

[bpcconsol27]

Thanks for sharing the COI and excellent work.

[bpcconsol27]

Hi all

Schedule Jobs for Consolidation Tasks Fiori app does not have " COI - ABC" task in the app. We are on S4H 2020 FP02. I did not find any information on COI-ABC for any scheduled jobs.

Can you please share any thoughts on this?

Thanks

Venkat

 

 

[vijayabhaskara_gunta]

Wonderful and Very detailed blog indeed. This helped a lot. Thank you for sharing. Also the fields COICU and COIAC are not found in ACDOCA table. Was it a typo for ACDOCU?

[former_member612862]

Thanks for highlighting . Have rectified the same now

[former_member612862]

Thanks

[former_member612862]

Hello Anil,

thanks for your feedback.

Below link can help to understand about first consolidation and subsequent consolidation :

https://help.sap.com/viewer/4ebf1502064b406c964b0911adfb3f01/2021.000/en-US/a9e641f61a4e4839b399c35b...

https://help.sap.com/viewer/4ebf1502064b406c964b0911adfb3f01/2021.000/en-US/34de046ecbb24d14b577c48e...

Regards

Vinitha

 

 

[former_member765009]

Wonderful work! Thank you so much for your great contribution!

Btw, May I ask you a question?

What steps need to be completed in order to have the automatic calculation for "subsequent consolidation" in task C/I 2101. In my case, after the first consolidation, I tried so many times but still could not see the subsequent consolidation when running task 2101.

It would be much appreciated if you could clear this above matter for me.

Thanks a lot!

[former_member765009]

Could you let me know which GR version you are using for the above example? 1909 or 2020

 

Thanks so much!

[srinivasanarayan_s]

Hi Vinitha,

I hadn’t thought about this particular thing you briefed here, and it’d help me in doing so and so. Thanks for the very informative article.

I can imagine the amount of effort you put here and maintaining the quality throughout the process, I really impressed this insightful post.

I Appreciate your blog post, However, when I followed, I have a bit unique experience which I wanted to share with you and for the benefit of other users.

1. I believe, the Partner Unit '999999' to be maintained (if in case not available) which may avoid possible stuck in CT Task and further.
2. Even 1SG Best Practicese content followed, I found that BDC 'Unit of Measure' missing for 171000 which need to be little aware if Quantay not uploaded correctly. But if looked for 172100 the BDC maintained correctly as part of the 1SG pre-configuration.
3.  When used the Foreign Currency, you may end up with little difference in FC, when you re-uploaded the Transaction Data (for any correction) since the 'Calculate Netcome' task performed initially. ( I followed little different approach using the Foreign Currency data hence, it found)
4. And I found that "Calculate Group Share" is optional both in ABC and RB COI in SAP Help portal which thought to mention here.

These are very Tiny experience which I have come across in "GR Cloud (Public) Version 2308".

Again, Thanks for the wonderful post Vinitha.

[sapherm1]

Hello folks,

Quick question base on experience. We about to go live and we have 150 cons units total, however 36 units has been divested last year but we still going to need them on the system for three historical data. I am wondering what would be the best approach to included divested consolidation unit while preparing Manage Group Structure app. We intend to set the first consolidation as JAN/2024. We all know that first consolidation is a required field on the Manager Group Structure  but it cannot be set up after divestiture data, so how do I deal with the 36 divested companies ? 

[Guido_Ehrlacher]

Hello,

due to the fact that the date of 'end of assignment' is not modifiable and directly linked to date of 'divestiture' in Manage Group Structure App a workaround might by to set up another cons.group ("divestitured companies") and assign the 36 divestitured companies. For the purposes of reporting the figures of respectivley including those companies you'll select the additional cons.group in reporting.

[hermannf]

Hello 

Even if  you create a new group to report on divestiture. How are going to mix the divestiture date with the date of first consolidation which is a required field from manage group structure, having in mind that there should be no first consolidation for divested company.

[Guido_Ehrlacher]

Hello,

I'm not aware about the detailed requirements, but the approach would be to use the process in this additional cons.group only for data load. So, date of first time consolidation would be the first period after date of divestiture in the "regular" cons.group and you'll use data monitor tasks to load reporting data only. No processing of CoI for this cons.group. Another approach might be to define date of assignment in the new cons.group - so you can perform the data load - and define the date of first time consolidation far to the future (9998). You have to test those approaches, bu this would be the way of workaround I would think about and test.

[hermannf]

Thank for the reply. The first approach regarding loading data with first consolidation date after divestiture date is literally impossible due to the fact Divestiture date cannot be accepted by the system if it is before first consolidation. In fact, Manage Group structure cannot be set up  since divesture must be perform after first consolidation. However, an interesting  scenario that I think  might work is to set Manage group structure normally as it suppose to with the divestiture date after first consolidation . Since I am doing ABC method I would upload my control date with act type 11 and specify cons unit. I would run Manage Group Change task instead COI.and keep it that way.

Thank 

[Guido_Ehrlacher]

I guess there might be a kind of a missunderstanding about my first proposal. The maintenance of group structure should look like this concerning the divestitured cons.units:

	first time	divestiture
legal cons.group	001.2000	012.2023
additional cons.group (for addditonal reporting of divestitured comp.)	001.2024	999.9999

Would be interested whether your approach will work, because doing ABC, but not running CoI sounds a bit confusing.

BR

[sapherm1]

Hey Ehrlacher,

While I am thinking about it, you might actually have a good point to set a different prior date to first consolidation in regard to divestiture group, so I am just going to pick a month/year in the past that would be prior any divestiture entities that below to the Group. At the end I would run first consolidation twice. Once for divestiture group and another one for additional cons group. It is a little bit of more effort but it would certainly make sense and work fine.

thanks!