SAP Table List


1         Customising

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

 FI   T880                            Company

       T001                            Company code

 CO TKA01                         Controlling area

 LO T001W                         Plant / sales organisation

       T499S                         Locations

       TSPA                           Division

 SD  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

MM  T001L                           Storage locations

       T024E                           Purchasing organization

       T3001                           Warehouse number

       TVST                            Shipping point

       TVLA                            Loading point

       TTDS                            Transportation

1.2.2        Assignment

CO   TKA02                          Assign company code to controlling area

LO   T001K                          Assign plant (valuation area) to company code


SD   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

MM  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

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

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 positionen

               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         MASTER DATA :

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

            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                              SAPscript: Texts in non-SAPscript format

                  STXH                              STXD SAPscript text file header

                  STXL                              STXD SAPscript 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 organisation 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

            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)

5.1.3        Payment run

REGUH             Settlement data from payment program

REGUP              Processed items from payment program

5.2        CO :

TKA01                          Controlling areas

TKA02                          Controlling area assignment

KEKO                           Product-costing header

                KEPH                            Cost components for cost of goods manuf.

                KALO                            Costing objects

                KANZ                             Sales order items – costing objects

5.2.1        Cost center master data

CSKS                           Cost Center Master Data

CSKT                            Cost center texts

CRCO                           Assignment of Work Center to Cost Center

5.2.2        Cost center accounting

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


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                           Data 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

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

            STPO                                        BOM – item

            STAS                                        BOMs – Item Selection

            STPN                                        BOMs – 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





This Post Has 15 Comments

  1. Victor

    Just what i needed. Thanks for the info.

  2. John

    Have a look here, you can download a pdf with the most useful tables for ABAP, FI and CO

  3. Debashis

    Many thanks for the information.

    It would be more helpful if I would get Table-wise field name and its details / description.

  4. Satyarth

    Thnx vry much.

    Its vry valuable information abt SAP Tables.

  5. pamela


  6. Bharat

    THANKS MAN.. You saved my day

  7. nzhayzraai


    I’m currently analyzing customer master data with Credit Limits via T-Code F.35. Anybody could help me which SE16 Table to use to get the info as i need to do analysis on bunch of customer data. I’ve tried KNA1 and KNB1, but seems no info on Credit Limit used and usaged were included there.


  8. Dave A.

    Use table KNKK to evaluate credit limits.

  9. Bhanu.Amma


  10. Anil

    very very useful info

  11. viburaj

    Thank you!

  12. Tey

    this is great, thanks!

  13. MANISH

    Thanks its very valuable information

  14. Bala

    Its great and nicely formated. Thanks for the data. Hats off :-)

  15. Anil

    Thank you. its great info

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>