Managing Subitems and Breakdown Categories


After completing this lesson, you will be able to:

  • Maintain subitems
  • Maintain breakdown categories

Configuring Subitems

Subitem Categories

At ABC Corporation, you're going to add to the delivered subitems to support reporting requirements. Before we create the new subitems, let's review a key points.

You may recall that there are two delivered categories of subitems:

  1. Transaction Types: Relevant for balance sheet accounts and includes opening balance, incoming units, and net variation
  2. Functional areas: Relevant for income statement accounts and includes sales revenue, marketing, and consulting

Keep in mind the following:

  • Subitem and subitem categories help to describe data for FS items.
  • Subitem category and subitem are assigned to the relevant FS items via breakdown categories.
  • Subitems and subitem categories are independent of the consolidation chart of accounts.

To maintain subitems, to the Define Subitem Categories and Subitems activity in customizing.

The settings for subitem category 1 include carryforward to subitem, carryforward to deviating subitem, and subitems for acquisitions/divestitures
  • Carryforward to Subitem: If you set this indicator, you can enter a separate subitem (a transaction type) for carrying forward balances.
  • Carryforward to Deviating Subitem: If you select this option, then you can enter a different subitem for carrying forward balances from the source version to the destination version. You enter this deviating subitem on the details page of a subitem in this subitem category.
  • Subitems for Acquisitions and Divestitures: If you set this indicator, you can enter a retirement subitem (transaction type) for the subitems.

Customers can use fields other than functional area. For example, cost center could be used as an alternative subitem. In this example, subitem category 3 could be created.

Transaction Types

Create a New Transaction Type

At ABC Corporation, you need a new transaction type for a dividend adjustment that will be used in manual group journals:

When creating a new subitem, you maintain field values (listed below)
  • Carryforward Subitem: When balance carryforward is run, values for this transaction type will be written to 900.
  • Deviating carryforward Subitem: Input the subitem where the current subitem's balances are transferred.

  • Subitem for retirements/divestitures: Which transaction type is posted during a divestiture or retirement.
  • Acquisition subitem: The prepare for cons group change task uses this subitem to specify how much of the movement was due to the acquisition vs. ongoing operations.
  • No Posting / Entry: Subitem blocked against manual postings.
Transaction type 900 is reserved for the balance carryforward task. It can’t be updated via data collection unless the import is during the period of first acquisition for the consolidation unit. In the delivered content, 900 is blocked for postings. Transaction type 900 can be unblocked if needed for start up scenarios.

Consolidation Transaction Types - Key Points

  • For group reporting, the correct term is: Consolidation Transaction Type (field RMVCT).

  • Consolidation Transaction Types are only relevant for balance sheet items.

  • In SAP S/4HANA, fixed assets have their own asset transaction types such as 100 External Acquisition. Asset transaction types are mapped (on a many-to-one basis) to consolidation transaction types such as 120 Acquisitions (table V_TABW).

  • There are separate FS Items for acquisition costs and accumulated depreciation. After balance carryforward, acquisition costs and accumulated depreciation values reside in consolidation transaction type 900 (opening balance).

  • SAP S/4HANA Finance consolidation transaction types (transaction code oc08 | table V_T856) can also exist in group reporting (transaction code CX1S4 | table TF115).

  • Group reporting can have consolidation transaction types that don’t exist in SAP S/4HANA Finance. For example, there are ownership and currency (980) related consolidation transaction types that are unique to group reporting.
  • In group reports, both consolidation transaction type and subitem are available to report on.

Functional Areas

A functional area is an element in an organizational structure that classifies expenses based on the functions performed by the employees. Typical functional areas are Sales, Production, Marketing, Administration, Other Gains, and Research and Development.

At ABC Corporation, you need a new functional area for Other Losses. This new subitem will be used in manual group journals.

When Creating a New Functional Area, enter the ID and description

Default Subitems

Breakdown categories can require Partner Unit and Subitem. If the source records are blank, then default values are used. In the Define Default Values for Subassignments configuration activity, you record the default values. The SAP standard system contains preset default values for the following subitems:

The default partner unit is 999999 and the default subitem is transaction 915 and functional area yb99

As a result:

  • If a Partner Unit isn’t provided from the source data, the 999999 default value will be used automatically.
  • If Transaction Type isn’t provided from the source data, the 915 default value will be used.
  • If Functional Area isn't provided from the source data, the YB99 default value will be used.

Create a Subitem

Business Scenario

At ABC Corporation, you’re restating your results for an accounting change. When you run balance carryforward next year, you want the restated values to be isolated in a unique subitem. You need to create a new subitem for this purpose.

What skills will you develop in this practice exercise?

  • Confirm that carry forward to a deviating subitem is enabled
  • Create a new subitem for category 1

Configuring Breakdown Categories

Breakdown Category - in General

Breakdown categories control subassignments that are needed for FS items to perform consolidation tasks.

Breakdown Categories - Key Points

  • Breakdown categories (BDC) are chart-dependent.

  • Breakdown categories are assigned to FS Items.

  • The assignment to FS Items is version-independent and time-independent.

  • Sample BDCs:

    • Cash FS item 111100 has BDC 1B00, which requires consolidation transaction type as a subitem.

    • Sale of Goods FS item 411100 has BDC 2B10 which requires functional area as a subitem.

    • Investments in subsidiaries FS item 172100 has BDC 1D20, which requires both consolidation transaction type and partner unit as subassignments.

Breakdown Category Data Flow

For each FS item, the breakdown category controls which subassignments are recorded into the ACDOCU table. If the source records don't contain a required consolidation transaction type, then it will be derived if the breakdown category allows it.

In the following example, consolidation transaction type is blank in the ACDOCA table. As the data goes through the release process, the breakdown category is used along with the default values to fill ACDOCU with subitem category 1 and subitem 915 (variation).

When data in acdoca without transaction type is released to acdocu, subitem 915 is derived based on the fs item's breakdown category

Breakdown Category Scenario

At ABC Corporation, you need to create a new breakdown category because of a change in how the accounts receivable FS item is used. FS item 121100 was intended to include both internal and external accounts receivable, but going forward, it will only be used for external transactions. Currently, FS item 121100 uses a breakdown category where partner unit is optional. Therefore, you need a new breakdown category that requires partner unit.

You can maintain breakdown categories in the Display Breakdown Categories app.

Use the Breakdown Category App to Display Breakdown Categories such as 1e00

SAP Fiori is the tool of choice to maintain breakdown categories. But you can also use the transaction code CX1i4. In the following image, you can see that Partner Unit is required.

Create a New Breakdown Category

The New Breakdown Category has a breakdown type for partner unit of 2 (Required breakdown: If blank, the default value is used)

Use the Consistency button to check if existing data records are consistent with the current breakdown categories.

Field Definitions: Characteristics

  • Period of Acq.: Used to determine historical exchange rates by feeding the date from the G/L posting.
  • Partner Unit: The trading partner in an inter-company transaction.

  • Trans.currency: Transaction currency can be used to separate the true vs. exchange rate difference for intercompany transactions.

  • Unit of Measure: Relevant for quantity data.

  • Subitem Category: Transaction type (1) or functional area (2).

  • Subitem: Consolidation transaction type value or functional area value.

  • Acquis. Year: Used to determine historical exchange rates based on the date from the general ledger posting.

Each breakdown category refers to one chart of accounts, version, and period.

Breakdown Types - Definitions

  • Blank: The associated items can't be sub-classified by the subassignment. Same as type 0.

  • 0 No breakdown: The associated items can’t be sub-classified by the subassignment. Same as the blank type.

  • 1 Optional breakdown: Initialized value allowed: The related items can be sub-classified by the subassignment or it can be left blank.

  • 2 Required breakdown: If blank, the default value is used: The default value is automatically used if the field is blank in the source data.

  • 3 Required breakdown: Entry is forced, default allowed: The associated items must be sub-classified by the subassignment, and the default value can be used.

  • 4 Required breakdown: Entry is forced, default not allowed: The associated items must be sub-classified by the subassignment, the default value can’t be used.

Max Selection is used to control possible subitem values that are can be used. In the following example, the Z-BC-TT-02 selection object allows subitems 900 to 903, 909, 915, and so forth. But it doesn’t allow the use of 904, 906, and others.

The Max Selection for Breakdown Category 1b00 contains allowed subitems

Assignments to FS Items

In the following image, you can see that different FS items can have different breakdown categories.

In the define financial statement items app, you can view the Breakdown Category by FS item

If you change the breakdown category for an FS item, you’ll receive the following message: Changing the breakdown category of the FS item can lead to inconsistencies in the transactional data that was in the system before the change. Such inconsistencies can lead to problems when processing subsequent tasks, for example, when inconsistent source data is inherited in the target data of an automatic task, such as currency translation or reclassification. Processing the task then leads to an error message when trying to write such inconsistent data to the database.

If you change the breakdown category, run the Check and Correct Breakdowns of Transaction Data app afterwards.

Changing Breakdown Categories

Change a Breakdown Category

At ABC Corporation, you just received a request to change a breakdown category. You need to make the Partner Unit required in breakdown category 1o10. In the following image, you can see that the change is made but it'sn't saved yet.

In breakdown category, Change Partner Unit to Required instead of optional

When the breakdown category is saved, a consistency check prompt appears.

Run the Consistency Check for version u00 and 2022. Choose execute to run the realignment

When you run the consistency check, they system identifies the number of records in group reporting that will be changed if you choose Save.

In the resulting log, the statistics tab displays the number of affected data records

In the Subassignments tab, the affected FS items can be displayed.

n the resulting log, the subassignments tab displays the list of affected data records

Breakdown Category: Consistency Check

You should check if existing transaction data is consistent whenever you change the breakdown category assignments to FS items. Use the Check and Correct Breakdowns of Transaction Data app displayed in the following image, to perform the check.

After specifying criteria, such as consolidation chart of accounts and fiscal year, choose Execute. The list of inconsistent data records is displayed. Go to the Subassignments tab to enter the missing values. Or, if the breakdown type was changed to allow default values, the default values in configuration are used.

In the check/correct breakdowns of transaction data app, you can confirm that the data was checked and consistent

Configure a Breakdown Category

Business Scenario

At ABC Corporation, you need to make partner unit required for certain FS items. You don't want to change any existing breakdown categories. You need to create a new breakdown category that mandates partner unit.

What skills will you develop in this practice exercise?

In this exercise, you’ll enhance your customizing skills by creating a new breakdown category.

Log in to track your progress & complete quizzes