HomePage     |    Contact Us    |   Contribute     |  Forums     |  TechWiki

ALL important SAP Tables

IMPORTANT TABLES IN SAP     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