SAP TCode & Table Finder

Quickly find Transaction Codes (TCodes) and Database Tables for common SAP Business Objects.

Sales Order

SD

Customer order for goods or services.

Tables

VBAK (Header)VBAP (Item)VBEP (Schedule Line)VBKD (Business Data)

Transactions

VA01VA02VA03

Billing Document (Invoice)

SD

Invoice sent to customer.

Tables

VBRK (Header)VBRP (Item)

Transactions

VF01VF02VF03VF11 (Cancel)

Delivery

SD

Outbound delivery note.

Tables

LIKP (Header)LIPS (Item)

Transactions

VL01NVL02NVL03N

Customer Material Info

SD

Customer-specific material numbers.

Tables

KNMT

Transactions

VD51VD52VD53

Material Master

MM

Central repository of material data.

Tables

MARA (General)MARC (Plant)MARD (Storage)MVKE (Sales)MAKT (Text)

Transactions

MM01MM02MM03

Purchase Order

MM

Request to a vendor to supply goods.

Tables

EKKO (Header)EKPO (Item)EKET (Schedule Line)

Transactions

ME21NME22NME23N

Purchase Requisition

MM

Internal request for purchasing.

Tables

EBAN

Transactions

ME51NME52NME53N

Material Document (Goods Mvt)

MM

Record of goods movement.

Tables

MKPF (Header)MSEG (Item)

Transactions

MIGOMB1AMB1BMB1C

Vendor Master

MM

Legacy vendor master (see BP for S/4).

Tables

LFA1 (General)LFB1 (Company)LFM1 (Purchasing)

Transactions

XK01XK02XK03MK01

Accounting Document

FI

Financial journal entry.

Tables

BKPF (Header)BSEG (Item)BSID (Customer Open)BSAD (Customer Cleared)

Transactions

FB01FB02FB03

Customer Master (FI)

FI

Customer data for finance.

Tables

KNA1 (General)KNB1 (Company Code)

Transactions

FD01FD02FD03XD01

Business Partner

BP

Central Business Partner (S/4HANA target).

Tables

BUT000 (General)BUT020 (Address Link)BUT100 (Roles)

Transactions

BP

Shipment

LE

Transportation planning vehicle.

Tables

VTTK (Header)VTTP (Item)

Transactions

VT01NVT02NVT03N

Production Order

PP

Order to produce material.

Tables

AFKO (Header)AFPO (Item)AFVC (Operation)

Transactions

CO01CO02CO03

User Master

BASIS

User accounts and authorizations.

Tables

USR02 (Logon Data)USR21 (Address Link)ADRP (Person)

Transactions

SU01SU10PFCG

Cost Center

CO

Organizational unit for cost accumulation.

Tables

CSKS (Master)CSKT (Text)CSSL (Activity Type)

Transactions

KS01KS02KS03KS13

Internal Order

CO

Order used to plan, collect, and settle costs.

Tables

AUFK (Master)COEP (Line Items)COSP (Cost Totals)

Transactions

KO01KO02KO03KOB1

Profit Center

CO

Unit for internal profitability analysis.

Tables

CEPC (Master)CEPCT (Text)GLPCA (Actual Line Items)

Transactions

KE51KE52KE53

Bill of Material (BOM)

PP

List of components making up a product.

Tables

MAST (Material Link)STKO (Header)STPO (Item)STAS (Selection)

Transactions

CS01CS02CS03CS11

Routing

PP

Sequence of operations to produce a material.

Tables

PLKO (Header)PLPO (Operation)MAPL (Assignment)

Transactions

CA01CA02CA03

Work Center

PP

Physical unit where manufacturing is performed.

Tables

CRHD (Header)CRTX (Text)KAKO (Capacity)

Transactions

CR01CR02CR03

Inspection Lot

QM

Request to inspect goods.

Tables

QALS (Header)QAMR (Results)QAVE (Usage Decision)

Transactions

QA01QA02QA03QA11

Equipment

PM

Individual physical object to be maintained.

Tables

EQUI (Master)EQKT (Text)EQUZ (Time Segment)ILOA (Location)

Transactions

IE01IE02IE03

Maintenance Order

PM

Order to perform maintenance tasks.

Tables

AUFK (Header)AFKO (Order Data)AFVC (Operation)

Transactions

IW31IW32IW33IW38

G/L Account

FI

General Ledger account master data.

Tables

SKA1 (Chart of Accts)SKB1 (Company Code)SKAT (Text)

Transactions

FS00FSP0FSS0

Asset Master

FI-AA

Fixed asset master data.

Tables

ANLA (Master)ANLZ (Time Dep.)ANEP (Line Items)

Transactions

AS01AS02AS03

Transport Request

BASIS

Change requests for moving objects between systems.

Tables

E070 (Header)E071 (Objects)E07T (Text)

Transactions

SE01SE09SE10

IDoc (Intermediate Document)

INT

Data container for system integration.

Tables

EDIDC (Control)EDID4 (Data)EDIDS (Status)

Transactions

WE02WE19BD87WE20

Background Job

BASIS

Scheduled background tasks.

Tables

TBTCO (Job Header)TBTCP (Job Step)

Transactions

SM37SM36

Change Documents

BASIS

Log of changes made to business objects.

Tables

CDHDR (Header)CDPOS (Item - Changes)

Transactions

AUT10S_ALR_87012293

Cheat Sheet: Common SAP Tables & TCodes

Core Tables (S/4HANA & ECC)

  • VBAK / VBAP: Sales Order Header and Item data.
  • LIKP / LIPS: Delivery Header and Item data.
  • VBRK / VBRP: Billing Document (Invoice) data.
  • BKPF / BSEG: Accounting Document Header and Segment (Line Item).
  • MARA / MARC: Material Master General and Plant data.
  • EKKO / EKPO: Purchasing Document (PO) Header and Item.
  • ACDOCA: (S/4HANA Only) The Universal Journal entry table combining FI & CO.

Essential TCodes

  • SE16N / SE16H: General Table Display (Data Browser).
  • SE80 / SE38: Object Navigator & ABAP Editor.
  • ST22: ABAP Runtime Errors (Dump Analysis).
  • SM50 / SM51: Work Process Overview (System Monitoring).
  • SU01: User Maintenance.
  • PFCG: Role Maintenance.
  • /n: End current transaction. /o: Open new session.

The Ultimate SAP Dictionary

Every SAP Functional Consultant knows the struggle: you need to join the Sales Order Header table with the Delivery Item table, but you can't remember if the link is VBAK-VBELN or LIPS-VGBEL.

Complex Joins Simplified

This tool aggregates the most commonly used "Business Objects" across SD, MM, FI, CO, and PP modules. Instead of memorizing every transparent table (like MARA, MARC, MARD, MVKE), simply search for "Material" to see the complete data model at a glance.

Faster than SE16N?

Yes. Searching for a table name in SAP GUI often requires navigating multiple transaction codes (SE11, SE16N, SE80) or slow Google searches. Findocs indexes common objects for instant, offline-capable access right in your browser.

Master Data vs. Transaction Data

Understanding the distinction is crucial for building efficient ABAP reports and Fiori apps.

CategoryDefinitionExamples
Master DataSlow-changing data shared across the system.KNA1 (Customer), LFA1 (Vendor), MARA (Material)
Transaction DataDay-to-day business events.VBAK (Order), BKPF (Journal), MKPF (Goods Mvt)
ConfigurationSystem settings (customizing).T001 (Company Code), TVAK (Sales Doc Types)