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)
UsefulSAP 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 Itemdata forFinance (Controlling (CO) and Asset Accounting (AA).
ACDOCAcan be used as an alternative to:
- BSEG - Accounting Document Segment
- COEP - CO Object: Line Items (by Period)
TableBKPF still holds the Header data for all Financial transactions inSAP S/4HANA.
Other Sources of SAP Table Information
Google is your best friend when searching for SAP Table data. Give it a go!