SAP All Tables List: Complete Reference Guide to Every SAP Module Table Every Professional Must Know

🛠️ 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 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.

💰 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 CO Tables List — Controlling

SAP Controlling (CO) handles internal cost accounting, cost centre management, profit centre accounting, internal orders, and profitability analysis. CO tables are tightly integrated with FI — every FI posting that carries a cost object creates a corresponding CO line item. The key CO tables are COSS and COSP for cost totals, COEP for line items, and CSKS for cost centre master data.

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 PP Tables List — Production Planning

SAP Production Planning (PP) manages the manufacturing process — from bills of materials and routings through to production orders, capacity planning, and goods issue/receipt. PP is tightly linked to MM (for material requirements and goods movements) and CO (for order cost settlement). The most critical PP tables are STKO and STPO for bills of materials, PLKO and PLPO for routings, and AUFK with AFKO for production orders.

SAP WM Tables List — Warehouse Management

SAP Warehouse Management (WM) manages the physical movement of goods within a warehouse — putaway, picking, transfer orders, and bin management. WM works below the MM inventory management layer, adding bin-level granularity to stock management. In S/4HANA, WM has been replaced by the new Extended Warehouse Management (EWM) module, but classic WM tables are still widely used in ECC systems.

🔧 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 Configuration and Customising Tables

Beyond transactional tables, SAP contains hundreds of configuration tables (also called Customising tables or T-tables) that control system behaviour. These tables are maintained via the IMG (Implementation Guide) using transaction SPRO. Knowing these tables is essential for consultants who need to understand why the system behaves in a certain way or who need to transport configuration between systems.

🔎 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.

📋 SAP All Tables List — Master Quick Reference

The table below is your single-page quick reference covering the most important tables from every major SAP module. Bookmark this page and use it whenever you need to quickly identify which table stores the data you are looking for.

📘 Related SAP Tutorials

🔗 Important Related Links