SAP Tables Categorized by Business Process

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
T880            Company
T001            Company code
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

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

ERP Avatar

2 responses to “SAP Tables Categorized by Business Process”

  1. vpn special coupon code 2024 Avatar

    Hi there, I found your website by way of Google whilst looking for
    a related topic, your web site came up, it appears good.
    I have bookmarked it in my google bookmarks.

    Hello there, just changed into alert to your blog via Google,
    and found that it is truly informative. I am going to watch out
    for brussels. I’ll be grateful in case you continue this in future.
    A lot of other people will probably be benefited from your
    writing. Cheers!

  2. vpn special code Avatar

    Excellent post. I used to be checking continuously this weblog and I’m
    inspired! Extremely helpful information particularly
    the remaining part 🙂 I handle such info a lot.
    I used to be seeking this certain info for a very long time.

    Thanks and good luck.

Leave a Reply

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