SAP All Tables List — Complete SAP Table Reference Guide

8 min readApr 25, 2026

The IN SAP S/4 HANA and ECC All Tables List is one of the most important reference resources for any SAP professional — whether you are a developer (coder) writing ABAP reports, a functional consultant configuring modules, a basis administrator monitoring the system, or a business analyst End User extracting data for reporting. SAP ERP is built on a huge relational database containing thousands of tables that store every part of business data from material masters and sales orders to financial postings and human resource (HR) records. Knowing which table stores what data, what its key fields are, and which module it belongs to is a core skill that separates average SAP users from expert consultants. In this comprehensive SAP All Tables List guide, we cover every major module — MM, SD, FI, CO, HR, PP, WM, PM, and PS — with table names, full descriptions, and key fields so you can find exactly the data you need in SE11 or SE16.

Thousands of Tables

SAP ECC 6.0 / S/4HANA contains over 90,000 database tables across all modules and components.

SE11 — View Any Table

Use transaction SE11 to view table structure, fields, keys and foreign key relationships in any SAP system.

SE16 — Browse Data

Use SE16 or SE16N to browse live table data, filter by key fields and export results for analysis.

Quick Tip: In any SAP screen, press F1 on any field then click the Technical Information button to instantly find which table and field stores that data. This is the fastest way to discover table names while working in SAP transactions.

🛠️ How to Find and Use SAP Tables

Before plunging into the SAP All Tables List, it is important to understand how to actually access and work with these tables inside an SAP system. SAP provides several standard transactions specifically designed for working with database tables.

Transaction SE11 — ABAP Dictionary

SE11 is the ABAP Data Dictionary. It is the primary tool for viewing table metadata structure, fields, data types, key fields, foreign key relationships, and technical settings. Every SAP table in this list can be viewed in SE11. Simply enter the table name and press the Display button. You will see every field, its data type, length, and whether it is part of the primary key. SE11 also shows which tables a field references through foreign keys — this is how you understand table relationships and navigate between tables.

Transaction SE16 and SE16N — Table Browser

SE16 and its improved version SE16N allow you to browse live data stored inside any SAP table. Enter the table name, apply filters on key fields, and execute to retrieve rows of data. SE16N is recommended as it gives a more flexible interface with the ability to enter filter conditions on any field. Both transactions are read-only they cannot be used to change data — making them safe tools for data analysis and investigation.

Transaction SE16H — Table Analysis

SE16H is an enhanced version available in S/4HANA that supports joins, grouping, and aggregation directly from the browser interface. It is particularly useful for quickly analysing large datasets without writing ABAP code.

"Example: Select all records from MARA for a specific material SELECT * FROM mara INTO TABLE @lt_mara WHERE matnr = @lv_matnr.

📦 SAP MM Tables List — Materials Management

SAP Materials Management (MM) handles procurement, inventory management, and material master data. MM is one of the most table-rich modules in SAP because it manages the full lifecycle of materials from procurement through to stock management and invoice verification. The most important tables in SAP MM are MARA, MARC, MARD, MAKT, EKKO, EKPO, MSEG, and MKPF.

Material Master Tables

The material master in SAP is split across many tables, each storing a different organisational level of material data. MARA stores general data valid across all plants. MARC stores plant-specific data. MARD stores storage location stock quantities. This split design allows SAP to handle materials across thousands of plants and warehouses efficiently.

Purchasing Tables (MM-PUR)

Purchasing tables in SAP MM store all procurement document data — purchase requisitions, purchase orders, contracts, and scheduling agreements. EKKO and EKPO are the most frequently used tables in the entire MM module. Every purchase order created in ME21N is stored in EKKO (header) and EKPO (items).

Inventory Management Tables (MM-IM)

SAP MM — Inventory and Goods Movement Tables

🛒 SAP SD Tables List — Sales and Distribution

SAP Sales and Distribution (SD) manages the entire order-to-cash process — from customer master and sales order creation through delivery, billing, and payment. The SD module uses an elegant header-item table structure across all its document types. Understanding that VBAK and VBAP work together for sales orders, LIKP and LIPS for deliveries, and VBRK and VBRP for billing documents is the foundation of SD data navigation.

Key SD Document Flow: Sales Order (VBAK/VBAP) → Delivery (LIKP/LIPS) → Billing (VBRK/VBRP). The table VBFA links all three document types together. Always use VBFA to trace the complete document chain for any sales order number.

💰 SAP FI Tables List — Financial Accounting

SAP Financial Accounting (FI) is the backbone of the SAP system, storing all financial transactions, general ledger postings, accounts payable, accounts receivable, and asset accounting data. The FI module uses a cluster table structure — BKPF stores document headers and BSEG stores line items. Every financial posting in SAP creates exactly one BKPF record and at least two BSEG records (debit and credit). Understanding this structure is fundamental for any FI report or ABAP program.

SAP HR Tables List — Human Resources

SAP Human Resources (HR / HCM) uses a unique infotype-based data model that is very different from other SAP modules. Instead of individual tables for each data type, HR uses a standard set of tables (PA0001, PA0002, PA0006, etc.) where the number in the table name corresponds to the infotype number. Each infotype stores a specific category of employee data with time-based validity periods. This design allows SAP HR to maintain a complete historical record of all employee data changes over time.

SAP HR — Organisational Management Tables

Plant Maintenance and Project System

🔧 SAP PM and PS Tables List

SAP Plant Maintenance (PM) manages equipment, maintenance orders, and preventive maintenance plans for physical assets. SAP Project System (PS) handles project planning, budgeting, and execution using work breakdown structures (WBS elements) and networks. Both modules use the internal order framework (AUFK) as their core document type alongside module-specific master data tables.

SAP PS — Project System Key Tables

🔎 How to Find Any SAP Table You Need

Even with this comprehensive SAP All Tables List, there will be times when you need to find a table that is not covered here. SAP provides several built-in techniques to discover any table in the system without relying on documentation.

Method 1 — F1 Technical Information

The fastest method. In any SAP transaction, place your cursor on any field on screen and press F1. In the help popup, click the Technical Information button (or press F9). SAP will display the exact table name and field name that stores the data shown on screen. This works in every standard SAP transaction and is 100% reliable.

Method 2 — SE11 Wildcard Search

Open SE11 and enter a partial table name with a wildcard. For example, entering VB* will list all SD document tables. Entering BKPF* or *VENDOR* helps narrow down tables by name. Use the Where-Used List to find tables that reference a specific field or domain.

Method 3 — SE84 Repository Information System

SE84 is the SAP Repository Information System — a powerful search tool that allows you to search for tables by description keyword, by field name, by data element, or by table type. It is the most comprehensive search tool for finding tables when you know what data you need but not the exact table name.

"Use SE84 or this ABAP snippet to find tables with a specific field SELECT tabname, fieldname, ddtext FROM dd03vv INTO TABLE @lt_fields WHERE fieldname = 'MATNR' AND tabclass = 'TRANSP' ORDER BY tabname.

Method 4 — Check the Where-Used List in SE11

In SE11, once you have a table open, use the Where-Used List (Ctrl+Shift+F3) to find every ABAP program, function module, and other database object that reads or writes to that table. This is invaluable for understanding the full business context of any table and discovering related tables used in the same programs.

Golden Rule for SAP Tables: Never hard-code a table name in an ABAP report without first checking its delivery class in SE11. Tables with delivery class C (Customising) should only be read — never changed by custom programs. Tables with delivery class A (Application) are transactional data tables safe to read with SELECT statements.