SAP ERP provides a variety of tables in its Finance (FI) module to manage and analyze financial transactions. These tables store data for general ledger (G/L), accounts payable (AP), accounts receivable (AR), asset accounting (AA), and controlling (CO). Below is a categorized list of important tables in the SAP FI module:
1. General Ledger (G/L) Accounting Tables
Table Name Description
BKPF Document Header Table (stores metadata for financial documents like date, type, user, etc.)
BSEG Document Line Items Table (stores transactional line items for G/L, AR, AP, etc.)
SKA1 G/L Account Master (Chart of Accounts)
SKB1 G/L Account Master (Company Code Level)
BSIS G/L Open Items
BSAS G/L Cleared Items
2. Accounts Payable (AP) Tables
Table Name Description
LFA1 Vendor Master (General Data)
LFB1 Vendor Master (Company Code Level)
LFC1 Vendor Transaction Figures
BSAK Cleared Vendor Items
BSIK Open Vendor Items
PAYR Payment Document Information
3. Accounts Receivable (AR) Tables
Table Name Description
KNA1 Customer Master (General Data)
KNB1 Customer Master (Company Code Level)
KNKK Customer Credit Management Data
DPSHP Customer Payment History
BSID Open Customer Items
BSAD Cleared Customer Items
4. Asset Accounting (AA) Tables
Table Name Description
ANLA Asset Master Record
ANLB Asset Master Record (Depreciation Areas)
ANLC Asset Values
ANEA Asset Line Items
ANEP Asset Line Items (Depreciation)
ANKA Asset Classes
5. Controlling (CO) Tables
Table Name Description
COEP Controlling Document Line Items
COSS Cost Totals for Cost Centers
CSKS Cost Center Master Data
CSKT Cost Center Descriptions
COSP Cost Totals for Internal Orders
AUFK Internal Orders Master Data
6. Financial Reporting Tables
Table Name Description
GLT0 G/L Account Balances
GLPCA Profit Center Accounting Line Items
FAGLFLEXA General Ledger (New) - Line Items
FAGLFLEXT General Ledger (New) - Totals
FAGLFLEXP General Ledger (New) - Planning
7. Tax Tables
Table Name Description
T001 Company Codes
T007A Tax Codes
T007S Tax Rates
BSET Tax Data Document Segment
8. Bank Accounting Tables
Table Name Description
BNKA Bank Master Data
FEBKO Bank Statement Header Data
FEBEP Bank Statement Line Items
PAYR Payment Data
9. Integration with Other Modules
Table Name Description
EKBE Goods Receipt/Invoice Receipt (MM Integration)
COBK Controlling Documents
RBKP Invoice Document Header (MM Integration)
BKPF Cross-Module Financial Document Header
Example Use Cases with Tables
1. View Open Customer Invoices:
• Tables: BSID, KNA1, KNB1
2. Analyze G/L Account Balances:
• Tables: GLT0, SKA1, SKB1
3. Track Vendor Payments:
• Tables: LFA1, BSIK, BSAK, PAYR
4. Asset Depreciation Analysis:
• Tables: ANLC, ANEP, ANEA
5. Cost Center Reporting:
• Tables: CSKS, CSKT, COSS
Let me know if you need specific queries, table relationships, or schema diagrams!