List of Important SAP FI Tables (SAP Finance Tables)

SAP FI 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.

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 TABLESSAP FI TablesMAIN FIELDS
SKA1G/L Accounts (Chart of Accounts)KTOPL /SAKNR
SKATDescription G/L Accounts (Chart of Accounts)
SKB1G/L Accounts (Company Code)BUKRS / SAKNR
SKM1Sample G/L accounts
SKMTSample G/L accounts Text
SKASG/L Account Master (Chart of Accounts)SPRAS / KTOPL / SAKNR / SCHLW
TSAKRCreate G/L account with referenceBUKRS / SAKNR

SAP Customer Master Data Tables

Here the list of the main Tables for Customer Master Data in SAP

SAP CUSTOMER TABLESSAP FI TablesIMPORTANT FIELDS
KNA1Customer masterKUNNR
KNB1Customer / companyKUNNR / BUKRS
KNVVCustomer sales data
KNBKBank detailsKUNNR / BANKS / BANKL / BANKN
KNVHCustomer hierarchy
KNVPCustomer partners
KNVSShipment data for customer
KNVKContactpersons
KNVICustomer master tax indicator
KNC1Customer Master Transaction FiguresKUNNR / BUKRS / GJHAR
KNC3Customer Master Special GL TransactionsKUNNR / 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 TABLESDESCRIPTIONMAIN FIELDS
LFA1Vendor masterLIFNR
LFB1Vendor per company codeLIFNR / BUKRS
LFB5Vendor dunning data
LFM1Purchasing organisation data
LFM2Purchasing data
LFBKBank details

SAP BANK TABLES

The main Bank Tables in SAP are:

SAP VENDOR TABLESSAP FI Tables
BNKAMaster bank data
T012-THouse Banks T012A / B Allocation pmnt methods -> Bank transfer
T012CTerms for bank transactions
T012DParameter for DMEs and foreign PM
T012EEDI-compatible house banks / PM
T012KHouse Bank Accounts
T012OORBIAN Detail: Bank Accounts
TIBANIBAN (International Bank Account Number)

You may check SAP CRM Business Partner Banking Detail

SAP FI Tables for Accounting document

SAP ACCOUNTING DOCUMENTSAP FI TablesMAIN FIELDS
BKPFAccounting documentsBUKRS / BELNR / GJAHR
BSEGItem levelBUKRS / BELNR / GJAHR / BUZEI
BSIDAccounting: Secondary index for customers
BSIKAccounting: Secondary index for vendors
BSIMSecondary Index Documents for Material
BSIPIndex for vendor validation of double documents
BSISAccounting: Secondary index for G/L accounts
BSADAccounting: Index for customers (cleared items)
BSAKAccounting: Index for vendors (cleared items)
BSASAccounting: 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 TABLESSAP FI Tables
REGUHSettlement data from payment program
REGUPProcessed items from payment program
REGUTTemSe – Administration Data
T042Parameters for payment transactions
T042ABank selection for payment program
T042BDetails on the company codes that pay
T042CTechnical Settings: payment program
T042DAvailable amounts for payment program
T042ECompany code-specific: payment methods
T042F / HPayment method supplements
T042GGroups of company codes (payment program)
T042IAccount determination for payment program
T042JBank charges determination
T042KAccounts for bank charges
T042N/ L Bank transaction codes
T042SCharges/expenses for automatic pmnt transactions
T042VValue date for automatic payments
T042WPermitted currency keys for payment method
T042ZPayment method for automatic payment
T008Blocking 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 TABLESDESCRIPTION
T004Chart of accounts
T077SAccount group (g/l accounts)
T009Fiscal year variants
T880Global company data
T014Credit control area

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

SAP FI Document Customizing Tables

SAP FI DOC. CUSTODESCRIPTION
T010OPosting period variant
T010PPosting Period Variant Names
T001BPermitted Posting Periods
T003Document types
T012House banks

SAP Taxes Tables

If you want to go furthuer with SAP FI Tcodes, here the most important SAP Taxes Transaction Codes :

TABLESAP Taxes Tables
T059AType of Recipient for Vendors
T059BType of Recipient for Vendors
T059CType of Recipient for Vendors per Withholding Tax Type
T059DType of Recipient for Vendors per Withholding Tax Type
T059EIncome Types T059F Formulas for Calc. Withholding Tax
T059GIncome Types T059F Formulas for Calc. Withholding Tax
T059KWithholding tax code; process. key
T059PWithholding tax types / tax code
T059ZWithholding tax types / tax code
T007ATax Keys
T007STax Keys
T007BTax Processing in Accounting