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. 

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 Description 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
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 Tables Description 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
KNC1Customer Master Transaction FiguresKUNNR / 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 Description
BNKA Master bank data
T012-THouse Banks T012A / B Allocation pmnt methods -> Bank transfer
T012CTerms for bank transactions
T012DParameter for DMEs and foreign PM
T012E EDI-compatible house banks / PM
T012KHouse Bank Accounts
T012O ORBIAN Detail: Bank Accounts
TIBANIBAN (International Bank Account Number)

You may check SAP CRM Business Partner Banking Detail

SAP FI Tables for Accounting documents

SAP Accounting Document Description Main Fields
BKPFAccounting documents BUKRS / 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

SAP Tables and Relation

 

 

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 Description
REGUHSettlement data from payment program
REGUPProcessed items from payment program
REGUT TemSe – 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 / H Payment method supplements
T042G Groups of company codes (payment program)
T042IAccount determination for payment program
T042JBank 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
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. Custo Description
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 :

SAP Taxes Table Description
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
T059K Withholding tax code; process. key
T059P Withholding tax types / tax code
T059Z Withholding tax types / tax code
T007A Tax Keys
T007S Tax Keys
T007BTax Processing in Accounting

 

Sab125

Hi. I have been working as SAP Technical and functional for a decade. Through this blog, I am trying to share with you my experience. Hopefull, it makes your ways easier path ...Sab