Totals Tables 

Definition

A totals table is a database table in which totals records are stored.

A totals table is used in General Ledger Accounting as the basis for your parallel ledgers. It offers a number of dimensions. SAP delivers the totals table FAGLFLEXT for General Ledger Accounting in the standard system.

Use

Standard Totals Table

When you activate new General Ledger Accounting, the totals records in General Ledger Accounting are updated in the standard totals table FAGLFLEXT. This totals table is deployed in functions such as planning and reporting.

SAP recommends working with the standard totals table delivered. In this way, you ensure that you can use the functions based on the standard totals table.

Own Totals Table

If the standard totals table delivered does not fulfill your requirements, you can define your own totals table. To do this, in Customizing for Financial Accounting (New), choose Financial Accounting Global Settings (New) → Ledgers → Fields → Customer Fields→ Include Fields in Totals Table. Choose Extras → Create Table Group.

When a totals table is created, the system simultaneously generates the corresponding line items table. For more information on creating table groups, see the SAP Library under Financials → Financial Accounting → Special Purpose Ledger → Configuration → Database Tables → Database Definition and Installation.

You can include your own dimensions in the totals table. For more information, see Customer Fields.