If you are working as a SAP consultant or a developer, you should know all the important SAP tables as per your roles and how to access the content via table.

What are SAP Tables

SAP Tables are database tables that store system-related data in a specific format in the forms of rows and columns. These tables are stored in the Data dictionary and can be accessed via transaction code SE11.

Tables in SAP are categorized into different types of tables such as:

  • Transparent Tables
  • Cluster Tables
  • Pooled Tables

How to Access SAP Tables

The table in SAP can be accessed and view the data through the following methods:

  • ABAP Data Dictionary (SE11) – You can view, edit, and modify table structures, fields, and technical settings.
  • Table Browser (SE16/SE16N) – You can view the content through the transactions of SE16 or SE16n
  • Abap Programs – Using the queries like Select, Insert & Update, you can view the query tables.

Note: You can execute the table via SAP transaction codes: SE11 or SE16/SE16N, you can execute the table key directly in the command field like how you execute the transaction code.

How to view Table content in SE16/SE16n

Step 1: Execute the transaction code: SE16N

Step 2: Enter the Table Name

SAP Tables view in Se16n

Step 3: Now you can give the required details under the selection criteria and click on execute.

Now it displays BSEG table content as per the selection criteria data.

How to view the Table Fields in SE11

Step 1: Execute the transaction code: SE11

Step 2: From ABAP:Dictionary initial screen, enter the table name under the field database table and click on the option ‘Display’ as shown below image

How to view SAP Table in SAP via SE11 transaction code

Here we have executed the table: BSEG. Now all the fields of the BSEG table are displayed on the screen.

SAP Tables - Dictionary with fields

Important SAP Tables by Module-wise

Refer below for the important list of SAP Tables by module.

SAP FI (Financial Accounting) Tables:

TableDescription
BKPFAccounting document header
BSEGAccounting document line items
SKA1G/L Account Master Data (Chart of Accounts)
SKB1GL Account Master (Company code)
SKATG/L Account master record -chart of accounts: description
LFA1Vendor master (general data)
LFB1Vendor master (Company code data)
BSISG/L Accounts open items
BSIDG/L accounts cleared items
BSIKVendor open items
BSAKVendor cleared items
ANLAAsset master record
ANLPAsset periodic values
ANLCAsset value fields

SAP CO (Controlling) Tables

TableDescription
COEPCO Object – Line Item
COBKCO Object – Document header
CSKBCost Element
CEPCProfit center master data
COSPCO Object – Cost totals for external postings

SAP Material Management tables:

TableDescription
MARAMaterial Master – General Data
MARCMaterial Plant Data
MBEWMaterial Valuation
EBANPurchase Requisition (PR)
EKKOPurchase Document Header (PO)
EKPOPurchase document item (PO)
MSEGDocument segment material
MKPFMaterial document header
RSEGIncoming invoices document items
T149DGlobal valuation types

For the complete list of material management tables, refer to SAP MM Tables.

SAP Sales & Distribution (SD) Tables:

TableDescription
VBAKSales document header
VBAPSales document items
VBPASales document – partners
LIKPSales document delivery data
VBRKBilling document header data
VBRPBilling document item data
KNA1Customer master – general data
KNB1Customer master – Company code data
KNVVCustomer master sales data
KONVConditions transaction data

For the complete list of sales and distribution modules tables in ECC & S4 Hana, refer to SAP SD tables.

SAP PP (Production Planning) Module Tables

TableDescription
SKTOBills of Material Header
STPOBills of Material Items
PLKORouting Header
PLPORouting Operations
CRHDWork Center Header
AFKOProduction Order Header
AFPOProduction Order Item
PLAFPlanned Order
MDKPMRP Document Header
MDTBMRP document Items

Continue to read for a complete list of SAP PP Tables by topics.