Knowing the right SAP table saves hours when you debug a posting, build a report or check master data. This guide lists the most important SAP tables by module, explains what each one stores and flags what changed in SAP S/4HANA, where several classic tables were replaced by a single source of truth.
To browse any of these tables, use transaction SE16, SE16N or, better, SE16H, which lets you group, sum and join tables without writing code. To see the structure (fields, keys, check tables), use SE11.
Upgrading your desktop client? Here is how to handle the SAP GUI 8.10 download and installation.
Looking for the transactions that read and write these tables? See our SAP transaction codes list by module.
What changed in S/4HANA
- ACDOCA (Universal Journal) replaces the separate FI and CO line item and totals tables. G/L, CO, asset accounting and material ledger line items now live in one table.
- MATDOC replaces MKPF and MSEG for material documents. The old names still exist as compatibility views, so old reports keep working.
- Business Partner (BUT000) is mandatory for customers and vendors. KNA1 and LFA1 still exist and are filled through Customer/Vendor Integration (CVI).
- Index tables like BSID, BSAD, BSIK, BSAK, BSIS and BSAS are now compatibility views on top of ACDOCA/BSEG, not physical tables.
- Pricing conditions moved from KONV to PRCD_ELEMENTS.
SAP FI tables (Financial Accounting)
| Table | Description |
|---|---|
| ACDOCA | Universal Journal line items (S/4HANA) |
| BKPF | Accounting document header |
| BSEG | Accounting document line items (entry view) |
| BSID / BSAD | Customer open / cleared items |
| BSIK / BSAK | Vendor open / cleared items |
| BSIS / BSAS | G/L account open / cleared items |
| SKA1 / SKB1 | G/L account master (chart of accounts / company code) |
| T001 | Company codes |
| T001B | Posting periods (OB52) |
| TCURR | Exchange rates (OB08) |
| BNKA | Bank master (bank directory) |
| T012 / T012K | House banks / house bank accounts |
| REGUH / REGUP | Payment run header / items (F110) |
| PAYR | Payment medium file (cheques) |
| FEBKO / FEBEP | Electronic bank statement header / items |
| ANLA / ANLZ | Asset master / time-dependent asset data |
| FAGLFLEXT | New G/L totals (ECC; replaced by ACDOCA in S/4HANA) |
Tip: in S/4HANA, if you need a trial balance or line item analysis, query ACDOCA directly. It already contains ledger, company code, profit center, cost center, segment and functional area in one row.
SAP CO tables (Controlling)
| Table | Description |
|---|---|
| CSKS / CSKT | Cost center master / texts |
| CSKA / CSKB | Cost elements (in S/4HANA cost elements are G/L accounts) |
| CEPC / CEPCT | Profit center master / texts |
| AUFK | Internal and production order master |
| COEP | CO line items (ECC; ACDOCA in S/4HANA) |
| COSP / COSS | CO totals primary / secondary (ECC) |
| PROJ / PRPS | Project definition / WBS elements (PS) |
SAP MM tables (Materials Management)
| Table | Description |
|---|---|
| MARA | General material data |
| MAKT | Material descriptions |
| MARC | Plant data for material |
| MARD | Storage location data for material |
| MBEW | Material valuation |
| EBAN | Purchase requisitions |
| EKKO / EKPO | Purchasing document header / items |
| EKET | PO schedule lines |
| EKBE | Purchase order history |
| EINA / EINE | Purchasing info record (general / org level) |
| MATDOC | Material documents (S/4HANA) |
| MKPF / MSEG | Material document header / items (ECC; views in S/4HANA) |
| RBKP / RSEG | Supplier invoice header / items (MIRO) |
| LFA1 / LFB1 / LFM1 | Vendor general / company code / purchasing org data |
SAP SD tables (Sales and Distribution)
| Table | Description |
|---|---|
| VBAK / VBAP | Sales document header / items |
| VBEP | Sales document schedule lines |
| VBPA | Sales document partners |
| VBFA | Sales document flow |
| LIKP / LIPS | Delivery header / items |
| VBRK / VBRP | Billing document header / items |
| KNA1 / KNB1 / KNVV | Customer general / company code / sales area data |
| KONV | Pricing conditions (ECC) |
| PRCD_ELEMENTS | Pricing conditions (S/4HANA) |
| A-tables (A004, A005…) | Condition records access tables |
SAP PP tables (Production Planning)
| Table | Description |
|---|---|
| AFKO / AFPO | Production order header / items |
| AFVC | Order operations |
| RESB | Reservations / dependent requirements |
| MAST / STKO / STPO | Material to BOM link / BOM header / BOM items |
| PLKO / PLPO | Routing header / operations |
| CRHD | Work center header |
Business Partner tables (S/4HANA)
| Table | Description |
|---|---|
| BUT000 | Business Partner general data |
| BUT020 | BP addresses link |
| BUT100 | BP roles |
| BUT0BK | BP bank details |
| CVI_CUST_LINK / CVI_VEND_LINK | Link between BP and customer / vendor |
| ADRC | Central address data |
SAP HR / HCM tables
| Table | Description |
|---|---|
| PA0000 | Infotype 0000 – Actions |
| PA0001 | Infotype 0001 – Organizational assignment |
| PA0002 | Infotype 0002 – Personal data |
| PA0008 | Infotype 0008 – Basic pay |
| HRP1000 / HRP1001 | Org management objects / relationships |
Basis and ABAP tables
| Table | Description |
|---|---|
| USR02 | User logon data |
| AGR_USERS | Role assignments to users |
| AGR_1251 | Authorization data per role |
| TSTC / TSTCT | Transaction codes / texts |
| TADIR | Repository objects directory |
| E070 / E071 | Transport requests header / objects |
| DD02L / DD03L | Table definitions / table fields |
| TBTCO / TBTCP | Background job header / steps |
Want to create your own Z table? Follow our step-by-step guide: Create SAP custom table. For background jobs, see How to schedule a job in SAP.
How to find the table behind any SAP field
- Place the cursor on the field in any SAP GUI screen and press F1.
- Click Technical Information. You will see the table or structure and the field name.
- If it shows a screen structure, use the SE11 where-used list or an SQL trace (ST05) to find the underlying database table.
In SAP Fiori, open the app and use About or the app’s technical information in the user menu to find the underlying CDS view, which you can then inspect in ADT (Eclipse).
FAQ
Is BSEG still used in S/4HANA?
Yes. BSEG still stores the entry view of accounting documents, but the leading source for reporting is ACDOCA.
Which table stores material documents in S/4HANA?
MATDOC. MKPF and MSEG remain as compatibility views.
Where are customers and vendors stored in S/4HANA?
In the Business Partner tables (BUT000 and related), synchronized with KNA1/LFA1 through CVI.
