Important SAP FICO Tables

As an SAP FICO professional, mastering key tables is essential for effective data management and analysis. Check out this list of important SAP FICO tables for your reference:

📚 FI Transactional Tables:

ACDOCA: Universal Journal Entry Line Items

BSEG: Accounting Document Segment

BKPF: Accounting Document Header

BSID: Accounting - Secondary Index for Customers (Open Items)

BSAD: Accounting - Secondary Index for Customers (Cleared Items)

BSIK: Accounting - Secondary Index for Vendors (Open Items)

BSAK: Accounting - Secondary Index for Vendors (Cleared Items)

BSIS: Accounting - Secondary Index for G/L Accounts (Open Items)

BSAS: Accounting - Secondary Index for G/L Accounts (Cleared Items)

BSEC: One-Time Account Data Document Segment

BSET: Tax Data Document Segment

💹 CO Transactional Tables:

🏢 Cost Centre Accounting:

COBK: CO Object - Document Header

COEP: CO Object - Line Items (by Period)

COSP: CO Object - Cost Totals for External Postings

📊 Profit Centre Accounting:

GLPCC: EC-PCA - Transaction Attributes

GLPCO: EC-PCA - Object Table for Account Assignment Elements

GLPCA: EC-PCA - Actual Line Items

GLPCT: EC-PCA - Totals Table

📓 SAP FICO Master Data Tables:

📖 General Ledger:

SKA1: G/L Account Master (Chart of Accounts)

SKAT: G/L Account Master Record (Chart of Accounts: Description)

SKB1: G/L Account Master (Company Code)

🏢 Cost Centre:

CSKS: Cost Center Master Record

CSKT: Cost Center Texts

💰 Cost Element:

CSKA: Cost Elements (Data Dependent on Chart of Accounts)

CSKU: Cost Element Texts

CSKB: Cost Elements (Data Dependent on Controlling Area)

📈 Profit Center:

CEPC: Profit Center Master Data Table

CEPCT: Profit Center Master Data

📚 Accounts Payable - Vendor Master Data:

👤 Vendor Master - General Data:

LFA1: Vendor/Supplier Master (General Section)

LFBK: Vendor/Supplier Master (Bank Details)

🛒 Vendor Master - Purchasing Data:

LFM1: Vendor Master Record Purchasing Organization Data

LFM2: Vendor Master Record: Purchasing Data

💼 Vendor Master - Company Code Data:

LFB1: Vendor Master (Company Code)

LFB5: Vendor Master (Dunning Data)

📚 Accounts Receivable - Customer Master Data:

👤 Customer Master - General Data:

KNA1: General Data in Customer Master

🛍 Customer Master - Sales Area Data:

KNVP: Customer Master Partner Functions

KNVV: Customer Master Sales Data

💼 Customer Master - Company Code Data:

KNB1: Customer Master (Company Code)

KNB5: Customer Master (Dunning Data)