Loading of FI-SL Rollup Files

Purpose

You use this process to transfer rollup files from the Special Purpose Ledger (FI-SL) component to the SAP SEM Business Consolidation (SEM-BCS) component.

Note Note

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.

End of the note.

You can use rollups for the following integrated types of consolidation:

  • Company consolidation

  • Business area consolidation

  • Profit center consolidation

The figure below illustrates a decentralized scenario in which one or more operational SAP systems (sender systems) export FI‑SL rollup files to the consolidation system. But first, the sender systems import the relevant customizing settings from the consolidation system.

Prerequisites

The sender system runs SAP R/3 Release 4.6A or later.

Prerequisites in the Sender System

In the sender system, you have performed the preparations for consolidation in Customizing for Enterprise Controlling at Start of the navigation path Consolidation Next navigation step Integration:Preparation for Consolidation Next navigation step Preparations in the Sender System End of the navigation path .

You have defined the subitem categoriesin Customizing for Enterprise Controlling at Start of the navigation path Consolidation Next navigation step Master Data Next navigation step Financial Statement Items Next navigation step Subassignments Next navigation step Define Subitem Categories and Subitems End of the navigation path .

You have made the following definitions and assignments in Customizing for Enterprise Controlling at Start of the navigation path Consolidation Next navigation step Integration: Preparation for Consolidation Next navigation step Preparations in the Consolidation System End of the navigation path :

  • Assignments of integrated consolidation types to dimensionsat Start of the navigation path Preparations in the Consolidation System Next navigation step Assign Integrated Consolidation Types to the Dimensions End of the navigation path

  • Rules for ID combinations for each consolidation type and consolidation unitat Start of the navigation path Preparations in the Consolidation System Next navigation step Copy Organizational Units Next navigation step Define ID Combination Rules End of the navigation path

  • Values of independent characteristics for each integrated consolidation typeat Start of the navigation path Preparations in the Consolidation System Next navigation step Collection of Data Next navigation step Define Data Streams End of the navigation path

  • Mapping of transaction charts of accounts and consolidation charts of accountsat Start of the navigation path Preparations in the Consolidation System Next navigation step Collection of Data Next navigation step Assign Transaction Charts of Accts to Cons Charts of Accts End of the navigation path

  • Mapping of secondary cost elements to financial statement itemsat Start of the navigation path Preparations in the Consolidation System Next navigation step Collection of Data Next navigation step For Profit Center Cons: Cost Elements Assignment Next navigation step Allocate Cost Element Ranges to FS Items End of the navigation path

Prerequisites in the Consolidation System (SEM-BCS)

In the consolidation workbench, you have made the customizing settings for the data basis and the consolidation area where you want to employ rollups. You have created a source data basis and specified it in the data basis.

The master data and the hierarchies of organizational units are current.

Process Flow

In the consolidation workbench, you define a method for the flexible upload of FI‑SL rollup files. Then you export the customizing settings to a data file. See “A. Preparations in the Consolidation System (SEM-BCS).”

In the sender systems, you import the customizing settings from the data file and create the FI-SL rollup files. See “B. Activities in the Sender System.”

You load the FI-SL rollup files into the consolidation system by running the upload method for each FI‑SL rollup file. See “C. Execution in the Consolidation System (SEM-BCS).”

A. Preparations in the Consolidation System (SEM-BCS)

You use the flexible upload data transfer method to upload an FI‑SL rollup file into the consolidation system and to export the customizing settings. You define your customizing settings in the consolidation workbench.

  1. In the source data basis, you choose the delivered InfoObject catalog 0ECCS_CHA01 for the characteristics, and the delivered InfoObject catalog 0ECCS_KYF01 for the key figures.

    When you execute the flexible upload, the system initially loads the FI‑SL rollup file into the external field catalog. The assignments of the fields in the file to the InfoObjects in the field catalog are fixed. The InfoObjects are used in mapping as the source fields, which you assign to the target fields in consolidation.

    For more information, see Assignment of FI-SL Rollup Files in SEM-BCS .

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

  3. You create a method for flexible uploads with the data type Reported Financial Data and the file type FI‑SL Rollup File.

    1. On the Field Catalog tab page, you assign the source data basis.

      You can transfer your custom subassignments from the FI‑SL rollup file by assigning the fields on the Field Catalog tab page. For more information, see Transferring Custom Subassignments from FI-SL Rollups .

    2. On the Mapping tab page, you assign the InfoObjects to the key figures, 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 .

    3. On the Settings tab page, you define the update mode. If you want to use a Business Add-In (BAdI) for mapping, you need to specify the BAdI filter value. For more information, see Customizing for Flexible Upload .

    4. Optional: On the Selection tab page, you can define a target selection. For more information, see Selection .

      After you have defined and saved the upload method, the consolidation system will be able to export the customizing settings.

  4. You choose Export in the customizing settings for the upload method to export the settings from the consolidation system to a data file. For more information, see Exporting Customizing Files for FI-SL Rollups .

For more information about customization and use of upload methods, see Notes on Loading of FI-SL Rollup Files .

B. Activities in the Sender System

How the customizing file is transferred from the consolidation system to the sender system(s) and how FI‑SL rollup files are transferred to the consolidation system depends on your system landscape. For example, you might be able to access a network.

  1. You import the customizing file from SEM‑BCS: In Customizing for Enterprise Controlling choose Start of the navigation path Consolidation Next navigation step Integration: Preparation for Consolidation Next navigation step Preparations in the Sender System Next navigation step Preparation and Activation of Data Transfer Next navigation step Rollup Next navigation step Upload Customizing Settings from File. End of the navigation path

    Note Note

    Make sure you define the customizing settings that cannot be imported into the sender system first (see the “Prerequisites in the Sender System” section). See also Exporting Customizing Files for FI-SL Rollups .

    End of the note.

    After your import of the customizing settings is successful, the system is ready to create an FI‑SL rollup file.

  2. To execute a rollup, on the SAP Easy Access screen you choose Start of the navigation path Accounting Next navigation step Financial Accounting Next navigation step Special Purpose Ledger Next navigation step Periodic Processing Next navigation step Rollup Next navigation step Execute End of the navigation path .

    A rollup file is created.

C. Execution in the Consolidation System (SEM-BCS)

You load an FI-SL rollup file into the consolidation system by running the upload method in the consolidation monitor as follows:

  1. You go to the consolidation workbench, define a task for data collection, and assign the upload method to the task (see Defining a Flexible Upload ).

  2. You go to the consolidation monitor and start uploading the FI‑SL rollup file by running the data collection task (see Executing a Flexible Upload ).

    The upload writes data records only when no errors occur.

Result

You have loaded one or more FI-SL rollup files into the consolidation system.

Now you can prepare and consolidate the integrated data in the consolidation system.