Entering content frame

Process documentationIntegrated Company or Business Area Consolidation Locate the document in its SAP Library structure

Purpose

This process description explains how you transfer data for a company or business area consolidation from operational SAP applications.

Process Flow

A. Customizing in the Sender System and in the Consolidation System

For the integrated data collection you have to execute the Customizing settings both for the sending of data and for the receiving of data.

With a central scenario the sender and receiver work in the same system and client,; with a decentralized scenario the sender and receiver work in different systems and clients.

Note

All Customizing settings are offered in the IMG of Consolidation, in the section Integration ® Preparation for Consolidation. You will find detailed explanations in the documentation on the individual sections.

The IMG section is divided into preparations which are to be executed in the sender system and preparations which are to be executed in the consolidation system. From the more general case, the IMG assumes that the operational applications work in other systems (at least partly). When you have a central enterprise scenario, then nevertheless you have to execute the IMG section part Preparations in the Sender System and Preparations in the Consolidation System. Only the steps which offer the transfer of Customizing settings between the systems do not apply in a central scenario.

The following graphic shows, in an overview, which settings are to be executed in the IMG. The numbers 1 to 5 set the order of the settings chronologically. As the sender system relies on the Customizing settings of the consolidation system and vice versa, at least a part of the Customizing settings must be organizationally reconciled to each other.

 

This graphic is explained in the accompanying text

  1. The group headquarters sets the global master data in advance:
    2.

    Global characteristics

    Transfer to sender systems

    Companies

    On organizational way or by transport

    Cons business areas

    Group chart of accounts and/or group financial statement version

    (according to data transfer method / scenario; compare Group C/A, Financial Statement Version, Cons C/A

    Cons transaction types

     

    In the IMG section Preparations in the Consolidation System, you will find the tools to create and transport the group chart of accounts and the group financial statement version.

    In addition to that you define which integrated consolidation types are to be displayed in the views.

  2. In the sender system you create the global master data or import them from the consolidation system. You assign the global organizational units to the local ones:
    3.

    Global characteristics

    Local characteristics

    Company

    Company code

    Cons business area

    Business area

     

    For business area consolidations you also enter which business areas the individual company codes manage. The system converts the combinations of company codes and business areas which have been defines by you to the combinations of company codes/business areas. It then exports this into a file. You transfer this file to the consolidation system.

  3. The next steps can run parallel in the sender system and in the consolidation system.

Integrated Cons type

Cons unit’s structure

Cons group’s structure

Company consolidation

from company codes, to which a company is assigned

a top consolidation group

Business area Consolidation

from combinations companies/cons business areas

Hierarchy by cons business areas

Hierarchy by companies

 

Note

For every hierarchy you have to create the top consolidation group manually. This is not integrated, that means that there are no corresponding operational organizational units.

Subsequently you prepare the transfer of data. A prerequisite for this is that you find out from the sender system on the organizational way, which operational charts of accounts are being used.

In addition to that you assign the global characteristics cons transaction type, cons business area (provided that it has not already taken place) and trading partner to the local characteristics, so that the operational data is supplied with that.

Note

The steps for this from the operational applications are compiled in the IMG of Consolidation. A part of the step is cross-consolidation type, that means it is necessary for all consolidation types. There are also steps which are only necessary for business area consolidation.

If required you prepare to manage parallel currencies and evaluations in the operational data.
  1. When you use rollup as a data transfer method, then you export the consolidation system’s Customizing settings to a file and transfer this to the sender system. The sender system requires some of the Customizing settings in order to convert the operational data, so that they can be processed in the consolidation structures.
  2. In the sender system you define per integrated consolidation type, with which data transfer method you want to transfer data to Consolidation. You prepare this method(s) and subsequently activate them.

Caution

Note that from the activation of the data transfer methods Realtime Update and Periodic Extract, the operational data is updated to the consolidation processing ledger and the preparation for consolidation ledger. You have to set up the initial data set before (see B.).

Structure of the Data Initial Set

In the consolidation processing ledger, the preparation for consolidation ledger and the sender ledger for rollup, you set up the initial data set.

See also:

Legacy Data Transfer

Update of Operational Data

The procedure how you transfer data in the consolidation processing ledger, is dependent on the data transfer method.

The system updates the data directly in the consolidation processing ledger.

Note

Note that the realtime update is dependent on the status which the tasks for data collection have in the data monitor of Consolidation. Even when tasks are blocked, documents are updated.

With realtime update, the status of the tasks for the data collection are not updated. When the status is initial, then it does not change with the realtime update. You can block tasks at a suitable time to execute the subsequent tasks.

See also:

Data Transfer Method Realtime Update

The system updates the data in the consolidation processing ledger. There you create a periodic extract on the key date of Consolidation. You transfer these to the consolidation processing ledger.

See also:

Data Transfer Method Periodic Extract

The system updates in the sender ledger for the rollup, for example a variable ledger to a custom table. From there you execute a rollup in the consolidation processing ledger at the key date.

See also:

Data Transfer Method Rollup

Result

In Consolidation the integrated data can be formatted and consolidated.

 

 

 

 Leaving content frame