Summary Tables 

Definition

Totals records are updated in the summary table for business transactions that are transferred to or entered in the special purpose ledgers. Totals are created for each period.

Structure

The summary table contains:

Fixed Dimensions

 You cannot change fixed dimensions.

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

Object numbers determine how the summary and line item database tables are 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 movement 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 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 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 transferred to the summary table on a 1:1 basis.

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. In allocation, or other FI-SL modules, you cannot use derived fields.

An example of a summary table delivered with the standard system is GLREFT (only for local ledgers). If you want to use this table in your system, you have to copy it and change it in accordance with your requirements.