Here is the list of important SAP FI tables for reference. Here we are categorized the tables like customers, vendors, assets etc for easy to understand.
Customer Tables | Vendor Tables | G/L account Tables | Asset Tables | Dunning Tables
Accounting tables (General)
- BKPF: Accounting Document Header
- EBKPF: External accounting document header
- BSEG: Accounting Document Segment
- BSEC: One-Time Account Data Document Segment
- BSIP: Double entry invoicing validation
- BVOR: Inter Company Posting Procedure
- KLPA: Linking between customer and vendor
- VBKPF: Document parking document header
- BLPK: Document log header
- BLPP: Document log item
- BNKA: Bank master record
Tables for Customer
- KNKA: Customer Master Credit Management (Central Data)
- KNKK: Customer Master Credit Management (Control Area Data)
- KNB4: History of Customer payment
- KNB5: Customer master record (Dunning data)
- KNBK: Customer master record (Bank details)
- KNC1: Customer master record (Transaction figures)
- KNC3: Customer master record (Special G/L Transaction figures)
- KNB1: Customer Master Record (Company Code)
- KNA1: General Data in Customer Master
- BSAD: Accounting- Secondary Index for Customers (Cleared Items)
- BSID: Accounting- Secondary Index for Customers
Tables for Vendor
- LFB5: Vendor Master Record (Dunning data)
- LFBK: Vendor Master Record (bank details)
- LFC1: Vendor Master Record (Transaction figures)
- LFC3: Vendor master record (Special G/L transaction figures)
- LFA1: Vendor Master record (General section)
- LFB1: Vendor master record (Company code)
- BSAK: Accounting- Secondary Index for Vendors (Cleared Items)
- BSIK: Accounting- Secondary Index for Vendors
Tables for G/L account
- VBSEGS: Document Segment for G/L Accounts Document Parking
- SKAT G/L Account Master Record (Chart of Accounts- Description)
- SKA1: G/L Account master record (Chart of accounts)
- SKAT: G/L Account master record (Chart of accounts description)
- SKAS: G/L Account master record (Chart of accounts – keyword lists)
- SKB1: G/L Account master record (Company code)
- KOMU: Account assignment templates for G/L items.
- BSIS: Accounting- Secondary Index for G/L Accounts
- BSAS: Accounting- Secondary Index for G/L Accounts (Cleared Items)
Tables for Asset
- VWPANLA: Asset master for securities
- TZPAT: Financial Assets Management product type texts
- ANAR: Asset Types
- ANAT: Asset type text
- ANEK: Document Header Asset Posting
- ANEP: Asset Line Items
- ANEV: Asset down payment settlement
- ANKT: Asset classes- Description
- ANLA: Asset Master Record Segment
- ANLB: Depreciation terms
- ANLC: Asset Value Fields
- ANLH: Main asset number
Dunning
- MAHNS: Accounts blocked by dunning selection
- MHNK: Dunning data
- MAHNV: Management Records for the Dunning Program
Also Read : SAP FI Tutorial -> FI SD Integration