SAP Basic Functions Tables
Are you looking for the right table related to SAP Basic Functions Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Basic Functions (FI-SL-SL) module.
Top 10 tables in Basic Functions
| Table | Description |
|---|---|
| GLOO2 | Object Table for GLT02: Global |
| GGREFC | Example for Global FISL Objct Table 2 (Transactn Attributes) |
| ARC_IDX_AT | Index table for ACCTIT/ACCTHD/ACCTCR archives |
| GLTO2 | FI-SL Table with Objects, Structure Corresponds to GLT2 |
| GLREFA | Example for Local FI-SL Line Items (Actual) |
| ARC_IDX_IT | Archive index table for FI-SL line items |
| T807H | Rollup Header Information |
| T888T | FI-SL Field Assignment Texts |
| T820F | Planning Parameters: Field Group Information |
| GLTO1 | FI-SL Table with Objects, Structure Corresponds to GLT1 |
List of tables in Basic Functions
| Table | Description |
|---|---|
| GLOO2 | Object Table for GLT02: Global |
| GGREFC | Example for Global FISL Objct Table 2 (Transactn Attributes) |
| ARC_IDX_AT | Index table for ACCTIT/ACCTHD/ACCTCR archives |
| GLTO2 | FI-SL Table with Objects, Structure Corresponds to GLT2 |
| GLREFA | Example for Local FI-SL Line Items (Actual) |
| ARC_IDX_IT | Archive index table for FI-SL line items |
| T807H | Rollup Header Information |
| T888T | FI-SL Field Assignment Texts |
| T820F | Planning Parameters: Field Group Information |
| GLTO1 | FI-SL Table with Objects, Structure Corresponds to GLT1 |
| T881Z | Additional Ledger with Special Calculation Type |
| GGREFT | Example for Global FI-SL Summary Table |
| T892B | Substitution for Special Purpose Ledger / Company Code |
| T894T | FI-SL and FI-LC Version Texts |
| T883S | FI-SL User Tables |
| GLOO1 | Object Table for FI-SL Table GLTO1 |
| T892C | Substitution for Special Purpose Ledger / Global Company |
| T000G | Cross-Client FI-SL Postings |
| GGREFA | Example for Global FI-SL Line Items (Actual) |
| GLP1 | Local Logical General Ledger Plan Line Items |
| GLT0_DIF | G/L Account Master Record Transaction Figures |
| T891B | Validation for Special Purpose Ledger / Company Code |
| T881_KEYFIG | FI-SL: Key Figures per Ledger |
| T888 | Field Movement Header Table |
| FAGL_COMMIT_LEVL | FI-GL/SL: Permitted Commit Level for Totals Record Update |
| T830A | FI-SL Master Record Table |
| GLREFU | Example for FI-SL Rollup Line Items (Actual) |
| GLS2 | Global logical Consolidation line items |
| T80UT | FI-SL: Control Table for User Exits |
| GLOO3 | Object Table for FI-SL Table GLTO3 |
| T831A | FI-SL Master data text |
| T800D | Fields for Master Data Check |
| T894 | FI-SL and FI-LC Versions |
| T895 | Local Fiscal Year-Dependent Version Parameters |
| T886TCODE | FI-SL: Monitor Procedure - Transaction |
| GLREFV | Example for Rollup FI-SL Line Items (Plan) |
| T800DOM | Fixed exits |
| GLREFP | Example for Local FI-SL Line Items (Plan) |
| T820 | Planning Parameters |
| T895C | Global Fiscal Year-Dependent Version Parameters |
| T889T | Document Type Texts |
| GLFUNCT | Totals Table for Cost of Sales Accounting |
| TLDGRP | Ledger Group FI-SL |
| GLREFC | Example for Loc. FISL Objct Table 2 (Transaction Attributes) |
| T886 | FI-SL Activities |
| GLIDXA | Index to Find FI-SL Documents Based on AWKEY |
| GLPO2 | Plan Line Items for Object Table Global |
| T022T | FI-SL Activities: Text |
| T030C | Global Standard Account Table |
| T800A_KEYFIG | FI-SL: Key Figures for Table Group |
| GLTO3 | FISL Table with Objects, Amounts and Quantities in Format P9 |
| GLFUNCU | Rollup line item tables with function area for IDES |
| T807 | Rollup Sequence |
| T022 | FI-SL Activity: Fixed Data |
| T822 | Planning Parameter Classes |
| GLFUNCC | Object Table 2 for Cost of Sales Accounting |
| T883 | User Table Fields |
| T807R | FI-SL Rollup: History of Executions |
| T889TE | Document Type Texts |
| T822T | Planning Parameter Class Descriptions |
| T800O | Object management FI-GL/FI-SL |
| FAGL_CUS_GENINFO | New General Ledger Accounting: Generation Status (Customer) |
| T022F | Format Table (Grouping of the Sender Tables) |
| T811U | Table Information Allocation Sender/Receiver Relationship |
| GB91T | Texts for validations |
| T001C | Valid Posting Periods for Global Companies |
| GLT0_BAK | G/L Account Master Record Transaction Figures |
| GLFUNCO | Object Table 1 for Cost of Sales Accounting |
| T884C | Control Balance Carried Forward |
| T800HISTP | Log Tables for Program Runs in FI-GL or FI-SL: Items |
| T022FT | Texts for Formats used in FI-SL |
| T886A | Activity/Ledger Information |
| T800M | FI-SL: Fixed Field Movements |
| T890 | FI-SL: Boolean Formulas |
| T883T | Descriptions of FI-SL user tables |
| T893 | Ledger Selection Conditions |
| T831D | FI-SL Master data text |
| GLPO3 | Plan Line Items for Object Table |
| T881T | FI-SL Ledger text |
| T881 | Ledger Master |
| GLT1 | Local General Ledger Summary Table |
| GLP0 | Local Logical General Ledger Plan Line Items |
| T000C | Table for Installing FI-SL Customizing |
| T820T | Planning Parameter Descriptions |
| GLP2 | Global Special Purpose Ledger Plan Line Item Table |
| GLSO2 | FI-SL Table with Objects, Structure corresponds to GLS2 |
| GLFUNCP | Plan Line Items Table for Cost of Sales Accounting |
| T800HISTH | Log Tables for Program Runs in FI-GL or FI-SL: Header |
| GGREFO | Example for Global Object Table 1 (Object/Partner) |
| T887 | Activity/Ledger/CCode Information |
| GLFUNCA | Actual Line Items Table for Cost of Sales Accounting |
| T891C | Validation for Special Purpose Ledger / Global Company |
| T830D | FI-SL Master Record Table |
| GGREFP | Example for Global FI-SL Line Items (Plan) |
| TLDGRP_MAP | Assignment of Ledgers to Ledger Groups |
| GLFUNCV | Rollup plan line items table with function area for IDES |
| GLPO1 | Plan Line Items for Object Table |
| T800G | Flexible general ledger installation check |
| T886C | Activity/Ledger/Company Information |
| T892U | Rollup Substitution |
| T889B | Number Ranges for Document Types for Global Objects |
| T807T | FI-SL Rollup texts |
| GLSO1 | FI-SL Line Item Table with Objects for GLTO1 |
| TRWLVL | List of variants for FI-SL line item reports (fields) |
| GLREFT | Example for Local FI-SL Summary Table |
| SMFISL | Spec. FI-SL Data in Monitor (See Schedman_specific_fisl) |
| T886B | Activity/Ledger/CCode Information |
| T800A | FI-SL tables |
| T889A | Number Ranges for Document Types for Local Objects |
| T889C | FI-SL Document Types - Global Company IDs |
| GLSO3 | FI-SL LI Table with Objects for GLTO3 |
| T882C | Global Company-Ledger Assignment in FI-SL |
| T889 | FI-SL Document Types |
| T80U | FI-SL: Control Table for User Exits |
| TRWLVH | List of variants for FI-SL line item reports (header) |
| TGUMS | FI-SL: Convert Tables |
| T887C | Activity/Ledger/Company Information |
| GLT0_BCK | G/L Account Master Record Transaction Figures |
| GLS1 | Local Logical General Ledger Actual Line Items |
| TLDGRPT | Ledger Group Texts (FI-SL) |
| T888M | FI-SL Field Assignments |
| T800B | Generated Archive and Database Reports for FI-SL Tables |
| T882 | Company Code/Ledger Assignment |
| T831B | FI-SL Master Record Table |
| T830B | FI-SL Master Record Table |
| TRWLVHT | List of variants for FI-SL line item reports (texts) |
| T881W | Possible Combinations of Currency Keys in FI-SL |
| GLREFO | Example for Local Object Table 1 (Object/Partner) |