FI-SL Summary Database 

Use

The summary database contains summarized transaction data across documents for business transactions that enter the FI-SL System. Data is summarized for each period.

Features

The summary database contains:

Fixed Dimensions

You cannot change fixed dimensions.

Client, ledger, record type, version, fiscal year, object numbers (object/partner/transaction attribute), currency key, quantity unit, debit/credit indicator, and maximum period

Object numbers determine how the summary and line item database tables will be accessed via the object tables. The object number (receiver - ROBJNR) points to the variable dimensions defined in object table 1; the partner number (sender - SOBJNR) also points to the variable dimensions defined in object table 1. The transaction attributes number (COBJNR) points to the variable dimensions defined in object table 2.

Variable Dimensions

The variable dimensions that can be used in the summary database table are determined by the dimensions defined in object tables 1 and 2.

If the dimension was defined in object table 1:

The variable dimension can be an object (receiver) dimension, such as RCNTR, and/or a partner (sender) dimension, such as SCNTR; the dimension can be up to 10 characters long, of which up to the last nine characters must be defined in object table 1.

Object table 1 contains dimension ACCT.

The summary database table can contain an object (receiver) dimension RACCT, as well as a partner (sender) dimension SACCT.

Object (receiver) dimensions must begin with R, and partner (sender) dimensions, must begin with S.

If the dimension was defined in object table 2:

The dimension is taken over on a 1:1 basis into the summary database table.

Derived Fields

Derived fields are those fields that you do not want to include as key fields, but that you want to include in the data part of the database table (for example, Controlling Area (KOKRS) that is derived from the company code). Derived fields can only be used for reporting purposes; you cannot use derived fields in allocations or in other FI-SL functions.

An example of a summary database table structure delivered with the standard system is GLREFT (only for local ledgers). This table is only an example and must be copied for use in your system.