Loading of Organizational Units from Files in EC-CS and EC-PCA

Purpose

With this process, you can transfer the following master data and hierarchies in files from Enterprise Controlling (EC-CS and EC-PCA) to the consolidation system (SEM-BCS).

Profit center master data

Profit center hierarchies

Profit center groups master data

Combinations of profit centers and companies

Combinations of consolidation business areas and companies

The system creates or updates the consolidation unit hierarchies that you want to use in the consolidation system from this data and the Customizing settings that you implement in the consolidation workbench.

This graphic is explained in the accompanying text.

This process is primarily designed to support customers who want to migrate from the Consolidation component of SAP Enterprise Controlling (EC-CS) to the Business Consolidation component of SAP Strategic Enterprise Management. The procedure in the sender system remains unchanged (see A Download in Sender System ).

You can also load the organizational units into the consolidation system from Enterprise Controlling with load from data stream from SAP NetWeaver Business Intelligence (BI)or a connected SAP source system. For additional information, see Loading of Master Data from Connected SAP Systems .

Prerequisites

In the consolidation workbench, you have made the Customizing settings for the data basis and for the consolidation area in which you want to use the organizational units. You have created a source data basis and specified it in the data basis.

Process Flow

You download the master data and organizational unit hierarchies from Enterprise Controlling in files (see section “A. Download in the Sender System“).

You make the Customizing settings for uploading the files to the consolidation system in the consolidation workbench (see section “B. Customizing in the Consolidation System“).

You then load the files into the consolidation system, using the mapping rules that you have defined in Customizing (see section “C. Upload into the Consolidation System“).

The graphic outlines the data collection.

This graphic is explained in the accompanying text.

A. Download in the Sender System

The downloading procedure varies according to whether you are using profit center consolidation or business area consolidation.

Profit Center Consolidation

For profit center consolidation create the following files in Customizing for Enterprise Controlling

Organizational unit information (PRCTR_COMP.TXT)

This file contains the combinations of profit centers and companies, and also the profit center master data.

Hierarchy information (PRCGR_HIER.TXT)

This file contains the profit center hierarchy, and implicitly the profit center groups master data.

In Customizing for Enterprise Controlling under Consolidation → Integration: Preparation for Consolidation → Preparation in the Sender System → Enterprise Structure → For Profit Center Consolidation → Export Combinations of Profit Centers/Companies to File (or call up transaction CXNA):

Business Area Consolidation

For business area consolidation create the file Organizational Units Information (CONSBUSAREA_COMP.TXT) in Customizing for Enterprise Controlling. This file contains the combinations of consolidation business areas and companies.

In Customizing for Enterprise Controlling, choose Consolidation → Integration: Preparation for Consolidation → Preparation in the Sender System → Enterprise Structure → For Business Area Consolidation → Export Combinations of Companies/Consolidation Business Areas to File (or call up transaction CXNB):

This graphic is explained in the accompanying text.

The file content comes from EC-CS and has to be defined there. Make sure that the following master data has been defined in the sender system, otherwise the file remains empty:

Companies, company codes, business areas and consolidation business areas in Customizing for Enterprise Structure under Definition → Financial Accounting

Assignment of company codes to companies, and also business areas to consolidation business areas in Customizing for Enterprise Structure under Assignment → Financial Accounting

Combinations of consolidation business areas and companies in Customizing for Enterprise Controlling under Consolidation → Integration: Preparation for Consolidation → Preparation in the Sender System → Enterprise Structure → For Business Area Consolidation → Define Combinations of Company Codes/Business Areas

B. Customizing in the Consolidation System (SEM-BCS)

How you transfer the files to the consolidation system depends on your system environment. For example, you might be able to access a network. To upload the files into the consolidation system, use Flexible Upload . You define your customizing settings in the Consolidation Workbench.

In the source data basis, choose the InfoObject catalog delivered 0SEM_BCS_CHA03 as the InfoObject catalog for characteristics.

When you execute the flexible upload, the system initially loads the files to the InfoObjects of the InfoObject catalog. Some attributes are loaded to internal fields. The InfoObjects and internal fields are used in mapping (see below) as source fields that you assign to the target fields in consolidation.

For additional information, see Assigning the Files from EC-CS/EC-PCA .

In the settings for the consolidation area, you select File-based Integration with SAP R/3 and SAP ECC

For each characteristic, and the combinations of consolidation units, create a flexible upload method. For the data types consolidation groups consolidation units and other master data (with the characteristic consolidation unit combination ), the file types that were created when being downloaded in the sender system are available.

Combination profit center/company from ECC (PRCTR_COMP.TXT)

Profit center hierarchy from ECC (PRCGR_HIER.TXT)

Combination PC/company and PC hierarchy from ECC (PRCTR_COMP.TXT and PRCGR_HIER.TXT)

Combination business area/company from ECC (CONSBUSAREA_COMP.TXT)

On the tab page Field Catalog for the upload method assign the source data basis.

On the tab page Mapping of the upload method, assign the InfoObjects of InfoObject catalog 0SEM_BCS_CHA03 used to the characteristics and attributes in the consolidation system. If required, you also assign values to the other attributes in the consolidation system. For more information, see Mapping .

This graphic is explained in the accompanying text.

You can summarize the source hierarchy for the data collection by making the relevant settings in mapping. For additional information, see Aggregating Master Data and Hierarchies for Transfer to SEM-BCS .

Some of the attributes of the characteristics in the consolidation system are set by the system automatically for the data collection (see the section Result ) should you not have assigned values in mapping.

For additional information on Customizing and using the upload methods, see Notes on Downloading Organizational Units from EC-CS/EC-PCA .

C. Upload into the Consolidation System

You upload the master data and hierarchies of the organizational units by executing the upload methods in the consolidation workbench direct.

You can do test runs by executing an upload method but without saving.

Result

You have transferred the master data and organizational unit hierarchies from an SAP source system to the consolidation system.

Default Values for Attributes

The system has set the following attributes for consolidation units that have been newly assigned to a consolidation group (if you have not assigned any other values in mapping):

Year of first consolidation: current year

Period of first consolidation: current period

First consolidation at end of period: blank

Year of divestiture accounting: 9999 as initial value

Period of divestiture accounting: 012 as initial value

First consolidation at beginning of period: blank as initial value