TABLES IN SAP

CUSTOMISING 3
GENERAL SETTINGS 3
Countries 3
Currency 3
Unit of measure 3
Calendar functions 3
ENTERPRISE STRUCTURE 3
Definition 3
Assignment 3
FINANCIAL ACCOUNTING 4
Company code 4
Fi document 4
NOT CATEGORIZED 4
BASIC DATA / ADMINISTRATION 4
WORKBENCH RELATED TABLES 4
Data dictionary tables 4
Workbench 4
ADMINISTRATION 5
User administration 5
Batch input queue 5
Job processing 5
Spool 5
Runtime errors 5
Message control 5
EDI 5
Change documents 5
Reporting tree table 6
LIS structure/control tables 6
MASTER DATA 6
MATERIAL MASTER 6
Basic data text (sap script) 6
Batches 6
CUSTOMER MASTER DATA 6
VENDOR 7
CUSTOMER – MATERIAL INFO RECORD 7
BANK DATA 7
CHARACTERISTICS 7
CHARACTERISTICS 7
CLASS TYPES AND OBJECTS 7
LINKS 7
FI/CO 7
FI 7
Master data 7
Accounting documents // indices 7
Payment run 8
CO 8
Cost center master data 8
Cost center accounting 8
Page 1
SALES AND DISTRIBUTION (SD) 8
SALES ORDER 8
BILLING DOCUMENT 8

Page 2
SHIPPING 8
DELIVERY 8
PRICING 9
CONTRACTS 9

MATERIAL MANAGEMENT (MM) 9

MATERIAL DOCUMENT 9
PURCHASING 9
WAREHOUSE MANAGEMENT (WM) 9
TRANSFER REQUIREMENT 9
TRANSFER ORDER 9
MASTER DATA - STOCK POSITIONS 9
INVENTORY DOCUMENTS IN WM 9
QUALITY MANAGEMENT (QM) 10
INSPECTION LOT / INFO RECORD 10
QUALITY NOTIFICATION 10
CERTIFICATE PROFILE 10
PRODUCTION PLANNING (PP) 10
WORK CENTER 10
ROUTINGS/OPERATIONS 10
BILL OF MATERIAL 10
PRODUCTION ORDERS 11
PLANNED ORDERS 11
KANBAN 11
RESERVATIONS 11
CAPACITY PLANNING 11
PLANNED INDEPENDENT REQUIREMENTS 11
PROJECT SYSTEM (PS) 12
BASIC DATA 12
EQUIPMENT 12
PLANT MAINTENANCE (PM) 12
SETTINGS 12
MASTER DATA 12
INFOTYPES 12

Page 3
Customising
General settings

Countries
T005 Countries

Currency
TCURC Currency codes
TCURR Wisselkoersen
TCURT Currency name
TCURX Decimal places for currencies.

Unit of measure
T006 Units of measure

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

Enterprise structure

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

Assignment
Page 4
CO TKA02 Assign company code to controlling area
LO T001K Assign plant (valuation area) to company code

Page 5
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

Financial accounting

Company code
T004 Chart of accounts
T077S Account group (g/l accounts)
T009 Fiscal year variants
T880 Global company data
T014 Credit control area

Fi document
T010O Posting period variant
T010P Posting Period Variant Names
T001B Permitted Posting Periods
T003 Document types
T012 House banks

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

Basic data / administration

Workbench related tables

Data dictionary tables

DD02L Tables in SAP
DD02T Tables description
DD03L Field names in SAP
DD03T Field description in SAP

Workbench
Page 6
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

Page 7
 TSTC Transaction codes in SAP
TSTCT T100 VARID D020T Transaction codes texts Message text (vb e000)
TDEVC TDEVCT Variant data
Screen texts Development class
Texts for development classes

2.2 Administration

2.2.1 User administration

USR01 USR02 USR03 USR04User master Logon data
USR11 UST12 USR12 USR13 User address data
USR40 TOBJ TOBC User master authorizations
TPRPROF
User Master Texts for Profiles (USR10) User
DEVACCESS master: Authorizations
User master authorization values Short Texts for
Authorizations Prohibited passwords
Objects
Authorization Object Classes Profile Name for
Activity Group 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 EDID2 EDIDS Data record
EDPAR EDPVW EDPI1 Data record 3.0 Version EDI status record
EDPO1/2/3 Convert External < > Internal Partner Number
EDI partner types
EDI partner profile inbound EDI partner profile
outbound

2.2.8 Change documents

CDHDR Change document header

Page 8
CDPOS Change document positionen
JCDS Change Documents for System/User Statuses (Table JEST)

Reporting tree table

SERPTREE Reporting: tree structure

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
Basic data text (sap script)
STXB SAPscript: Texts in non-SAPscript format
STXH STXD SAPscript text file header
STXL STXD SAPscript text file lines

Batches
MCHA Batches
MCH1 Batches
MCHB Stock : batches

Customer master data

KNA1 Customer master
KNB1 Customer / company
KNVV Customer sales data
KNBK Bank details
KNVH Customer hierarchy
KNVP Customer partners
Page 9
KNVS Shipment data for customer
KNVK Contact persons
KNVI Customer master tax indicator

Page 10
Vendor
LFA1 Vendor master
LFB1 Vendor per company code
LFB5 Vendor dunning data
LFM1 Purchasing organisation data
LFM2 Purchasing data
LFBK Bank details

Customer – material info record

KNMT Customer material info record

Bank data
BNKA Master Bank data

Characteristics:
Characteristics:
CABN Characteristics ( o.a. batch/vendor)
CABNT Characteristics description
CAWN Characteristics ( o.a. material)
CAWNT Characteristics description
AUSP Characteristic Values

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

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)

FI/CO :
FI :

Master data
SKA1 Accounts
BNKA Bank master record

Accounting documents // indices

BKPF Accounting documents
BSEG item level
BSID Accounting: Secondary index for customers
BSIK Accounting: Secondary index for vendors
Page 11
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)

Page 12
BSAK Accounting: Index for vendors (cleared items)
BSAS Accounting: Index for G/L accounts (cleared items)

Payment run
REGUH Settlement data from payment program
REGUP Processed items from payment program

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

Cost center master data

CSKS Cost Center Master Data
CSKT Cost center texts
CRCO Assignment of Work Center to Cost Center

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

Sales and Distribution (SD) :

VBFA Document flow (alg.)
VTFA Flow shipping documents

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

Billing document :
VBRK header data
VBRP Item data

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)
Page 13
Delivery :
LIKP Delivery header
LIPS Delivery item

Page 14
Pricing :
KONH Conditions header
KONP Conditions items
KONV Procedure ( billing doc or sales order) KOND

Contracts:
VEDA Contract data

Material Management (MM):

Material document
MKPF material document
MSEG material document (item level)

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

Warehouse Management (WM) :

Transfer requirement
LTBK Transfer requirement - header
LTBP Transfer requirement - item

Transfer order
LTAK Transfer order - header
LTAP Transfer order - item

Master data - stock positions

LQUA Quants

Inventory documents in WM
LINK Inventory document header
LINP Inventory document item
LINV Inventory data per quant

Page 15
Quality Management (QM) :

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

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

Certificate profile
QCVMT Certificate profile characteristic level: texts
QCVM Certificate profile characteristic level
QCVK Certificate profile header

Production Planning (PP)

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

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

Page 16
PLPR Log collector for tasklists
PLMZ Allocation of BOM - items to operations

Bill of material
STKO BOM - header

Page 17
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
Page 18
PBHI Independent requirement history
PBIV Independent requirement index
PBIC Independent requirement index for customer req.

Page 19
Project system (PS)
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

Equipment
EQUI Equipment master data
EQKT Equipment short text
EQUZ Equipment time segment

Plant maintenance (PM)

IHPA Plant Maintenance: Partners
OBJK Plant Maintenance Object List
ILOA PM Object Location and Account Assignment
AFIH Maintenance order header
Human resources
12.1 Settings
T582A Infotypes: Customer-Specific Settings

12.2 Master data

T527X Organizational Units
T528T Position Texts
T554T Attendance and Absence Texts
T501 Employee group
T503 T503K Employee group, subgroup Employee subgroup

T510N T549A Pay Scales for Annual Salaries (NA) Payroll Accounting
Areas
T750X Vacancy

12.3 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

Page 20