SAP ABAP IMG Activity SIMG_CFMENUCX01_IT27 (Define Aggregation to Profit Center/Profit Center Group)
Hierarchy
☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ EC-CS (Application Component) Consolidation
     ⤷ FC00 (Package) Cons: General consolidation (cannot be assign.to FC01-FC09)
IMG Activity
ID SIMG_CFMENUCX01_IT27 Define Aggregation to Profit Center/Profit Center Group  
Transaction Code S_PL0_09000421   (empty) 
Created on 20020506    
Customizing Attributes SIMG_CFMENUCX01_IT27   Define Aggregation to Profit Center/Profit Center Group 
Customizing Activity SIMG_CFMENUCX01_IT27   Define Aggregation to Profit Center/Profit Center Group 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name SIMG_CFMENUCX01_IT27    

Use

The integration between Profit Center Accounting (EC-PCA) and Consolidation by default defines consolidation units as combinations of profit centers and companies.

However, customers often want to define integrated consolidation units at a higher level to be able to record this data using rollups. At this kind of aggregated level, each integrated consolidation unit then reflects one of the following:

  • a profit center group
  • the combination of a profit center group and a company
  • a profit center

Requirements

You have already performed the following steps:

  1. You designated a dimension for profit center consolidation and assigned to it the appropriate integrated consolidation type.
  2. You have defined rules for ID combination for the IDs of integrated consolidation untis and groups for profit center consolidation.
  3. In the profit center dimension, you either manually created the consolidation group hierarchy with the appropriate level of detail, or you accomplished this by uploading a file with the consolidation units, consolidation groups, and the hierarchy structure.

    It is a great advantage if the IDs of the consolidation units and groups adhere to the rules for ID combination, although the following general considerations should be taken into account:

    • Depending on the aggregation, the profit center is substituted with either the profit center or the profit center group.
    • The portion derived from the company ID can be removed if the aggregation requires this.
  4. If applicable, you completed the maintenance of the master data for the consolidation units and groups, for example using mass change programs. The consolidation units require a valid local currency, the data transfer method "rollup", and a fiscal year variant for the rollup ledger.

Standard settings

Activities

Tell the system which operational organizational units are logically assigned to their respecctive integrated consolidation unit or group.

  • Integrated Consolidation Units

    Enter a company only if the integrated consolidation unit records this level of detail.

    Profit centers may not be stored if the consolidation unit is aggregated with profit center groups. In the reverse case, if the consolidation unit reflects a profit center, you do not maintain a profit center group. Hence, you either specify a profit center or a profit center group for each consolidation unit.

  • Integrated Consolidation Groups

    Profit centers may not be stored if the consolidation group is aggregated with profit center groups. In the reverse case, if the consolidation group reflects a profit center, you do not maintain a profit center group. Hence, you either specify a profit center or a profit center group for each consolidation group.

Example

The following example explains the individual steps.

Assume that the standard hierarchy of profit centers PC10000 is assigned to controlling area CA01. It has the following structure:

PC10000

__10100

____10110

______101101

______101102

____10120

______101201

______101202

______101203

____10130

______101301

The units 10100, 10110, 10120 and 10130 reflect profit center groups, and 101101, 101102, 101201, 101202, 101203 and 101301 reflect profit centers. Further, controlling area CA01 contains the two company codes CC01 and CC02, to which the companies C01 and C02 have been assigned. Assume that both company codes are assigned to each profit center. The transfer of this hierarchy builds a consolidation unit for each combination of profit center and company. Therefore, the generated hierarchy of consolidation groups in this example contains 12 consolidation units.

To perform management consolidation, a partially simplified itemization should suffice.

  • Company details are not needed for profit centers 101101 and 101102; that is, these profit centers should become consolidation units.
  • The profit centers 101201, 101202 and 101203 should be aggregated to profit center group 10120, which also is recorded as a consolidation unit.
  • Profit centers are to be aggregated to profit center groups, retaining the company details.

The following rules for ID combination are defined for the transfer of the profit center hierarchy to the consolidation group hierarchy:

  • The IDs of the consolidation units are comprised of the prefix U, the ID of the profit center with 6 characters, a dash, and a 3-digit ID for the company.
  • The IDs of the consolidation groups have the prefix G, followed by the ID of the profit center or profit center group.

This results in the following consolidation group hierarchy. Note that after performing the workaround for the contained consolidation units, it is possible to roll up data, for example, from Profit Center Accounting.

PC

TOP-PC

__G10100

____G10110

______U101101

______U101102

____U10120

____G10130

______U10130-C01

______U10130-C02

Further notes

In general, since these aggregated and integrated consolidation units do not correspond to the combination of profit centers and companies, this step cannot be used by the program, as delivered, for subsequent integration (transaction CXNT).

See also the corresponding step in the sender system: Define Aggregation of Profit Centers to Profit Center Groups

Business Attributes
ASAP Roadmap ID 254   Transfer Data 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 2   Non-critical 
Country-Dependency A   Valid for all countries 
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG SIMG_CFMENUCX01_IT27 0 HLA0100204 Data Collection from R/3 Systems 
Maintenance Objects
Maintenance object type C   Customizing Object 
Assigned objects
Customizing Object Object Type Transaction Code Sub-object Do not Summarize Skip Subset Dialog Box Description for multiple selections
CXN013 T - Individual transaction object CXN013 Define Consolidation Unit 
CXN023 T - Individual transaction object CXN023 Define Consolidation Group 
History
Last changed by/on SAP  20020508 
SAP Release Created in 470