The SAP Financial Accounting (FI) module is one of the core components of SAP ERP. It manages a company’s financial transactions, general ledger, accounts payable, accounts receivable, and asset accounting. As a beginner in SAP FI, knowing the key tables helps you understand how data is stored and retrieved for reports and integrations.
Here’s a complete list of the most important SAP FI tables every beginner should know — grouped by functional area.
1. General Ledger (G/L) Accounting
| Table | Description |
|---|---|
| BKPF | Accounting Document Header – Stores document header information like company code, posting date, document type. |
| BSEG | Accounting Document Line Item – Contains detailed line items for each document (G/L, vendor, customer entries). |
| BSIS | G/L Account Line Items (Open) – Stores open items for G/L accounts. |
| BSAS | G/L Account Line Items (Cleared) – Stores cleared G/L account line items. |
| SKA1 | G/L Account Master (Chart of Accounts) – Holds account master data at chart of accounts level. |
| SKB1 | G/L Account Master (Company Code) – Contains company code–specific G/L account data. |
Tip: Always join BKPF and BSEG using the fields BELNR (Document Number), BUKRS (Company Code), and GJAHR (Fiscal Year).
Also Read: SAP Business Data Cloud Cockpit Tutorial – Step-by-Step Guide
2. Accounts Payable (Vendor Accounting)
| Table | Description |
|---|---|
| LFA1 | Vendor Master (General Data) – Holds general information about vendors (name, address, tax info). |
| LFB1 | Vendor Master (Company Code Data). |
| LFBK | Vendor Bank Details. |
| BSAK | Vendor Cleared Items. |
| BSAK | Vendor Open Items. |
| BSIK | Vendor Open Items (Accounting Data). |
| BSAK | Vendor Cleared Items (Accounting Data). |
| BKPF/BSEG | Used together to view vendor postings. |
Common Join Example:
To view vendor line items with header details → join BKPF, BSEG, and LFA1 using LIFNR.
3. Accounts Receivable (Customer Accounting)
| Table | Description |
|---|---|
| KNA1 | Customer Master (General Data). |
| KNB1 | Customer Master (Company Code Data). |
| KNBK | Customer Bank Details. |
| BSID | Customer Open Items. |
| BSAD | Customer Cleared Items. |
You can also find customer transactions in BSEG (where KOART = D).
Also Read: Substring in SAP HANA Calculated Column – Example and Syntax
4. Asset Accounting (FI-AA)
| Table | Description |
|---|---|
| ANLA | Asset Master Record (General Data). |
| ANLB | Depreciation Areas. |
| ANLC | Asset Value Fields (Yearly Values). |
| ANEP | Asset Line Items (Posted Depreciation/Transactions). |
| ANEK | Asset Document Header. |
These tables help track assets, acquisitions, transfers, and depreciation postings.
5. Controlling (Integration with FI)
| Table | Description |
|---|---|
| COEP | CO Object Line Items (Actual). |
| COSP | CO Object: Cost Totals (Plan Data). |
| CSKS | Cost Center Master (General Data). |
| CSKT | Cost Center Texts. |
Even though these belong to Controlling (CO), they are often used in FI-CO reporting.
6. Tax and Withholding Information
| Table | Description |
|---|---|
| A003/A053 | Tax Code – Material/Account Assignments. |
| BSET | Tax Data Document Segment (Stores tax amounts per document line). |
| T007A | Tax Codes. |
7. Document and Posting Control Tables
| Table | Description |
|---|---|
| T001 | Company Codes. |
| T003 | Document Types. |
| T004 | Chart of Accounts. |
| T012 | House Banks. |
| TBSL | Posting Keys. |
8. Payment and Dunning
| Table | Description |
|---|---|
| REGUH | Payment Program – Payment Data (Header). |
| REGUP | Payment Program – Payment Data (Items). |
| BNKA | Bank Master Data. |
| DFKKKO/DFKKOP | Open and Cleared Items (in Contract Accounting). |
9. Special Purpose Ledger and Others
| Table | Description |
|---|---|
| GLT0 | G/L Account Balances. |
| FAGLFLEXT | General Ledger Totals (New G/L). |
| FAGLFLEXA | Actual Line Items (New G/L). |
| FAGLFLEXP | Plan Line Items. |
For New General Ledger, you primarily use FAGLFLEXA instead of BSIS/BSAS.
Summary
Here’s a simplified summary of essential SAP FI tables for beginners:
| Area | Key Tables |
|---|---|
| General Ledger | BKPF, BSEG, SKA1, SKB1, BSIS, BSAS |
| Vendor (AP) | LFA1, LFB1, BSIK, BSAK |
| Customer (AR) | KNA1, KNB1, BSID, BSAD |
| Assets | ANLA, ANLB, ANLC, ANEP |
| Taxes | BSET, T007A |
| Payment | REGUH, REGUP |
| Balances | GLT0, FAGLFLEXA, FAGLFLEXT |
Best Practice for Beginners
- Start with BKPF and BSEG — they are the foundation of every FI document.
- Use SE11 or SE16N transactions in SAP to view table contents.
- Always filter by company code (BUKRS) and fiscal year (GJAHR) when testing queries.
- Learn how FI integrates with CO, MM, and SD — because many postings are cross-module.
In short: These essential FI tables form the backbone of SAP’s financial data model. Mastering them helps you analyze, report, and troubleshoot financial transactions effectively.