List of Important SAP FI Tables (SAP Finance Tables)

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

SAP FI Tables: Master Data

SAP Tables for G/L Accounts

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

SAP Customer Master Data Tables

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	Contact persons
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

SAP Vendor Master Data Tables

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

SAP BANK TABLES

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 FI Tables for Accounting document

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)

For more detail on Invoice Tables in SAP check The Main SAP Invoice Table for Accounting Document and Material Document

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 Tables and Relationship
SAP Transparent table database

SAP Payment Tables

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

SAP FI Customizing Tables

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.

SAP Company code 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

You may check also List of Important SAP FI Tables (SAP Finance Tables)

SAP FI Document Customizing Tables

SAP FI DOC. CUSTO	DESCRIPTION
T010O	Posting period variant
T010P	Posting Period Variant Names
T001B	Permitted Posting Periods
T003	Document types
T012	House banks

SAP Taxes Tables

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