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)

            KOND

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

 

 

 

 

Largest collection of SAP E Books available for instant download.

Posted in General Tagged with:
14 comments on “SAP Table List
  1. Victor says:

    Just what i needed. Thanks for the info.

  2. John says:

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

  3. Debashis says:

    Many thanks for the information.

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

  4. Satyarth says:

    Thnx vry much.

    Its vry valuable information abt SAP Tables.

  5. pamela says:

    timeless

  6. Bharat says:

    THANKS MAN.. You saved my day

  7. nzhayzraai says:

    Hi,

    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.

    Thanks!

  8. Dave A. says:

    Use table KNKK to evaluate credit limits.

  9. Anil says:

    very very useful info

  10. viburaj says:

    Thank you!

  11. Tey says:

    this is great, thanks!

  12. MANISH says:

    Thanks its very valuable information

  13. Bala says:

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

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=""> <strike> <strong>

Categories