Assignment of FI-SL Rollup Files in SEM-BCS

Use

The flexible upload of a rollup file from the Special Purpose Ledger (FI-SL) component to the SAP SEM Business Consolidation (SEM-BCS) component initially loads the fields of the rollup file into the assigned InfoObjects in SAP NetWeaver Business Intelligence (BI).

The fields of the FI‑SL rollup file are defined in the ECMCT table of the SAP EC Consolidation (EC-CS) component.

In the mapping area of the upload method, the InfoObjects are used as the source fields, which you assign to the target fields in the consolidation system on the Mapping tab page.

For more information, see Loading of FI-SL Rollup Files .

Assignment of FI-SL Rollup Files to the InfoObjects

By default, the consolidation system transfers the following fields from the FI‑SL rollup file and assigns them to the InfoObjects as follows:

Assignments of FI-SL rollup file fields to the InfoObjects

Field inRollup File

Long Description

InfoObject

InfoObject Type

PRACQ

Period in which the first acquisition is posted

0ACQ_PER

Characteristic

RBUNIT

Consolidation unit

0CS_UNIT

RBUPTR

Partner unit

0CS_PARTNER

RDIMEN

Dimension

0CS_DIMEN

RITCLG

Consolidation chart of accounts

0CS_CHART

RITEM

Item

0CS_ITEM

RVERS

Consolidation version

0CS_VERSION

SITYP

Subitem category

0CS_SITEMCT

SUBIT

Subitem

0CS_SITEM

YRACQ

Fiscal year in which the first acquisition is posted

0ACQ_YEAR

HSL0x

Period value in local currency

0CS_TRN_LC

Key figure

KSL0x

Period value in group currency

0CS_TRN_GC

MSL0x

Cumulative quantity

0CS_TRN_QTY

TSL0x

Period value in transaction currency

0CS_TRN_TC

RYEAR

Fiscal year

0FISCYEAR

Time Characteristic

RTCUR

Currency key of transaction currency

0CURKEY_TC

Unit

Note Note

In addition to the fields listed above, you can also transfer your own custom subassignments from an FI-SL rollup file. For more information, see Transferring Custom Subassignments from FI-SL Rollups .

End of the note.

Integration

InfoObjects, Type “Characteristic”

The InfoObjects with the type “Characteristic” must be contained in the InfoObject catalog for characteristics, which you have specified in the source data basis used for the flexible upload.

The InfoObject catalog 0ECCS_CHA01 is available as SAP Business Content in SAP NetWeaver Business Intelligence (BI) for this purpose.

You can also use a different InfoObject catalog for characteristics, provided it includes all of the InfoObjects contained in 0ECCS_CHA01.

InfoObjects, Type “Key Figure”

The InfoObjects with the type “Key Figure” must be contained in the InfoObject catalog for key figures, which you have specified in the source data basis used for the flexible upload.

The InfoObject catalog 0ECCS_KYF01 is available as SAP Business Content in SAP NetWeaver Business Intelligence (BI) for this purpose.

You can also use a different InfoObject catalog for key figures, provided it includes all of the InfoObjects contained in 0ECCS_KYF01.

InfoObjects, Other Types

The system assigns InfoObjects such as the fiscal year (0FISCYEAR), which have a type other than “characteristic” or “key figure”, internally. This means that you do not have to specify these InfoObjects in the source data basis.