The most important SAP Finance and Controlling (FI/CO) tables for users of Alteryx, KNIME, Power BI, Tableau & Snowflake

​In this blog we identify the most important SAP Finance and Controlling (FI/CO) tables for users of:

• Alteryx and the DVW Alteryx Connector for SAP
• KNIME and the DVW KNIME Connector for SAP
• Power BI and the DVW Power BI Connector for SAP
• Tableau and the DVW Tableau Connector for SAP
• Snowflake and the DVW Snowflake Connector for SAP

SAP Finance and Controlling tables are found in the following SAP systems:

• SAP ECC 
• SAP ERP
• SAP S/4HANA

The "Big Two" SAP Financial Accounting (FI) Transaction Data Tables

• BKPF - Accounting Document Header
• BSEG - ​Accounting Document Segment

Table BKPF holds the Header data for all Financial transactions in SAP while table BSEG holds the Segment or Item data for all Financial transaction in SAP.  ​In Alteryx you will typically extract data from both tables in order to get the full picture for a Financial transaction.

There are a number of other SAP Financial Accounting transaction tables that can be used in association with BKPF and BSEG. 

The following tables can be used with BKPF:

• BVOR - Intercompany posting procedures
• BSIP - Index for Vendor Validation of Double Documents (Note: "Double" means Duplicate)

The following tables can be used with BSEG:

• 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) 

In addition to the above the following SAP Financial Accounting transaction tables are useful to know:

• BSEC - One-Time Account Data Document Segment
• ​BSET - Tax Data Document Segment

Tables BSEC and BSET can be used in association with table BKPF.

Key SAP Controlling (CO) Transaction Data 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

Important SAP Finance and Controlling (FI/CO) 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 Centre

• 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)

Useful SAP Finance and Controlling (FI/CO) Configuration Data Tables

• M_KOSTS - Generated View for Matchcode ID KOST-S (Cost Centre Texts)
• T001 - Company Codes
• T001K - Valuation area
• T077S - G/L account groups
• TBSL and TBSLT - Posting Key and Posting Key Names

SAP S/4HANA Finance Tables

• ACDOCA - Universal Journal Entry Line Items

With SAP S/4HANA, table ACDOCA contains all the Item data for Finance (Controlling (CO) and Asset Accounting (AA).

ACDOCA can be used as an alternative to:

• BSEG - Accounting Document Segment
• COEP - CO Object: Line Items (by Period)

Table BKPF still holds the Header data for all Financial transactions in SAP S/4HANA.

Other Sources of SAP Table Information

Google is your best friend when searching for SAP Table data. Give it a go!

GET A FREE TRIAL TODAY