SAP FI Tables regroups the list of the main tables for Finance Module in SAP.
The SAP Finance tables list are classified by topics to easy find the relevant tables you are looking for.
Table of Contents
G/L account master records contain the data that is always needed by the General Ledger to determine the account’s function.
The G/L account master records control the posting of accounting transactions to G/L accounts and the processing of the posting data. (source)
| SAP G/L ACCOUNTS TABLES | SAP FI Tables | MAIN FIELDS |
|---|---|---|
| SKA1 | G/L Accounts (Chart of Accounts) | KTOPL /SAKNR |
| SKAT | Description G/L Accounts (Chart of Accounts) | |
| SKB1 | G/L Accounts (Company Code) | BUKRS / SAKNR |
| SKM1 | Sample G/L accounts | |
| SKMT | Sample G/L accounts Text | |
| SKAS | G/L Account Master (Chart of Accounts) | SPRAS / KTOPL / SAKNR / SCHLW |
| TSAKR | Create G/L account with reference | BUKRS / SAKNR |
Here the list of the main Tables for Customer Master Data in SAP
| SAP CUSTOMER TABLES | SAP FI Tables | IMPORTANT FIELDS |
|---|---|---|
| KNA1 | Customer master | KUNNR |
| KNB1 | Customer / company | KUNNR / BUKRS |
| KNVV | Customer sales data | |
| KNBK | Bank details | KUNNR / BANKS / BANKL / BANKN |
| KNVH | Customer hierarchy | |
| KNVP | Customer partners | |
| KNVS | Shipment data for customer | |
| KNVK | Contactpersons | |
| KNVI | Customer master tax indicator | |
| KNC1 | Customer Master Transaction Figures | KUNNR / BUKRS / GJHAR |
| KNC3 | Customer Master Special GL Transactions | KUNNR / BUKRS / GJAHR / SHBKZ |
The Customer Material Info Record is stored at the tables
KNMT – Customer material info record
For the full list of SAP Customer Tables check SAP KNVV: Customer Master Sales Data
For Vendor Master Data, you can check the following Tables
| SAP VENDOR TABLES | DESCRIPTION | MAIN FIELDS |
|---|---|---|
| LFA1 | Vendor master | LIFNR |
| LFB1 | Vendor per company code | LIFNR / BUKRS |
| LFB5 | Vendor dunning data | |
| LFM1 | Purchasing organisation data | |
| LFM2 | Purchasing data | |
| LFBK | Bank details |
The main Bank Tables in SAP are:
| SAP VENDOR TABLES | SAP FI Tables |
|---|---|
| BNKA | Master bank data |
| T012-T | House Banks T012A / B Allocation pmnt methods -> Bank transfer |
| T012C | Terms for bank transactions |
| T012D | Parameter for DMEs and foreign PM |
| T012E | EDI-compatible house banks / PM |
| T012K | House Bank Accounts |
| T012O | ORBIAN Detail: Bank Accounts |
| TIBAN | IBAN (International Bank Account Number) |
You may check SAP CRM Business Partner Banking Detail
| SAP ACCOUNTING DOCUMENT | SAP FI Tables | MAIN FIELDS |
|---|---|---|
| BKPF | Accounting documents | BUKRS / BELNR / GJAHR |
| BSEG | Item level | BUKRS / BELNR / GJAHR / BUZEI |
| BSID | Accounting: Secondary index for customers | |
| BSIK | Accounting: Secondary index for vendors | |
| BSIM | Secondary Index Documents for Material | |
| BSIP | Index for vendor validation of double documents | |
| BSIS | Accounting: Secondary index for G/L accounts | |
| BSAD | Accounting: Index for customers (cleared items) | |
| BSAK | Accounting: Index for vendors (cleared items) | |
| BSAS | Accounting: Index for G/L accounts (cleared items) |
Check this Book SAP Tables and Relation:
A 74 page of beautiful pdf presentation document which explain all the major SAP tables and their relationship and SAP 95000+ transparent tables excel database for reference.
| SAP PAYMENT RUN TABLES | SAP FI Tables |
|---|---|
| REGUH | Settlement data from payment program |
| REGUP | Processed items from payment program |
| REGUT | TemSe – Administration Data |
| T042 | Parameters for payment transactions |
| T042A | Bank selection for payment program |
| T042B | Details on the company codes that pay |
| T042C | Technical Settings: payment program |
| T042D | Available amounts for payment program |
| T042E | Company code-specific: payment methods |
| T042F / H | Payment method supplements |
| T042G | Groups of company codes (payment program) |
| T042I | Account determination for payment program |
| T042J | Bank charges determination |
| T042K | Accounts for bank charges |
| T042N | / L Bank transaction codes |
| T042S | Charges/expenses for automatic pmnt transactions |
| T042V | Value date for automatic payments |
| T042W | Permitted currency keys for payment method |
| T042Z | Payment method for automatic payment |
| T008 | Blocking reasons for automatic pmnt transactions |
In this part, we will detail the list of important Tables for Finance Customizing.
First we will start with Company code Tables, then we will list the main Finance Document Customizing Tables.
| COMPANY CODE TABLES | DESCRIPTION |
|---|---|
| T004 | Chart of accounts |
| T077S | Account group (g/l accounts) |
| T009 | Fiscal year variants |
| T880 | Global company data |
| T014 | Credit control area |
| SAP FI DOC. CUSTO | DESCRIPTION |
|---|---|
| T010O | Posting period variant |
| T010P | Posting Period Variant Names |
| T001B | Permitted Posting Periods |
| T003 | Document types |
| T012 | House banks |
If you want to go furthuer with SAP FI Tcodes, here the most important SAP Taxes Transaction Codes :
| TABLE | SAP Taxes Tables |
|---|---|
| T059A | Type of Recipient for Vendors |
| T059B | Type of Recipient for Vendors |
| T059C | Type of Recipient for Vendors per Withholding Tax Type |
| T059D | Type of Recipient for Vendors per Withholding Tax Type |
| T059E | Income Types T059F Formulas for Calc. Withholding Tax |
| T059G | Income Types T059F Formulas for Calc. Withholding Tax |
| T059K | Withholding tax code; process. key |
| T059P | Withholding tax types / tax code |
| T059Z | Withholding tax types / tax code |
| T007A | Tax Keys |
| T007S | Tax Keys |
| T007B | Tax Processing in Accounting |
December 22, 2020 November 7, 2021
November 28, 2019 January 21, 2020
SAP Accounts Payable Tcodes & Accounts Receivable Tcodes ( SAP FI AP & AR Tcodes)" width="348" height="205" />
August 1, 2019 May 5, 2020
