Tables in SAP (almost all)


Please note that several modules use the same tables. So sometimes you can find information under an other chapter.

Example: PS and PP (and others) are using the same tables as CO-OPA (internal orders).

Like AUFK for order master, AFVC for activities/operations and COEP for postings.


1       Customizing

1.1        General settings

1.1.1         Countries

1.1.2         Currency

1.1.3         Unit of measure

1.1.4         Calendar functions

1.2        Enterprise structure

1.2.1         Definition

1.2.2         Assignment

1.3        Financial accounting

1.3.1         Company code

1.3.2         Fi document

1.3.3         Dunning customizing:

1.4        Not categorized

2       Basic data / administration

2.1        Workbench related tables

2.1.1         Data dictionary tables

2.1.2         Workbench

2.2        Administration

2.2.1         User administration

2.2.2         Batch input queue

2.2.3         Job processing

2.2.4         Spool

2.2.5         Runtime errors

2.2.6         Message control

2.2.7         EDI

2.2.8         Change documents

2.2.9         Reporting tree table

2.2.10      LIS structure/control tables

3       MASTER DATA:

3.1        Material master:

3.1.1         Basic data text (sap script)

3.1.2         Batches

3.2        Customer master data

3.3        Vendor

3.4        Customer – material info record

3.5        Bank data

4       Characteristics

4.1        Characteristics

4.2        Class types and objects

4.3        Links

5       FI/CO

5.1        FI

5.1.1         Master data

5.1.2         Accounting documents // indices

5.1.3         Payment run

5.1.4         Electronic Bank Statement (EBS) Load

5.1.5         Dunning run

5.2        CO

5.2.1         Controlling general

5.2.2         Cost center accounting          Cost center master data          Cost center accounting documents

5.2.3         Profit center accounting          Profit center master data          Profit center accounting documents          Others

6       Sales and Distribution (SD)

6.1        Sales order

6.2        Billing document

6.3        Shipping

6.4        Delivery

6.5        Pricing

6.6        contracts

7       Material Management (MM)

7.1        Material document

7.2        Purchasing

8       Warehouse Management (WM)

8.1        Transfer requirement

8.2        Transfer order

8.3        Master data - stock positions

8.4        Inventory documents in WM

9       Quality Management (QM)

9.1        Inspection lot / info record

9.2        Quality notification

9.3        Certificate profile

10         Production Planning (PP)

10.1     Work center

10.2     Routings/operations

10.3     Bill of material

10.4     Production orders

10.5     Planned orders

10.6     KANBAN

10.7     Reservations

10.8     Capacity planning

10.9     Planned independent requirements

11         Project system (PS)

11.1     Basic data

11.2     Equipment

12         Plant maintenance (PM)

12.1     Human resources

12.2     Settings

12.3     Master data

12.4     Infotypes

13         Other important tables

14         MRP Related

15         Nice to know

15.1     T-Codes




1      Customizing

1.1          General settings

1.1.1          Countries

T005                       Countries

1.1.2          Currency

TCURC                  Currency codes

TCURR                  Wisselkoersen

TCURT                  Currency name

TCURX                  Decimal places for currencies.

1.1.3          Unit of measure

T006                       Units of measure

1.1.4          Calendar functions

T247                       Month names

TFACD                  Factory calendar definition

T015M                   Month names

TTZZ                      Time zones

TTZD                     Summer time rules

TTZDF                   Summer time rules (fixed annual dates)

TTZDV                   Summer time rules (variable dates)

TTZDT                   Summer time rules texts

TTZ5                      Assign Time Tones to Countries

TTZ5S                    Assign time zones to regions

1.2          Enterprise structure

1.2.1          Definition


T880                       Company

T001                       Company code

CO                         TKA01 Controlling area


T001W                   Plant / sales organisation

T499S                    Locations

TSPA                     Division


TVKO                     Sales organisation / company code

TVTW                    Distribution channel

TVBUR                  Sales office

TVKBT                   Sales office text

TVKGR                  Sales group

TVGRT                  Sales group text

T171T                    Sales district text


T001L                     Storage locations

T024E                    Purchasing organization

T3001                     Warehouse number

TVST                     Shipping point

TVLA                      Loading point

TTDS                     Transportation 

1.2.2          Assignment


TKA02                    Assign company code to controlling area


T001K                    Assign plant (valuation area) to company code


TVKO                     Sales organisation / company code

TVKOV                  Distribution channel / sales organisation

TVKOS                  Division to sales organization

TVTA                     Sales aria

TVKBZ                   Sales office to sales area

TVBVK                   Sales group to sales office

TVKWZ                  Plants to sales organization


T024E                    Purchasing organization / company code

T024W                   Plant to Purchase organization

T001K                    Link plant ( = valuation area) / company code

TVSWZ                  Shipping point to plant

T320                       Assignment MM Storage Location to WM Warehouse

1.3          Financial accounting

1.3.1          Company code

T004                       Chart of accounts

T077S                    Account group (g/l accounts)

T009                       Fiscal year variants

T880                       Global company data

T014                       Credit control area

T001U                    Account assignments for Intercompany postings

1.3.2          Fi document

T010O                    Posting period variant

T010P                    Posting Period Variant Names

T001B                    Permitted Posting Periods

T003                       Document types

T012                       House banks

1.3.3          Dunning customizing:

T047                       Company Code Dunning Control

T047T                    Dunning procedure names

T047A                    Account Level Dunning Control (interval and so)

T047B                    Dunning level control (setting per level)

T047E                    Form selection for dunning notices (form assignment)

1.4          Not categorized

T007A                    Tax keys

T134                       Material types

T179                       Materials: Product Hierarchies

T179T                    Materials: Product hierarchies: Texts

TJ02T                    Status text

TINC                      Customer incoterms

TVFK                     Billing doc types

T390                       PM: Shop papers for print control 

2      Basic data / administration

2.1          Workbench related tables

2.1.1          Data dictionary tables

DD02L                   Tables in SAP

DD02T                   Tables description

DD03L                   Field names in SAP

DD03T                   Field description in SAP

2.1.2          Workbench

TADIR                    Directory of R/3 Repository Objects

TRDIR                   System table TRDIR

TFDIR                    Function Module

TLIBG                    Person responsible for function class

TLIBT                     Function Group Short Texts

TFTIT                     Function Module Short Text

TSTC                     Transaction codes in SAP

TSTCT                   Transaction codes texts

T100                       Message text (vb e000)

VARID                   Variant data

D020T                    Screen texts

TDEVC                  Development class

TDEVCT                Texts for development classes

2.2          Administration

2.2.1          User administration

USR01                   User master

USR02                   Logon data

USR03                   User address data

USR04                   User master authorizations

USR11                   User Master Texts for Profiles (USR10)

UST12                   User master: Authorizations

USR12                   User master authorization values

USR13                   Short Texts for Authorizations

USR40                   Prohibited passwords

TOBJ                     Objects

TOBC                    Authorization Object Classes

TPRPROF             Profile Name for Activity Group

DEVACCESS        Table for development user

UST04                   User profiles (multiple rows per user)

USR10                   Authorisation profiles (i.e. &_SAP_ALL)

UST10C                 Composit profiles (i.e. profile has sub profile)

USR11                   Text for authorisation profiles

USR40                   Tabl for illegal passwords

USGRP                 User groups

USGRPT               Text table for USGRP

USH02                   Change history for logon data

USER_ADDR        Address Data for users

USOBT                  Relation transaction to authorization object (SAP)

USOBT_C             Relation Transaction to Auth. Object (Customer)

USOBX                  Check table for table USOBT

USOBXFLAGS     Temporary table for storing USOBX/T* chang

USOBX_C             Check Table for Table USOBT_C

AGR_1016             Name of the activity group profile

AGR_1016B          Name of the activity group profile

AGR_1250             Authorization data for the activity group

AGR_1251             Authorization data for the activity group

AGR_1252             Organizational elements for authorizations

AGR_AGRS          Roles in Composite Roles

AGR_DEFINE       Role definition

AGR_HIER2          Menu structure information - Customer vers

AGR_HIERT         Role menu texts

AGR_OBJ             Assignment of Menu Nodes to Role

AGR_PROF          Profile name for role

AGR_TCDTXT      Assignment of roles to Tcodes

AGR_TEXTS         File Structure for Hierarchical Menu - Cus

AGR_TIME            Time Stamp for Role: Including profile

AGR_USERS        Assignment of roles to users 

2.2.2          Batch input queue

APQD                    DATA DEFINITION Queue

APQI                      Queue info definition

2.2.3          Job processing

TBTCO                  Job status overview table

TBTCP                   Batch job step overview

2.2.4          Spool

TSP02                    Spool: Print requests

2.2.5          Runtime errors

SNAP                     Runtime errors

2.2.6          Message control

TNAPR                  Processing programs for output

NAST                     Message status

NACH                    Printer determination

2.2.7          EDI

EDIDC                   Control record

EDIDD                   Data record

EDID2                    Data record 3.0 Version

EDIDS                   EDI status record

EDPAR                  Convert External < > Internal Partner Number

EDPVW                 EDI partner types

EDPI1                    EDI partner profile inbound

EDPO1/2/3            EDI partner profile outbound

2.2.8          Change documents

CDHDR                 Change document header

CDPOS                 Change document positioned

JCDS                     Change Documents for System/User Statuses (Table JEST)

2.2.9          Reporting tree table

SERPTREE           Reporting: tree structure

2.2.10       LIS structure/control tables

TMC4                     Global Control Elements: LIS Info Structure


3.1          Material master:

MARA                    Material master

MAKT                    Material text

MARC                    Material per plant / stock

MVKE                    Material master, sales data

MARD                    Storage location / stock

MSKA                    Sales order stock

MSPR                    Project stock

MARM                   Units of measure

MEAN                    International article number

PGMI                     Planning material

PROP                    Forecast parameters

MAPR                    Link MARC <=> PROP

MBEW                   Material valuation

EBEW                    Material valuation project stock

MVER                    Material consumption

MLGN                    Material / Warehouse number

MLGT                    Material / Storage type

MPRP                    Forecast profiles

MDTB                    MRP table

MDKP                    Header data for MRP document

MLAN                    Tax data material master

MTQSS                 Material master view: QM

3.1.1          Basic data text (sap script)

STXB                     SAP script: Texts in non-SAP script format

STXH                     STXD SAP script text file header

STXL                      STXD SAP script text file lines

3.1.2          Batches 

MCHA                    Batches

MCH1                    Batches

MCHB                    Stock: batches

3.2          Customer master data

KNA1                     Customer master

KNB1                     Customer / company

KNVV                     Customer sales data

KNBK                     Bank details

KNVH                    Customer hierarchy

KNVP                     Customer partners

KNVS                     Shipment data for customer

KNVK                     Contact persons

KNVI                      Customer master tax indicator

3.3          Vendor

LFA1                      Vendor master

LFB1                      Vendor per company code

LFB5                      Vendor dunning data

LFM1                     Purchasing organization data

LFM2                     Purchasing data

LFBK                      Bank details 

3.4          Customer – material info record

KNMT                    Customer material info record

3.5          Bank data

BNKA                     Master bank data 

4      Characteristics

4.1          Characteristics

CABN                    Characteristics ( o.a. batch/vendor)

CABNT                  Characteristics description

CAWN                   Characteristics ( o.a. material)

CAWNT                 Characteristics description

AUSP                     Characteristic Values

4.2          Class types and objects

TCLAO                  Several class types for object

TCLA                     Class types ( vb. lfa1 => v10 en 010)

TCLAT                   Class type text

TCLT                      Classifiable objects

TCLC                     Classification status

4.3          Links

INOB                      Link between Internal Number and Object

KLAH                     Class header data 

KSSK                     Allocation Table: Object (vb.matnr) to Class 

KSML                     Characteristics for a class (internal number)

5      FI/CO

5.1          FI

5.1.1          Master data

SKA1                     Accounts

SKAT                     Account descriptions

SKB1                     Accounts company code part

BNKA                     Bank master record

5.1.2          Accounting documents // indices

BKPF                     Accounting documents

BSEG                    item level

BSID                      Accounting: Secondary index for customers 

BSIK                      Accounting: Secondary index for vendors 

BSIM                      Secondary Index, Documents for Material 

BSIP                      Index for vendor validation of double documents 

BSIS                      Accounting: Secondary index for G/L accounts

BSAD                     Accounting: Index for customers (cleared items) 

BSAK                     Accounting: Index for vendors (cleared items) 

BSAS                     Accounting: Index for G/L accounts (cleared items)

VBKPF                   Document Header for Document Parking

VBSEGA               Document Segment for Document Parking - Asset Database

VBSEGD               Document Segment for Customer Document Parking

VBSEGK               Document Segment for Vendor Document Parking

VBSEGS               Document Segment for Document Parking - G/L Account Database

5.1.3          Payment run

REGUH                 Settlement data from payment program

REGUP                 Processed items from payment program

DFPAYG               Used format info in payment run

SEPA_MANDATE Stores the SEPA Mandate information

PYORDH               Payment order header holds in about date and ID of the 

                               (SEPA) Direct Debit pre-notification run

PYORDP               Payment order position holds if a (SEPA) DD Pre-notification

                               is created for an open item


AVIK                      Payment advise header

AVIP                      Payment advise items

5.1.4          Electronic Bank Statement (EBS) Load

FEBKO                  EBS Header Records

FEBEP                   EBS Line Items

FEBRE                  EBS Reference Records (payment notes)

TPAMA                  (OTPM) Search Strings for Pattern Matching

T028P                    (OTPM) Assign Search Strings to EBS transactions

5.1.5          Dunning run

MHNK                    Dunning header info

MHNKA                 Dunning change/status

MHND                   Dunning details

5.2          CO

5.2.1          Controlling general

TKA01                    Controlling areas

TKA02                    Controlling area assignment

CSKA                     Cost element

CSKU                    Cost element text

CSKB                     Cost element controlling area dependent part

KEKO                    Product-costing header

KEPH                     Cost components for cost of goods manuf.

KALO                     Costing objects

KANZ                     Sales order items - costing objects

5.2.2          Cost center accounting     Cost center master data

CSKS                     Cost Center Master Data

CSKT                     Cost center texts

CRCO                    Assignment of Work Center to Cost Center     Cost center accounting documents

COSP                    CO Object: Cost Totals for External Postings

COEP                    CO Object: Line Items (by Period)

. COBK                  CO Object: Document header

COST                    CO Object: Price Totals

5.2.3          Profit center accounting     Profit center master data

CEPC                    Profit Center Master Data

CEPCT                  Profit center texts     Profit center accounting documents

GLPCA                  Actual line item

GLPCT                  Totals by period

GLPCO                  Object table for Account assignment elements

GLPCC                  Transaction attributes     Others

TJ01                       Business transactions

TJ01T                    Business transactions texts

6      Sales and Distribution (SD)

VBFA                     Document flow (alg.)

VTFA                     Flow shipping documents

6.1          Sales order

VBAK                     Header data

VBAP                     Item data

VBPA                     Partners in sales order

VBKD                     Sales district data

VBEP                     Schedule lines (related to line items, delivery lines)

6.2          Billing document

VBRK                     Header data

VBRP                     Item data

6.3          Shipping

VTTK                     Shipment header

VTTP                     Shipment item

VTTS                     Stage in transport

VTSP                     Stage in transport per shipment item

VTPA                     Shipment partners

VEKP                     Handling Unit - Header Table

VEPO                    Packing: Handling Unit Item (Contents) 

6.4          Delivery

LIKP                       Delivery header

LIPS                       Delivery item

6.5          Pricing

KONH                    Conditions header

KONP                    Conditions items

KONV                    Procedure ( billing doc or sales order)


6.6          contracts

VEDA                     Contract data

7      Material Management (MM)

7.1          Material document

MKPF                    Material document

MSEG                    Material document (item level)

7.2          Purchasing

EKKO                    Purchase document

EKPO                    Purchase document (item level)

EKPV                     Shipping-Specific Data on Stock Tfr. for Purch. Doc. Item

EKET                     Delivery schedule

VETVG                  Delivery Due Index for Stock Transfer

EKES                     Order Acceptance/Fulfillment Confirmations

EKKN                     Account assignment in purchasing

EKAN                     Vendor address purchasing

EKPA                     Partner functions

EIPO                      Item export / import data

EINA                      Purchase info record (main data)

EINE                      Purchase info record (organisational data)

EORD                    Source list

EBAN                     Purchase requisition

EBKN                     Purchase Requisition Account Assignment

EKBE                     Purchasing history

RBKP                     Invoice receipt header

RSEG                    Invoice receipt items

RBCO                    Document Item, Incoming Invoice, Account Assignment

RBMA                    Document Item: Incoming Invoice for Material

RBSELBEST         Invoice Receipt, Purchasing Documents Selection

                               (give relation invoice - PO numbers)


See also Finance for invoice parking tables


8      Warehouse Management (WM)

8.1          Transfer requirement

LTBK                      Transfer requirement - header

LTBP                      Transfer requirement - item

8.2          Transfer order

LTAK                      Transfer order - header

LTAP                      Transfer order - item

8.3          Master data - stock positions

LQUA                     Quants

8.4          Inventory documents in WM

LINK                       Inventory document header

LINP                       Inventory document item

LINV                       Inventory data per quant

9      Quality Management (QM) 

9.1          Inspection lot / info record

QALS                     Inspection lot record

QAMB                    Link inspection lot - material document

QAVE                    Inspection usage decision

QDPS                    Inspection stages

QMAT                    Inspection type - material parameters

QINF                      Inspection info record (vendor - material)

QDQL                    Quality level

QDPS                    Inspection stages

9.2          Quality notification

TQ80                      Notification types

QMEL                    Quality notification

QMFE                    Quality notification – items

QMUR                   Quality notification – causes

QMSM                   Quality notification – tasks

QMMA                   Quality notification – activities

QMIH                     Quality message - maintenance data excerpt

9.3          Certificate profile

QCVMT                 Certificate profile characteristic level: texts

QCVM                   Certificate profile characteristic level

QCVK                    Certificate profile header

10  Production Planning (PP)

10.1       Work center

CRHH                    Work center hierarchy

CRHS                    Hierarchy structure

CRHD                    Work center header

CRTX                     Text for the Work Center or Production Resource/Tool

CRCO                    Assignment of Work Center to Cost Center

KAKO                    Capacity Header Segment

CRCA                    Work Center Capacity Allocation

TC24                      Person responsible for the workcenter

10.2       Routings/operations

MAPL                     Allocation of task lists to materials

PLAS                     Task list - selection of operations/activities

PLFH                     Task list - production resources/tools

PLFL                      Task list - sequences

PLKO                     Task list - header

PLKZ                      Task list: main header

PLPH                     Phases / suboperations

PLPO                     Task list operation / activity

PLPR                     Log collector for tasklists

PLMZ                     Allocation of BOM - items to operations

10.3       Bill of material

STKO                     BOM - header

STOP                     BOM - item

STAS                     BOM - Item Selection

STPN                     BOM - follow-up control

STPU                     BOM - sub-item

STZU                     Permanent BOM data

PLMZ                     Allocation of BOM - items to operations

MAST                    Material to BOM link

KDST                     Sales order to BOM link

10.4       Production orders

AUFK                     Production order headers

AFIH                      Maintenance order header

AUFM                    Goods movement for prod. order

AFKO                     Order header data PP orders

AFPO                     Order item

RESB                     Order componenten 

AFVC                     Order operations

AFVV                     Quantities/dates/values in the operation

AFVU                     User fields of the operation

AFFL                      Work order sequence

AFFH                     PRT assignment data for the work order(routing)

JSTO                     Status profile

JEST                      Object status

AFRU                     Order completion confirmations

                               PRT’s voor production orders

AFFH                     PRT assignment data for the work order

CRVD_A                Link of PRT to Document

DRAW                   Document Info Record

TDWA                    Document Types

TDWD                    Data Carrier/Network Nodes

TDWE                    Data Carrier Type

10.5       Planned orders

PLAF                      Planned orders

10.6       KANBAN

PKPS                     Kanban identification, control cycle

PKHD                    Kanban control cycle (header data)

PKER                     Error log for Kanban containers

10.7       Reservations

RESB                     Material reservations

RKPF                     Header

10.8       Capacity planning

KBKO                    Header record for capacity requirements

KBED                     Capacity requirements records

KBEZ                     Add. data for table KBED (for indiv. capacities/splits)

10.9       Planned independent requirements

PBIM                      Independent requirements for material

PBED                     Independent requirement data

PBHI                      Independent requirement history

PBIV                      Independent requirement index

PBIC                      Independent requirement index for customer req.

11  Project system (PS)

11.1       Basic data

PRHI                      Work Breakdown Structure, Edges (Hierarchy Pointer)

PROJ                     Project definition

PRPS                     WBS (Work Breakdown Structure) Element Master Data

RPSCO                 Project info database: Costs, revenues, finances

MSPR                    Project stock

11.2       Equipment

EQUI                      Equipment master data

EQKT                     Equipment short text

EQUZ                    Equipment time segment

12  Plant maintenance (PM)

IHPA                      Plant Maintenance: Partners

OBJK                     Plant Maintenance Object List

ILOA                      PM Object Location and Account Assignment

AFIH                      Maintenance order header

12.1       Human resources

12.2       Settings

T582A                    Infotypes: Customer-Specific Settings

12.3       Master data

T527X                    Organizational Units

T528T                    Position Texts

T554T                    Attendance and Absence Texts

T501                       Employee group

T503                       Employee group, subgroup

T503K                    Employee subgroup

T510N                    Pay Scales for Annual Salaries (NA)

T549A                    Payroll Accounting Areas

T750X                    Vacancy

12.4       Infotypes

PA0001                  Org. Assignment

PA0002                  Personal Data

PA0006                  Addresses

PA0007                  Planned Working Time

PA0016                  Contract elements

PA0008                  Basic pay

PA0105                  Communications

PA1007                  Vacancies

PA1035                  Training

PA2001                  Absences 

13  Other important tables

JEST                      System Status with object number

TJ02                       System status description. 

14  MRP Related

MDKP                    Header Data for MRP Document

MDTB                    MRP Table

MDVL                    Planning file entry for long term planning

MDVM                   Entry in MRP file

PBVPV                  Material Index for consumption of planning

REUL                     Material stock transfer reservation index

SAFK                     Run schedule master data

SQ01                     Abap query

EDMSG                 ALE message type table


15  Nice to know

15.1        T-Codes

TAANA                Allows analysis of table contents. Example, how many FI documents with document type SA are posted in company 001