Using settings to execute Activity-based Consolidation of Investm

Predefined Task 2101 Consolidation of Investment (Activity Based)

Task 2101 Consolidation of Investment (Activity-based) is predefined in the standard SAP system as a task for executing Activity-based Consolidation of Investments (C/I). It includes all activities and accounting techniques.

The figure describes the Predefined Task 2101 Cons. Of Invest (Act.–Based) from the configuration perspective.

If needed, you can define an additional task for consolidation.

As a rule, you only need to define one task for C/I. You might define several tasks when the execution of C/I activities or individual accounting techniques occurs at different times or staff members. Define a subset of available C/I activities and accounting techniques for each task.

In ABC Corporation, one employee will run all the equity method consolidations. As an intermediate consolidation consultant, Anthony will define a separate task for this employee. Anthony will then assign the combination of the Equity Method accounting technique and the activities to be processed. He will also define another task for any other accounting technique.

Assigning Activity-Based Consolidation Task to a Task Group and the Consolidation Monitor

In the Define Task Group configuration step, you can assign tasks to a task group for the Consolidation Monitor.

The figure shows that task group S21 contains the ABC consolidation task and that this task group is assigned to a consolidation version. With the help of these settings the ABC consolidation task can be used in the consolidation monitor.

SAP delivers task group S21, which contains automatic posting task 2101 Cons. Of Investment (Activity-Based).

In the Assign Task Group to Version configuration step, you assign the previously defined task group for the Consolidation Monitor to the Consolidation Version, Start Year, Period Effective, and Period Category.

Executing the Consolidation of Investment Task in the Consolidation Monitor

This figure compares the tasks with the help of which ABC-based versus Rule-based Consolidation of Investments can be executed in the Consolidation Monitor.

Assigning task 2101 Consolidation of Investments (Activity-Based) to the Consolidation Monitor via an appropriate task group triggers activity-based consolidation execution. When reading the investment, the Calculate Group Shares task ignores the data with an initial value for the Consolidation of Investments Activity Type since they are only relevant for Rule-based C/I.

If a consolidation monitor doesn't contain task 2101 but does contain task 2100 Investments/Equity Elimin, the system executes Rule-based consolidation. When reading the investment, the Calculate Group Shares task ignores the data with an unequal value to the initial value for the Consolidation of Investments Activity since they are relevant for the Activity-based C/I only.

Note

It is not possible to use Activity-based and Rule-based Consolidation of Investments within one common consolidation version and therefore both tasks cannot be used in one common Consolidation Monitor within one consolidation version!

Defining Document Types and Assigning them to Tasks for Consolidation of Investments

If you create several Activity-based Consolidation of Investments tasks, you must create one document type per task.

This figure explains where to set up a Document Type for the Consolidation of Investments and where to assign it to the C/I task.

Ensure the document type refers to the Business application6 - Consolidation of Investments. Maintain the number range for this document type version specifically.

Note

The assignments are set up depending on the Consolidation Version, Start Year, and Period eff. - allowing you to assign different versions of different document types to one task. You can also assign different document types for different periods.

Running Consolidation of Investments from the Consolidation Monitor

Consolidation takes place for the period entered in the global parameters. You run the Activity-based C/I task from the Consolidation Monitor for one or more consolidation groups.

If you select a consolidation group in the Global Parameters, the Consolidation Monitor will only display this consolidation group.

If you do not select a consolidation group in the Global Parameters, the Consolidation Monitor will display all consolidation groups.

The figure explains how the Consolidation of Investments task can be run from the Consolidation Monitor depending on the selection of the Consolidation Group in the Global Parameters.

All tasks for a consolidation group must be completed and blocked in the Data Monitor before you can run the 2101 Cons. Of Investment (Act.-Based) task for this group in update mode.

The system posts a document with posting level 30 and the assigned document type for each transaction.

When running the 2101 Consolidation of Investment (Activity-Based) task no additional specifications are necessary for legal compliance. You just need to ensure that you have assigned the FS Item role for the relevant FS items to determine the FS items in the consolidation of investment postings.

Note

When executing the2101 Consolidation of Investments (Activity-Based) task several times, the system recognizes that consolidation of investment entries has already been posted for the consolidation group using the special consolidation of investment document type (3B).

It reverses all documents from the previous run and then posts new ones. This means, that you can repeat the2101 Consolidation of Investments (Activity-Based) task as often as required.

The 2101 Cons. Of Invest. (Act.-Based) task is accomplished by means of entries automatically posted for various activities. The system reads the relevant additional Consolidation of Investment Control Data to process each activity.

When running the2101 Consolidation of Investments (Activity-Based) task, all activities are processed in the default sequence, accounting for your specifications for investee unit activities. If changes in investments or investee equity are entered more than once during the period for which a first consolidation is run, the accumulated amounts for these values are used when executing the 2101 Cons. Of Invest. (Act.-Based) task.

Activity-based Task Log - Example for Consolidation Unit DM00 in Group EUR

Once the processing of the2101 Consolidation Of Investments (Activity-Based) task finishes, a detailed audit trail is displayed in a hierarchical list that you can expand and collapse by consolidation group, consolidation unit, activity, and item.

The list shows the base values for calculation (for example, the book value and ownership percentage), interim results of calculations (for example, the group share and non-controlling interest in equity capital), and the final results (that is, the actual documents posted).

This figure gives an example for a consistency check and additionally shows the Display Settings for Consolidation of Investments.

When you run Check Consistency of Customizing for Consolidation of Investments, the system performs consistency checks on your Consolidation of Investment settings. It also issues error messages if the Activity-based C/I settings are incorrect or after detection of inconsistencies.

In this case you must revise your Consolidation of Investment settings accordingly.

When you run Display Settings for Consolidation of Investments, the system displays all Consolidation of Investment settings in an output list.

Using settings to execute Activity-based Consolidation of Investments in the Consolidation Monitor