Explaining Consolidation Units


After completing this lesson, you will be able to:

  • Explain the consolidation unit concept
  • Describe the impact of preparation ledger
  • Outline time and version dependent attributes
  • Explain the flexible derivation of consolidation units

Consolidation Units

Consolidation Units

A consolidation unit in group reporting is the smallest element in a consolidation group structure that can be used as a basis of complete consolidation. Consolidation units represent legal subsidiaries.

Consolidation Units can be created manually using the Define Consolidation Units app or can be uploaded using the Import Consolidation Master Data app.

Consolidation Unit Settings for Non-Integrated and Integrated Companies


If you create a consolidation unit as an SAP S/4HANA company and select transfer from universal journal, you can still use flexible file upload or data transfer from SAP Group Reporting Data Collection for this consolidation unit.

Consolidation Unit: Time and Version-Dependent Attributes

Time and Version Dependent Attributes – Key Points

  • Consolidation unit attributes can be used as a selection mechanism.

  • Some consolidation unit attributes are time-dependent, others are time and version-dependent. This increases flexibility.

  • Version-dependent attribute values can be shared across versions.

Flexible Derivation of Consolidation Units - Key Points

  • Derivation of consolidation units during an accounting posting is available when the preparation ledger is activated.

  • Derivation of consolidation units means that company and consolidation unit can be a one-to-many relationship:

    • One use case for consolidation unit derivation is that a company code/company can be split into multiple consolidation units to support segment reporting.
    • In this example, the requirement is to perform segment reporting with multiple consolidation units. This is in addition to the segment dimension in group reporting.
  • The consolidation unit derived during the accounting posting is stored in ACDOCA.

How is the Consolidation Unit Information Derived During Accounting Posting?

  • If a company is assigned only to a single consolidation unit, the derivation happens automatically by a SAP delivered substitution rule.

  • If a company is assigned to several consolidation units, customer defined substitution rules are required.

  • Customer-defined substitution rules may incorporate criteria such as segment, profit center, functional area, or combinations of these.

The figure gives a simple example of how to derive a consolidation unit.

  • On the left, 1:1 relationship between company and consolidation unit: derivation of the consolidation unit works according to SAP delivered substitution rule.
  • On the right, 1:n relationship between company and consolidation unit: if one company is assigned to several consolidation units in the same fiscal year/period:
    • the SAP delivered substitution rule will not provide any result.
    • customer defined substitution rules are required to derive the consolidation unit based on some context of the accounting posting (company code, segment, profit center, etc.).

When the Data Release task is executed in SAP S/4HANA Finance for group reporting, data from one company may now end up in different consolidation units, representing certain data slices (for example segments) of the company.

Log in to track your progress & complete quizzes