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.
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:
The following tables can be used with 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:
Tables BSEC and BSET can be used in association with table BKPF.
- 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!