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 (FIN-FSCM-CLM-CM-CM) module.
Top 10 tables in Basic Functions
| Table | Description |
|---|---|
| FDESDIST | Cash management memo records (distributed) |
| T028N | Currency class descriptions |
| FFO_LBF_D_REF | Reference - #GENERATED# |
| T018D | Forms for Cash Management and Forecast |
| FDAU | Cash Managment Advice Authorization Catalog |
| T028H | Allocate Manual to Internal Transactions |
| T028G | Allocate External to Internal Transactions |
| T038V | Distribution for Cash Mgmt Position and Liquidity Forecast |
| FIEB_STMT_AZNUM | Bank Statements numbers for specific Msg Id's |
| T036S | Planning Levels with Payment Blocks |
List of tables in Basic Functions
| Table | Description |
|---|---|
| FDESDIST | Cash management memo records (distributed) |
| T028N | Currency class descriptions |
| FFO_LBF_D_REF | Reference - #GENERATED# |
| T018D | Forms for Cash Management and Forecast |
| FDAU | Cash Managment Advice Authorization Catalog |
| T028H | Allocate Manual to Internal Transactions |
| T028G | Allocate External to Internal Transactions |
| T038V | Distribution for Cash Mgmt Position and Liquidity Forecast |
| FIEB_STMT_AZNUM | Bank Statements numbers for specific Msg Id's |
| T036S | Planning Levels with Payment Blocks |
| T035U | Texts for Cash Management Account Names |
| T028X | Returns Reasons |
| FDSR2 | CMF Totals Records for Planning Groups (As of Release 604) |
| T035D | Cash Management Account Names |
| AT85 | CMF - Generating pmnt advices (prod./trans.type) |
| TPAMA | Search Strings for Pattern Matching |
| FDS2 | CM&F Line Items in SD Documents (fromr Release 4.0) |
| FFO_LBF_D_TRLR | Trailer - #GENERATED# |
| FDTL | Telephone list |
| FFO_LBF_D_BTCTTL | Batch Total - #GENERATED# |
| T243S | TRCM Link: Transmission Status |
| T028R | Repetitive Funds Transfer Types |
| T012B | Description of trans. types |
| T028P | Assign Search Strings to Bank Statement Transactions |
| FDD1 | Cash mgmt and forecast-Loan line items-Memo records |
| T036Q | Allocating Levels for T0360 |
| T028RTRANS | Repetitive Transfer Transactions |
| FAR_BSIMP_P_ID | Bank Statement Import - Parameter Set IDs |
| FAR_BSIMP_P_VALS | Bank Statement Import - Parameter Set - Parameter Values |
| T028O | Currency classes |
| FEBKO_JOB | Stores job information for FEBKO records |
| T036T | Planning Level Texts |
| T028Q | Mapping Table |
| FDSP | Cash Mgmt Adjustment Items from Document Splitting |
| T028B | Transaction Type of Sender Bank |
| T036M2 | Earmarked Funds: Group Assignment If Account Missing |
| T028Y | Returns Activities: Posting Rules / Reverse Clearing |
| T012C | Terms for bank transactions |
| FIEB_MAPP_X_CUST | Differing mapping formats for bank statement formats |
| FDSR | CMF Totals Records for Planning Groups |
| T038 | Cash Management: Grouping Structure |
| FDSBDIST | CMF Totals Records for G/L Accounts (Distributed) |
| T036O | Symbols for Allocating Levels for Updating |
| FEBEXTTRN | External transaction code text definition |
| FAR_BSIMP_P_RNGS | Bank Statement Import - Parameter Set - Number Ranges |
| FDLF2 | Cash Management Line Items for Agency Business (As of 604) |
| FEBVW | Electronic Banking Management Records |
| T036 | Planning levels |
| FDSB | CMF Totals Records for G/L Accounts |
| T038N | Grouping for Bank Accounts |
| FDRE | Cash Management Line Items from RE-FX (Real Estate) |
| FAR_BSIMP_T | Text table Bank Statement Import - Parameter Set IDs |
| FEBKO_REVERSED | Header of Reversed Bank Statements |
| FIEB_FMTGRP_X | Grouping of Bank Statement Formats |
| T039 | Source Symbols for Cash Management |
| FDW1 | Cash Mgt and Forecast - Securities Line Items- Planned Flows |
| FDI1 | Cash Management Line Item for RE Classic Planning Records |
| FEBKO | Electronic Bank Statement Header Records |
| FAR_IPF_C_FORMAT | Customizing table for Payment File Format |
| FAR_IPF_C_INTDAY | Customizing table for Intraday Payment File Format |
| FDT1 | CMF Line Items for Forex, Money Market, Derivatives |
| T037B | Texts for Archiving Categories |
| T012A | Allocation pmnt methods -> Bank trans. |
| FFO_LBF_D_RTTTL | Root Total - #GENERATED# |
| FDES | Cash Management and Forecast: Memo Records |
| FAR_IPF_T_INTDAY | Text table for FAR_IPF_C_INTDAY |
| T018C | Cash Concentration: Intermediate Acct and Amt Stipulations |
| FDS1 | Cash Management & Forecast: Line Items of SD Documents |
| T028Z | Returns Activities: Change Open Items |
| T036M | Level Assignment for Earmarked Funds |
| FFO_LBF_D_CHECK | Check - #GENERATED# |
| T028RS | Repetitive Funds Transfer Type Names |
| FFO_LBF_D_ROOT | Lockbox File Header - #GENERATED# |
| T038P | Cash Management: Groupings (Checking Table) |
| FEBCL | Clearing data for an electronic bank statement line item |
| T038T | Texts for Groupings |
| FEBEP | Electronic Bank Statement Line Items |
| T037T | Planning Type Texts |
| T018Z | Cash Transfer: Payment Method Determination Payment Requests |
| FEBCL_EXT | Clearing data for bank stmt line item: Extension fields |
| T028E | Text Table for T028D |
| FDAPPLACT | Status of Application Components Activation |
| T039T | Source Symbol Texts |
| FDLF | Cash Management Line Items for Agency Business |
| FEBPI | Polling Statement Line Item Information |
| TPAMAT | Text Table for Search String TPAMA |
| T037 | Planning Types |
| FFO_LBF_D_SRVC | Service - #GENERATED# |
| T035Z | Liquidity Forecast: Payment Date Determinations/Assignments |
| T243X | Table for Logical Systems |
| FAR_IPF_T_RJCTN | Text table for FAR_IPF_C_RJCTN |
| FIEB_MAPP_XCTRLT | Description of Bank Statement Format |
| FDMV | Cash Planning Line Items of Earmarked Funds |
| T028A | Bank Statement Table |
| T036P | Texts for Level Symbols in T0360 |
| FDFIEP | CM: FI Line Items (OP of Deb/Cred for Drilldown) |
| FEBMS | Message table for Finnish bank statement |
| FIEB_MAPP_X_CTRL | Mapping Procedure for Bank Statement Format |
| FEBRE | Reference record for electronic bank statement line item |
| T035 | Planning groups |
| T028D | Define Internal Transactions in Electronic Banking |
| T035V | Allocate G/L Account to Segmentation (temporarily not used) |
| FFO_LBF_D_BATCH | Batch - #GENERATED# |
| T028L | EB: Sender Bank - CM Data |
| T035T | Planning Group Texts |
| TFTE_BSM_CUST | Customizing: Bank Statement Monitor |
| FAR_IPF_C_RJCTN | Customizing table for Payment Rejections |
| FEBKEY | ID administration |
| T028M | Class for alternative currency keys |
| FLQITEMC1_FC | Liquidity Calculation: Forecast from Securities |
| T037A | Archiving Categories |
| FDM2 | Cash management line items from MM purchase requisition |
| T034 | Cash Mgmt: Determine Account Assignments/Document Splitting |
| T036V | Allocation of planning levels for Financial Assets Mgmt |
| FDSB2 | CMF Totals Records for G/L Accounts (As of Release 604) |
| T028I | Text Table for T028H |
| FAR_IPF_T_FORMAT | Text table for FAR_IPF_C_FORMAT |
| T243LS | Logging Table for Distributed CM Data |
| FDSRDIST | Cash management totals records for planning groups (distbd) |
| FDM1 | Cash Management & Forecast: Line Items of MM Documents |