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-GL-GL) module.
Top 10 tables in Basic Functions
| Table | Description |
|---|---|
| T060L | FI constant name |
| ETXDCF | External tax document: Accounting document info |
| GLACCT_Q2P_MIG | G/L Account Master: Migration to Q2P Status |
| HRRP_DIRECTORYT | Hierarchy directory texts |
| GLACCREFH | G/L Account Master Record: Create with Reference |
| HRY_REPRELEV | Report relevant setting for Hierarchy |
| DOCCHG_EWBUCH | Customizing of Posting Transaction |
| T060K | FI constants |
| FISI_ANNOTA_TEXT | SFIN Search Help Text Annotations For OData Services SHLP |
| TTXI | External tax interface: index file |
List of tables in Basic Functions
| Table | Description |
|---|---|
| T060L | FI constant name |
| ETXDCF | External tax document: Accounting document info |
| GLACCT_Q2P_MIG | G/L Account Master: Migration to Q2P Status |
| HRRP_DIRECTORYT | Hierarchy directory texts |
| GLACCREFH | G/L Account Master Record: Create with Reference |
| HRY_REPRELEV | Report relevant setting for Hierarchy |
| DOCCHG_EWBUCH | Customizing of Posting Transaction |
| T060K | FI constants |
| FISI_ANNOTA_TEXT | SFIN Search Help Text Annotations For OData Services SHLP |
| TTXI | External tax interface: index file |
| T011P | Table no longer in use |
| TGSBG | Cross-system business areas |
| FAGL_SLL_CLOCO | Closing Cockpit Templates for Switching Leading Ledger |
| SKB1CE | G/L Account Master (Company Code) + CELEM |
| T011Z | Table no longer in use |
| BSACC_HIST_TYPE | Type of Statement of Changes |
| FISI_ANNOTA_TXTG | SFIN Search Help Text Annotations For OData Services GEN |
| FISI_ANNOTA | SFIN Search Help Annotations For OData Services |
| BSACC_HIST_GRP | Account Groups for Statement of Changes |
| FISI_ANNOTA_REPP | SFIN SHLP Annotations Replacement Parameters OData Services |
| TTXY | External tax interface: tax information |
| ETXJCD | External Tax Jurisdiction Code Description |
| FIGL_USER_OWNERT | Applications for User-Specific Data |
| TTXCALLTRC | Tax Interface Usage Analysis: Call Trace |
| T011 | Financial Statement Versions |
| TGSBH | Texts for table TGSBG |
| FISI_ANNOTA_PARA | SFIN Search Help Parameter Annotations For OData Services |
| GLACCOUNT_CTRL2 | Control for G/L account master data processing |
| T011B | FI financial calendar - job text table |
| FAGL_SLL_CLOCO_I | Closing Cockpit Instances for Switching Leading Ledger |
| HRRP_NODE | Hierarchy node |
| T011Q | Table no longer in use |
| SKCSKB | Mass Maintenance: Cost Elements |
| T004R | Rules index for sample accounts |
| T004S | Texts for sample account rules |
| BSACC_HIST_GRPT | Account Groups for Statement of Changes |
| ETXDCH | External tax document: header info |
| HRRP_TYPT | Hierarchy type texts |
| FINSC_BPC_CSKB | Best Practice Content Activation: Cost Element Category |
| T011V | FI financial calendar task-schedule link |
| GLACCOUNT_IMGA1 | IMG activity assignment |
| TTXP | Product codes (external tax interface) |
| FAGL_C_DI_TDT | Document Issue Type Determination (Texts) |
| FAGL_C_DI_TD | Document Issue Type Determination |
| RFBISATT | Processing log for report execution of RFBISATT |
| T011E | Calendar of person responsible for unit |
| FISI_ANNOTA_FILT | SFIN Search Help Filter Annotations For OData Services |
| T011T | Financial statement version names |
| SKAD | G/L Account Master Record (Chart of Accounts) |
| BSACC_HIST_TA | Statement of Changes: Transaction Types Used |
| HRRP_TYP | Hierarchy type |
| FISI_ANNOTA_TXTF | SFIN Search Help Text Annotations For OData Services FIELD |
| DOCCHG_CLACCT | Customizing: Clearing Account. Required for Transfer Posting |
| FIGLDOC | G/L accounting: Subsequent derivations |
| DOCSPL_FSTATUS | Field Status Groups for Item Split |
| HRRP_ATTR_NODE | Hierarchy attribute on node |
| FAC_GLACCT_VH_L | Value help for GL Account (manual) - Operational & Local CoA |
| DOCCHG_FSTATUS | Field Status Groups for Screen Fields |
| TTXU | External tax interface: Audit file update information |
| TAXMSD | Tax Interface Manager Status Diagram "Tax Per document" |
| BSACC_HIST_CUST | General Settings for Statement of Changes |
| FIGL_USER_OWNER | Applications for User-Specific Data |
| ETXDCJ | Ext. tax document: tax rates and amounts by Jurisdict. level |
| FISI_ANNOTA_REPL | SFIN Search Help Annotations Replacement For OData Services |
| GLACCOUNT_CTRL1 | Control for G/L account master data processing |
| FISI_ANNOTA_EXCL | SFIN Search Help Annotations Excluded Fields For Generation |
| COSTELEMCATEGORY | Do not use |
| HRRP_NODET | Hierarchy node texts |
| GLACCOUNT_IMGA0 | IMG activity assignment |
| BSACC_HIST_ASSGN | Assignment of Type of Statement of Changes to COA/CoCode |
| SKM1 | Sample G/L accounts |
| FIGL_USER_DATA | User-Specific Data for Individual Transactions |
| GLACCOUNT_IMGA2 | IMG activity assignment |
| DOCCHG_BARCODE | Ext. Document Change: Customizing for Barcode Processing |
| GLACCREFI | G/L Account Master Record: Create with Reference |
| GLACCT_Q2P_MIG_B | G/L account migration to Q2P: Transfer Table for SKB1 |
| HRRP_ATTR_DIR | Hierarchy attribute on directory |
| BSACC_HIST_TYPET | Texts for Type of Statement of Changes |
| TTXJCDTRC | Tax Interface Usage Analysis: Jurisdiction Trace |
| GLACCT_Q2P_OIM | G/L Account Master Replication: Transfer Table for Open Item |
| T060M | FI constant values |
| FAGL_DI_DATA | Document Issue Details |
| FAGL_DI_LOG | Document Issue Log (History) |
| HRRP_DIRECTORY | Hierarchy directory |
| ETXDCLOG | Temporay table for storing last error message of an update |
| FINS_GLACC_SUBTY | GL Account Subtype |
| HRRP_TYP_APPAREA | Application Area and Hrrp type mapping |
| GLACCT_Q2P_MIG_A | G/L account migration to Q2P: Transfer Table for SKA1 |
| TTXCALLST | Tax Interface Usage Analysis: Call Stack |
| ETXDCI | External tax document: line item info |
| FINS_GLACC_SUBTT | GL Account Subtype |
| DOCCHG_COBL_FS | Field Status Groups for COBL Screen Fields |
| GLACCT_Q2P_MIG_C | G/L account migration to Q2P: Transfer Table for CSKB |
| T011A | Calendar - task description |
| SKAS | G/L account master (chart of accounts: key word list) |
| TTXPT | Product code description (external interface) |
| T011F | FI fin.calendar - person responsible for unit text table |
| T051A | Account Balances for Statutory Reporting |
| TTXADV | Switch to Advanced US External Indirect Tax Calculation |
| HRRP_SDM_STATUS | HRRP Data Migration Status |
| GLACCT_Q2P_MIG_T | G/L account migration to Q2P: Transfer Table for SKAT |
| SKCSKA | Mass Maintenance: Cost Elements |
| TSAKR | Create G/L account with reference |
| SKB1 | G/L account master (company code) |