Show TOC

 Library, Database Structure, Characteristics and Selection Logic Locate this document in the navigation structure

For general information on libraries and characteristics, see Library .

Library

SAP delivers the library 0CS in client 000 for Report Writer reports in Consolidation.

Database Structure

The name of the database structure for Report Writer reports in Consolidation is FIMC .

It contains all of the essential characteristics needed for Report Writer reports in Consolidation.

Characteristics

Length of Characteristics

The length of the characteristics in the Report Writer must be less than or equal to 24 characters. Make sure this maximum length is not exceeded when defining custom characteristics in Consolidation for use with the Report Writer.

Discussion of Certain Characteristics

Certain characteristics of database structure FIMC need further explanation:

Characteristic

 

Explanation

RYEAR

Fiscal Year

  • Used for selecting data

RPMAX

Period

CGYEAR

Fiscal year for drilling down a consolidation group

  • Time characteristics for drilling down the hierarchy

  • Each is typically a single value – for better performance

PERID

Period for drilling down a consolidation group

INICG

Consolidation Group

You are urged to use this characteristic uniformly within a report.

You can use the two separate characteristics for the fiscal year and the period for restatements, for example, to report on the values of past fiscal years for the present consolidation group hierarchy.

Consolidation-Specific Selection Logic

Reports for Consolidation Groups

The system uses the consolidation-specific selection logic for the following characteristics in Report Writer reports for consolidation groups:

  • Consolidation group (INICG)

(with accounting techniques of the consolidation of investments methods)

  • Posting level (PLEVL)

  • Partner unit (RBUPTR)

In Report Writer reports for consolidation groups, the data selection is dependent on the posting level:

  • Posting levels 02, 12, 22:

The system selects only the data records that were posted in the selected consolidation group.

  • Posting levels 20, 21:

The system selects only the data records where both the consolidation unit itself and the partner unit belong to the consolidation group. (However, the system does not select data records of consolidation units and partner units which are consolidated using the equity method or the mutual stock method.)

  • Posting level 30:

The system selects only the data records that were posted in the selected consolidation group or a lower-level group subordinate to the selected consolidation group.

  • All posting levels:

The date of first consolidation and the date of divestiture are used when determining whether a consolidation unit belongs to a consolidation group.

Reports for Consolidation Units

In reports for consolidation units (without the characteristic consolidation group ), the system does not assess the aforementioned dependencies that are valid for consolidation groups.