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-LC-LC) module.
Top 10 tables in Basic Functions
| Table | Description |
|---|---|
| T855T | Reasons for inclusion in consolidation |
| T857E | Data entry form groups: Texts |
| FILCP | FI-LC: Plan line items for object table |
| T850G | Upload Methods: Texts |
| T875D | Asset transfers |
| T851 | Changes in Investments |
| T857P | Validation Rules |
| T850 | Company data for Consolidation |
| T867T | Product group texts |
| T873 | Hidden reserves |
List of tables in Basic Functions
| Table | Description |
|---|---|
| T855T | Reasons for inclusion in consolidation |
| T857E | Data entry form groups: Texts |
| FILCP | FI-LC: Plan line items for object table |
| T850G | Upload Methods: Texts |
| T875D | Asset transfers |
| T851 | Changes in Investments |
| T857P | Validation Rules |
| T850 | Company data for Consolidation |
| T867T | Product group texts |
| T873 | Hidden reserves |
| T854S | Selected FS items |
| T876V | Validation of Consolidation document |
| T863X | Selections for reporting |
| T880B | Valuation methods |
| T864 | Reclassifications |
| T850D | Assignment of business segment |
| T858 | Consolidation versions |
| FILCO | FI-LC: Acct assign.fields (Object-TrPartner) for table FILCT |
| T850A | Company sort criteria |
| T872I | Periodic entry for affiliated companies |
| T869 | Consolidation methods |
| T850C | Business segments: texts |
| TLMGB | Business area consolidation: MM assignments |
| T85S2 | FI-LC: Assignment of second add. fld to third add. fld |
| TKMGB | Business area consolidation: SD assignments |
| T877L | Consolidation activity groups: Texts |
| T874 | Elimination of hidden reserves |
| T868B | Elimination of IC profit/loss: Inventory management co.s |
| T852G | Subgroup companies |
| T875C | Changes in depreciation |
| T853 | Company status |
| T871 | Changes in investee equity |
| T85CT | Third additional field: Texts |
| T85S1 | FI-LC: Assignment of first add. fld to second add. fld |
| T853K | Subgroup status |
| T870 | Consolidation method assignment |
| T862T | Standard reports: Headers |
| GLS2IDX | Index table for FI-LC document cluster |
| T868 | Elimination of IC profit and loss |
| T863T | Report titles |
| T852 | Subgroups |
| T880G | Consolidation companies |
| EWULC01 | FI-LC: LC ledger |
| T875E | Change in depreciation of asset transfers |
| T863D | Report groups: Texts |
| T852U | Subgroup companies |
| T865 | Intercompany Elimination |
| T876 | Consolidation document types |
| T862Q | Standard reports: Column layout |
| T863C | Report groups: Names |
| T850Z | Layout: FS chart of accounts |
| T85YT | Additional field type: Texts |
| T867 | Product groups |
| T877K | Consolidation activity groups: Names |
| T869T | Consolidation of investments methods |
| T852O | Consolidation frequencies: Texts |
| T862R | Standard reports: Column layout texts |
| T863I | Reports for Interactive Reporting |
| T863Z | Selection: Document status |
| T877 | Consolidation activity groups |
| T850F | Upload methods |
| T863W | Valuations |
| T879P | Data transfer directories |
| T884T | Currency translation method table: Texts |
| T884H | Historical currency translation |
| T857N | Validation groups |
| T858T | Consolidation version texts |
| EWULC02 | FI-LC: Ledgers for conversion |
| T854T | Financial statement item texts |
| T857T | Column layout for data entry form: Text |
| T863 | Consolidation standard reports |
| T85C | Third additional field |
| T854 | Financial statement items for consolidation |
| T850B | Business segments |
| T859T | Data entry form title |
| FILCC | FI-LC: Transaction-related fields for table FILCT |
| FILCT | FI-LC: Global totals table with 2 object tables |
| T85BT | Second additional field: Texts |
| T884 | Currency translation |
| T857Y | Line layout for data entry form: Text |
| T862Z | Standard reports: Line layouts |
| T852P | Consolidation Periods |
| T862S | Standard reports: Column layout |
| T852N | Consolidation frequencies |
| T876T | Consolidation document type texts |
| EWULC03 | FI-LC: Companies for conversion |
| TGSBL | Text table for TGSBK |
| T85A | First additional field |
| T850K | Company correspondence data |
| T850S | Tax rates |
| T872 | Equity Holdings Adjustments |
| T852V | Version-dependent subgroup characteristics |
| FILCA | FI-LC: Actual journal entry table with 2 object tables |
| T857O | Validation groups: Texts |
| T857A | Column layout of data entry form |
| T875 | Asset transfers within the group |
| T850I | Version-dependent assignment: Company/data import + validtn |
| GSBLCA | Business area consolidation: deviating records |
| MCDX | Compressed Consolidation transaction data |
| T862Y | Standard reports: Line layout texts |
| GLT2 | Consolidation totals table |
| T854U | FS item short texts |
| T884S | Sets used in currency translation |
| T855 | Reasons for inclusion in consolidation |
| T857S | Column layout for data entry form: Names |
| T85Y | Additional Field Category |
| T856 | Transaction Types |
| T857 | Line layout of data entry forms |
| T857F | Data entry form bundling |
| T85B | Second additional field |
| T884F | Translation Differences: Additional Account Assignment |
| T862X | Standard reports: Line layout |
| GLT3 | Summary Data Preparations for Consolidation |
| T884R | Exchange rate indicator references |
| EWULC04 | FI-LC: Settings for euro conversion adjustments |
| T850H | Upload Methods: Field Catalogs |
| T862K | Standard reports: Headings |
| T879 | Standard texts |
| T863V | Valuations: Texts |
| T858I | Versions for Consolidation integration |
| T856T | Transaction type texts |
| T856X | Transaction type groups |
| T884M | Currency translation methods used in Consolidation |
| T863Y | INDX datasets |
| TGSBK | Consolidation business areas |
| T857X | Line layout for data entry form: Name |
| T866 | Elimination of IC profit/loss: FS items |
| T856Y | Transaction type groups: Texts |
| T884B | Assignment valuation methods to company codes |
| T884K | Exchange rate indicator for currency translation |
| T859 | Data entry forms |
| T857D | Data entry form groups: Names |
| T85AT | First additional field: Texts |
| T000K | Group |
| T862L | Standard reports: Header texts |
| T868L | Elimination of IC profit/loss: Vendor data |
| T876B | Document types |
| T866Z | Elimination of IC P/L: Assignment of additional fields |
| T863B | Report groups |
| TSTGC | Consolidation test data |