# SAP FICO Database Tables Reference (BKPF, BSEG, ACDOCA and More) > Source: https://netray.co/tools/sap-fico-database-tables-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A lookup of the standard finance and controlling tables used in reports, extracts and SE16N queries, with module and what each stores. ## Category sap ## Erp SAP ECC / S/4HANA ## Audience - SAP FICO consultant - ABAP developer - Finance data analyst ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Table **Key:** table **Type:** text #### Area **Key:** area **Type:** text #### What it stores **Key:** description **Type:** text **Rows:** **Table:** BKPF **Area:** FI **Description:** Accounting document header (company code, document number, fiscal year, posting date, document type) **Table:** BSEG **Area:** FI **Description:** Accounting document segment (line items); in S/4HANA a compatibility view over ACDOCA and other tables **Table:** BSIK **Area:** FI-AP **Description:** Vendor open items (secondary index) **Table:** BSAK **Area:** FI-AP **Description:** Vendor cleared items (secondary index) **Table:** BSID **Area:** FI-AR **Description:** Customer open items (secondary index) **Table:** BSAD **Area:** FI-AR **Description:** Customer cleared items (secondary index) **Table:** BSIS **Area:** FI-GL **Description:** G/L account open items (secondary index) **Table:** BSAS **Area:** FI-GL **Description:** G/L account cleared items (secondary index) **Table:** ACDOCA **Area:** S/4HANA **Description:** Universal journal line items for FI, CO, asset accounting and Material Ledger **Table:** FAGLFLEXA **Area:** FI-GL **Description:** New General Ledger actual line items (ECC with new GL) **Table:** FAGLFLEXT **Area:** FI-GL **Description:** New General Ledger totals **Table:** GLT0 **Area:** FI-GL **Description:** G/L account totals in classic General Ledger **Table:** SKA1 **Area:** FI-GL **Description:** G/L account master, chart of accounts level **Table:** SKB1 **Area:** FI-GL **Description:** G/L account master, company code level **Table:** SKAT **Area:** FI-GL **Description:** G/L account texts **Table:** T001 **Area:** Org **Description:** Company codes **Table:** T001W **Area:** Org **Description:** Plants and branches **Table:** T003 **Area:** FI config **Description:** Document types **Table:** TBSL **Area:** FI config **Description:** Posting keys **Table:** TCURR **Area:** FI config **Description:** Exchange rates **Table:** LFA1 **Area:** FI-AP **Description:** Vendor master, general data **Table:** LFB1 **Area:** FI-AP **Description:** Vendor master, company code data **Table:** KNA1 **Area:** FI-AR **Description:** Customer master, general data **Table:** KNB1 **Area:** FI-AR **Description:** Customer master, company code data **Table:** ANLA **Area:** FI-AA **Description:** Asset master record segment **Table:** ANLZ **Area:** FI-AA **Description:** Asset time-dependent allocations (cost center, location) **Table:** ANLC **Area:** FI-AA **Description:** Asset value fields by fiscal year and depreciation area **Table:** ANEP **Area:** FI-AA **Description:** Asset line items **Table:** TKA01 **Area:** CO **Description:** Controlling areas **Table:** CSKS **Area:** CO-OM-CCA **Description:** Cost center master data **Table:** CSKT **Area:** CO-OM-CCA **Description:** Cost center texts **Table:** CSSL **Area:** CO-OM-CCA **Description:** Cost center and activity type combinations **Table:** CSLA **Area:** CO-OM-CCA **Description:** Activity type master data **Table:** COBK **Area:** CO **Description:** CO object document header **Table:** COEP **Area:** CO **Description:** CO object line items (by period) **Table:** COSP **Area:** CO **Description:** CO object totals, external postings (primary costs) **Table:** COSS **Area:** CO **Description:** CO object totals, internal postings (secondary costs) **Table:** AUFK **Area:** CO-OM-OPA **Description:** Order master data (internal and production orders) **Table:** KEKO **Area:** CO-PC **Description:** Product costing header **Table:** CKIS **Area:** CO-PC **Description:** Items of the unit costing and product costing **Table:** MBEW **Area:** MM/FI **Description:** Material valuation (price, price control, valuation class) **Table:** CEPC **Area:** CO-PCA **Description:** Profit center master data **Notes:** Several of these tables behave differently in S/4HANA, where line item data lives in ACDOCA and older tables such as BSEG, BSIK and GLT0 may be compatibility views or empty. Confirm in SE11 for your release before building extracts. ## Content **Intro:** When a report is missing or a reconciliation does not tie, someone ends up in SE16N asking which table holds the data. This reference lists the standard FI, AA and CO tables with module and purpose so you can pick the right one first time. **Sections:** #### How to use the table **Body:** Search by table name or by what you want to find, for example open items or cost center. Open the table in SE11 to confirm the fields in your release, then query it in SE16N or an ABAP report. Export the filtered list as a team reference when you design extracts. **Bullets:** - BKPF plus BSEG joins on company code, document number and fiscal year. - Open and cleared items live in separate index tables (BSIK and BSAK). - Check client (MANDT) handling when you extract data. #### Header, line item and index tables **Body:** The classic FI model stores one header in BKPF and many lines in BSEG. For speed SAP duplicates open and cleared items into index tables by account type: BSIS and BSAS for G/L, BSIK and BSAK for vendors, BSID and BSAD for customers. When an item is cleared it moves from the open table to the cleared table. Reports that need open items at a past date must therefore read both tables and filter on clearing date. #### S/4HANA and the universal journal **Body:** In S/4HANA, ACDOCA is the single line item table for G/L, CO, asset accounting and Material Ledger. Totals tables such as GLT0 and COSP are replaced by views or calculated on the fly. If you are migrating custom reports, rebuild them on ACDOCA or the standard CDS views rather than on legacy tables that exist only as compatibility objects. #### Common mistakes **Body:** A frequent error is reading BSEG without restricting company code and fiscal year, which is slow on large databases. Another is forgetting that CO line items sit in COEP by period and require COBK for the header. Developers also forget that texts live in separate tables, such as SKAT and CSKT, and need the language key in the join. **Cta:** If your analysts spend hours on table joins for each new finance question, a read-only natural-language layer over your SAP data can show the generated query alongside the answer. Netray can discuss what that looks like in your landscape. **Faq:** #### What is the difference between BSEG and ACDOCA? **Answer:** BSEG is the classic accounting document line item table. In S/4HANA, ACDOCA is the universal journal that holds all finance line items, and BSEG is provided as a compatibility view. New reports should read ACDOCA or the standard CDS views. #### Why are open items in BSIK and not BSEG? **Answer:** BSIK is an index table for vendor open items that SAP keeps for fast access. Reading BSEG for every open item scan would be slow. When items are cleared they move to BSAK. #### Where are cost center names stored? **Answer:** Cost center master data is in CSKS, with descriptions in CSKT by language and validity date. Join on controlling area, cost center and the validity range when you build a report. #### Is this list complete? **Answer:** No. It covers the core tables most FICO reports touch. Use SE11, SE16N or the data dictionary for the full picture in your own system. ## Search terms sap fico tables list, sap bkpf bseg tables, sap acdoca table fields, sap fi tables bsik bsid bsak, sap co tables coep cobk, sap cost center table csks, sap finance tables for reporting, sap fi table names excel --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json