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 (It is explained below). SAP delivers the totals table FAGLFLEXT for General Ledger Accounting in the standard system.
Use of Totals Table
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. You can include your own dimensions in the totals table. For more information, see Customer Fields.
Meaning of Dimensions: A single field or column of a table, within General Ledger. Dimensions are used when creating the General Ledger coding block.
Examples of dimensions are
Use of Totals Table
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. You can include your own dimensions in the totals table. For more information, see Customer Fields.
Meaning of Dimensions: A single field or column of a table, within General Ledger. Dimensions are used when creating the General Ledger coding block.
Examples of dimensions are
- Company
- Account
- Cost center
- Product
No comments:
Post a Comment