Transferring Custom Subassignments from FI-SL Rollups

Use

You use this procedure to transfer custom subassignments from a rollup file created in the Special Purpose Ledger (FI-SL) component to the SAP SEM Business Consolidation (SEM-BCS) component.

In the sender system, custom subassignments are defined in table ECMCT of the SAP EC Consolidation (EC-CS) component.

Prerequisites

You have created a source data basis in the consolidation workbench. There you have specified the InfoObject catalogs for the characteristics and key figures required for the flexible upload of FI-SL rollup files. For more information, see Assignment of FI-SL Rollup Files in SEM-BCS .

You have created an executable method for the flexible upload of FI‑SL rollup files. For more information, see Loading of FI-SL Rollup Files .

The InfoObject that will accommodate the custom subassignment from the FI‑SL rollup file has been activated in SAP NetWeaver Business Intelligence (BI).

Procedure

Perform the following steps in the Data Warehousing Workbench :

  1. Open the InfoObject catalog for characteristics that you use in the method for the flexible upload of FI‑SL rollup files.

  2. Add the InfoObject you want to use to transfer the custom subassignment from the FI-SL rollup file.

    After you save the InfoObject catalog, the new InfoObject is available in Customizing for the method for the flexible upload of FI‑SL rollup files.

Perform the following steps in the Consolidation Workbench :

  1. Open the method for the flexible upload of FI‑SL rollup files.

  2. Choose the Field Catalog tab page and add a new line to the custom subassignments table as follows:

    1. In the Field Name of Custom Subassignment column, enter the field name of the custom subassignment used in the FI‑SL rollup file (or the ECMCT table).

    2. In the Field Name column, choose the InfoObject you want to use for the custom subassignment from the FI-SL rollup file.

    3. In the Name of Check Table column, enter the check table from the sender system that is assigned to the custom subassignment.

    4. In the Name of Text Table column, enter the associated text table of the sender system.

      The check and text tables are needed for exporting the customizing settings and for importing and assigning those settings in the sender system.

      Note Note

      You can display the field names and their check and text tables in the sender system: In Customizing for Enterprise Controlling choose Start of the navigation path Consolidation Next navigation step Add Characteristics End of the navigation path .

      End of the note.

  3. Choose the Mapping tab page and assign the InfoObject (source field) for the custom subassignment to a target field in the consolidation system.

  4. Save the changes made to the upload method.

Result

You have extended the upload method by one or more custom subassignments.

After you have exported the customizing file and imported it into the sender system, FI‑SL rollup files created in the sender system will contain the custom subassignments.

Then the consolidation system also accepts the custom subassignments when the rollup file is uploaded.

Example

You want to transfer the Distribution Channel as a custom subassignment to the consolidation system.

The distribution channel has the field name ZZDCH in the ECMCT table. The associated check table is the TDCH table and the associated text table is the TDCHT table.

The InfoObject 0DISTR_CHAN is available in BI.

In this example, the entry in the table of custom subassignments looks like this:

Table of Custom Subassignments

Field Name of Custom Subassignment

Field Name

Name of Entity Table

Name of Text Table

ZZDCH

0DISTR_CHAN

TDCH

TDCHT