SAP Information System Tables
Are you looking for the right table related to SAP Information System 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 Information System (FI-GL-IS) module.
Top 10 tables in Information System
| Table | Description |
|---|---|
| ESREB_BIPARAMS | Technical Parameters for Batch Input Posting (ES Rebates) |
| T049F | Cashed Checks Control Table |
| T007X | Text for Grouping Tax Amounts |
| T049B | Control Parameters for Autocash |
| T044E | Foreign Currency Valuation: Items with Special Cover |
| BWFI_AEDAT | BW FI: Log Table for Changed FI Documents |
| T044D | Work Files for the Extract of the Accum.Balance Audit Trail |
| T007K | Table for Grouping Tax Basis Balances |
| T044L | Sorted List of Open Items |
| FISD_MAP_FIELDS | Map fields from ODP to HANA view |
List of tables in Information System
| Table | Description |
|---|---|
| ESREB_BIPARAMS | Technical Parameters for Batch Input Posting (ES Rebates) |
| T049F | Cashed Checks Control Table |
| T007X | Text for Grouping Tax Amounts |
| T049B | Control Parameters for Autocash |
| T044E | Foreign Currency Valuation: Items with Special Cover |
| BWFI_AEDAT | BW FI: Log Table for Changed FI Documents |
| T044D | Work Files for the Extract of the Accum.Balance Audit Trail |
| T007K | Table for Grouping Tax Basis Balances |
| T044L | Sorted List of Open Items |
| FISD_MAP_FIELDS | Map fields from ODP to HANA view |
| FBW4XT | Text Exceptions for FI AP/AR Delta Update to BW |
| FINS_GRIRPROC | GR/IR Clearing Process |
| T049A | Posting Data For Autocash With Lockbox |
| BWFI_AEDA2 | BW FI: Log Table for Changed Transaction Figures |
| DKKOS | Balance Audit Trail |
| FINSC_GRIRSTATXT | GR/IR Clearing Process Status Text |
| UMSVZ | Advance Return for Tax on Sls/Pur.Period |
| T049E | Control Data for Swiss ISR Procedure |
| FISD_MAP_ODP | Map ODP to HANA View |
| FINSC_HRRP2SEMTA | Mapping of Hierarchy Node to Semantic Tag |
| TABKT | Automatic Accounts for End-Year Closing/Opening Postings ITA |
| T044I | FI Valuation: Determine Base Value |
| BWPOS | Valuations for Open Items |
| SREPACCESSTYPE | Access Type |
| TEURA | Reports Supporting Alternative Local Currencies |
| DSKOP | Balance Audit Trail |
| UMSV | Tax Balances per Comp.Code, Tax Code and Process.Key |
| T007J | Tax Advance Payment per Taxes on Sls/Pur.Grp and Cal.Yr |
| T044LH | Sort Methods |
| T044J | Preference Key for Reading Valuation Results |
| T007Z | Time-Dependent Version Assignment - For ELSTER |
| T007R | External Group Number for Tax Amounts |
| FINSC_GRIRRTCSTX | GR/IR Clearing Process Root Cause Text |
| FINSC_SEM_TAG_GN | List of Semantic Tag Group Names |
| DKOKS | Open Item Account Balance Audit Trail Master Record |
| FINSC_GRIRMLDEST | Key Value pairs of GRIR service destinations |
| TFE05 | BDF: State CB Indic. |
| QSTRE | FI/HR Withholding Tax Report for Spain |
| RFSCASH | Cash Book table |
| TBKOW | Valuation Difference Temporary Storage |
| BWKS | Accounts Blocked by Valuation Selection |
| TRVOR | Control Statements |
| RFASLD11B | EC Sales List (Spain) |
| TEURB | Altern. Local Currency and Exch.Rate Type for a Company Code |
| BWFI_AEDA3 | BW FI: Log Table for Changed Credit Management Data |
| FBW4X | Exceptions for FI AP/AR Delta Update to BW |
| T001M | Data on Z5A Foreign Trade Regulations Report, Germany |
| FINSC_GRIRROOTCS | GR/IR clearing root cause |
| FINSC_GRIRFLLWON | GR/IR Clearing Process Follow-On Status |
| FINS_GRIRPROCHIS | GR/IR Clearing Process History |
| T007H | Table no Longer Used -> T007K/L |
| TFE01 | BDF: Currency Key |
| FINSC_SEM_TAG | List of Semantic Tags |
| TBUVTX | Transfer Posting of Tax in a Cross-Company Code Transaction |
| T030HB | Acct Determ.for Open Item Exch.Rate Differences |
| FINS_GRIR_MLCONF | Basic Settings of GRIR ML Features |
| T044LT | Sorted List of Open Items |
| FINSC_FAGL2SEMTA | Mapping of Financial Statement Version to Semantic Tag |
| TFE02 | BDF: Countries |
| DKKOP | Balance Audit Trail |
| FINSC_SEM_TAG_N | List of Semantic Tag Names |
| DKOKP | Open Item Account Balance Audit Trail |
| SREPACCESSTYPET | Access Type |
| T007L | Table for Grouping Tax Balances |
| FINSC_SEM_TAG_G | List of Semantic Tag Groups |
| TITVAR | Line Items: Line Layout Variants, Assignment Old-New |
| FINSC_GRIRSTATUS | GR/IR clearing status |
| T042X | Company Codes Blocked by the Payment Program |
| T007G | Table no Longer Used -> T007K/L |
| T044G | Valuation Adjustment Key |
| T007M | Table for Grouping Taxes for BW |
| T044KT | Further Specifications for Sorted List |
| TFE19 | BDF: Accts Subj. to Report. |
| TFE18 | BDF: Identif. of Offsett. Accounts |
| DSKOS | Balance Audit Trail |
| FIN_S_PTYPE_107 | Values for posting type for adjustment posting |