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.
Example
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.
Example
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.
Example
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.