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 process
is primarily intended for customers who have been using the 
Consolidation
component of SAP Enterprise Controlling
(EC-CS), and now want to migrate to the Business Consolidation
component of SAP Strategic Enterprise Management (SEM-BCS). The procedure in
the sender system remains unchanged (see A Download in Sender System).
You can also load the organizational units from Enterprise Controlling with Load from Data stream from the SAP Business Information Warehouse (SAP BW) or a linked SAP source system into the consolidation system. For addtional 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.
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 Enterprise Controlling Customizing:
· Organizational UnitsInformation (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 ® Checking the Structure for Profit Center Consolidation ® choose Export Combinations of Companies/Profit Center 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 under Consolidation ® Integration: Preparation for Consolidation ® Preparation in the Sender System ® Enterprise Structure ® Checking the Structure for Business Area Consolidation ® choose Export Combinations of Companies/Consolidation Business Areas to File (or call up transaction CXNB):
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 ® Checking the 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 implement Customizing in the consolidation workbench.
...
1. 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 and EC-PCA.
2. In the settings for the consolidation area, you select File-based Integration with SAP R/3 and SAP ECC.
3. 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)
4. On the tab page Field Catalog for the upload method assign the source data basis.
5. 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, assign values to the other attributes in the consolidation system as well. For more information, see Mapping.
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 Loading Organizational Units from EC-CS and 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 period end: blank as initial value
· 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