Exporting Customizing Files for FI-SL Rollups

Use

You use this procedure to export your customizing settings from the consolidation system (SEM‑BCS) to a data file. These settings are required in the sender system for rollups of transaction data from the Special Purpose Ledger (FI-SL) component.

You create the customizing file in the consolidation workbench under upload method customizing and you use this file to load FI-SL rollup files. For more information, see Loading of FI-SL Rollup Files .

The operational applications of the sender system require knowledge of the customizing settings to be able to convert the transaction data to the accounting objects used in the consolidation system.

Export-Capable Customizing Settings

The following customizing settings exported from the consolidation system (SEM‑BCS) are imported into the following respective tables in the sender system:

  • Global settings (table in sender system: TF001)

  • Default values for subassignments (TF040)

  • Financial statement items (TF100, TF101)

  • Subitems (TF115, TF116)

  • Breakdown categories (TF103, TF103A, TF104)

  • Consolidation chart of accounts (TF120, TF121)

  • Dimensions (TF150)

  • Custom subassignments (check and text tables)

After the first time you export the customizing settings and import these into the sender system, you should always repeat this process after making subsequent changes to the settings in the consolidation system.

Customizing Settings in the Sender System

The consolidation system (SEM‑BCS) does not export the following customizing settings related to FI‑SL rollups. These settings need to be made in the sender system. (See “Prerequisites in the Sender System” in Loading of FI-SL Rollup Files .)

  • Independent characteristic values for each type of consolidation (TFIN000)

  • Master data for subitem categories (TF110, TF111)

  • Rules for ID combinations for each type of consolidation and consolidation unit (TFIN001)

  • Allocations of consolidation types and dimensions (TFIN002)

  • Mapping of transaction charts of accounts to consolidation charts of accounts (TFIN200)

  • Mapping of secondary cost elements to financial statement items (TFIN201)

    Note Note

    If you use a Business Add-In (BAdI) in the method for the flexible upload of FI‑SL rollup files to map subitems with custom subassignments, the consolidation system does not export the master data of subitems and custom subassignments.

    You need to define this master data in the sender system.

    End of the note.

Prerequisites

You have created and saved an executable method in the consolidation workbench for the flexible upload of FI‑SL rollup files.

Procedure

  1. In the consolidation workbench, open the method for the flexible upload of FI‑SL rollup files.

  2. Choose Export .

    If the method contains a custom subassignment and its check and text tables do not exist in the consolidation system, the system displays a dialog box in which you specify the RFC destination of the sender system (where you want to import the customizing file).

    The SAP Custom – File Save As dialog box appears.

  3. Specify the file’s path, name, and the extension .TXT Save the customizing file.

    The system exports the customizing settings to the specified file.

Result

You have exported the customizing settings of the consolidation system to a data file.

Once you have imported the customizing settings into the sender system, you will be able to create FI‑SL rollup files in the sender system with transaction data that is converted for use in the consolidation system (SEM‑BCS).