SAP Bank Accounting Tables
Are you looking for the right table related to SAP Bank Accounting 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 Bank Accounting (FI-BL) module.
Top 10 tables in Bank Accounting
| Table | Description |
|---|---|
| DFPAYG | Payment date: Grouping |
| T042FID | Payment medium formats: File ID modifiers |
| TFPM042FD | Payment Medium Formats: Preassignment of Format Parameters |
| TFCUPM042FZT | Payment medium formats: Supplement text |
| TFIBLSCREEN1T | Define Contents of Screen Groups |
| TFPM042FMC | Payment medium formats: Cust. reqd. fields for format para. |
| TFPM042FGC | Payt. medium formats: Cust. level of det. of payment mediums |
| TFPM042VI | Payment medium: Note to payee contents |
| TFPM042FM | Payment medium formats: Reqd fields for format parameters |
| TFPM042FZT | Payment medium formats: Supplement text |
List of tables in Bank Accounting
| Table | Description |
|---|---|
| DFPAYG | Payment date: Grouping |
| T042FID | Payment medium formats: File ID modifiers |
| TFPM042FD | Payment Medium Formats: Preassignment of Format Parameters |
| TFCUPM042FZT | Payment medium formats: Supplement text |
| TFIBLSCREEN1T | Define Contents of Screen Groups |
| TFPM042FMC | Payment medium formats: Cust. reqd. fields for format para. |
| TFPM042FGC | Payt. medium formats: Cust. level of det. of payment mediums |
| TFPM042VI | Payment medium: Note to payee contents |
| TFPM042FM | Payment medium formats: Reqd fields for format parameters |
| TFPM042FZT | Payment medium formats: Supplement text |
| TCCLGT | Payment cards: Settlement run log (texts) |
| REGUTA | Paying Company Codes for DME Files |
| TFPM042VAT | Payment medium: Note to payee texts |
| TFPM042VJ | Payment Media: Content of Note to Payee Lang. Independent |
| TFCUPM042FZ | Payment medium formats: Supplements |
| TFPM042FT | Payment medium formats: Texts |
| DFPAYHT | Note to Payee and Payment Advice Note Texts |
| T042T | Text modules for payment forms |
| TFPM042FBC | Payment medium formats: Customer events |
| TCCRCT | Payment cards: Results of checks (texts) |
| TFPM042FFC | Payment medium formats: Customer format parameters |
| TFPM042FPB | Payment Medium Formats: Modules for Payment Doc. Validation |
| TFPM042FC | Payment medium formats: Format codepage |
| CCENQ | Payment cards: Primary table for lock object EFCCENQ |
| TFPM042FV | Payment medium formats: Note to payee fields |
| TFPM042FDC | Payt Medium Formats: Cust. Preassignm. of Format Parameters |
| T042ZA | Additional specifications for payment method |
| BSEGC | Document: Data on Payment Card Payments |
| TCCLG | Payment Cards: Settlement Run Log |
| T042ZA_FORMAT | Different PMW Format |
| TFCUPM042F | Payment medium formats: General attributes |
| DFPAYMENT_KEY_ID | Contains ID for Payment Data Key |
| TFIBLSCREEN0 | Register Programs for Screen Control |
| TFCUPM042FV | Payment medium formats: Note to payee fields |
| TFCUPM042FD | Payment Medium Formats: Preassignment of Format Parameters |
| T042ZA_PREFTYP | Different PMW Format |
| TFPM042F | Payment medium formats: General attributes |
| TFPM042FF | Payment medium formats: Format parameters |
| TFPM042VA | Payment medium: Note to payee |
| REGUT | TemSe - Administration Data |
| TFIBLSCREEN1 | Define Contents of Screen Groups |
| DFPAY_XREL | Payment Medium Format: Selection variant Maintenance |
| TFCUPM042FT | Payment medium formats: Texts |
| DFPAYV | Payment Medium: Selection Variants |
| TFCUPM042FB | Payment medium formats: Events |
| DFPM_AUTH | Payment medium: Authorization Check Origin Active |
| FPS_BLOCK | Payment and Dunning Block for Each Payment Service Provider |
| TFCUPM042FF | Payment medium formats: Format parameters |
| T042ECT | Letter for Payment Correspondence (PDF) |
| TFCUPM042FM | Payment medium formats: Reqd fields for format parameters |
| DFPAYV_VARI | Variant |
| TCCAA | Payment cards: Clearing account/external functions |
| TCCFI | Payment cards: Central FI settings |
| TCJ_BALANCE | FI Cash Journal: Totals Records |
| TFPM042FL | Payment Medium Formats: Information on Lifecycle (SAP) |
| TFPM042FSB | Payment Medium Formats: Modules for Writing/Sending Files |
| DFPAY_DYN_SEL | Payment Medium Format: Dynamic Selections for Variant |
| TFPM042FZ | Payment medium formats: Supplements |
| TFPM042FB | Payment medium formats: Events |
| TFCUPM042FG | Payment medium formats: Level of detail of payment medium |
| TFIBLSCREEN | Control of Output of Screen Fields |
| TCCRC | Payment Cards: Check Results |
| TFPM042FG | Payment medium formats: Level of detail of payment medium |