sap tables

TABLES IN SAP

1 CUSTOMISING 3 1.1 GENERAL SETTINGS 3 1.1.1 Countries 3 1.1.2 Currency 3 1.1.3 Unit of measure 3 1.1.4 Calendar functions 3 1.2 ENTERPRISE STRUCTURE 3 1.2.1 Definition 3 1.2.2 Assignment 3 1.3 FINANCIAL ACCOUNTING 4 1.3.1 Company code 4 1.3.2 Fi document 4 1.4 NOT CATEGORIZED 4

2 BASIC DATA / ADMINISTRATION 5 2.1 WORKBENCH RELATED TABLES 5 2.1.1 Data dictionary tables 5 2.1.2 Workbench 5 2.2 ADMINISTRATION 5 2.2.1 User administration 5 2.2.2 Batch input queue 5 2.2.3 Job processing 5 2.2.4 Spool 5

2.2.5 Runtime errors 6

2.2.6 Message control 6 2.2.7 EDI 6

2.2.8 Change documents 6 2.2.9 Reporting tree table 6

2.2.10 LIS structure/control tables 6 3 MASTER DATA : 7 3.1 MATERIAL MASTER : 7

3.1.1 Basic data text (sap script) 7 3.1.2 Batches 7

3.2 CUSTOMER MASTER DATA 7 3.3 VENDOR 7

3.4 CUSTOMER – MATERIAL INFO RECORD 8 3.5 BANK DATA 8 4 CHARACTERISTICS : 9 4.1 CHARACTERISTICS : 9 4.2 CLASS TYPES AND OBJECTS : 9 4.3 LINKS : 9 5 FI/CO : 10 5.1 FI : 10

5.1.1 Master data 10

5.1.2 Accounting documents // indices 10 5.1.3 Payment run 10 5.2 CO : 10

5.2.1 Cost center master data 10 5.2.2 Cost center accounting 10 6 SALES AND DISTRIBUTION (SD) : 11 6.1 SALES ORDER : 11 6.2 BILLING DOCUMENT : 11

6.3 SHIPPING : 11 6.4 DELIVERY : 11 6.5 PRICING : 11

7 MATERIAL MANAGEMENT (MM) : 12 7.1 MATERIAL DOCUMENT 12 7.2 PURCHASING 12

8 WAREHOUSE MANAGEMENT (WM) : 13 8.1 TRANSFER REQUIREMENT 13 8.2 TRANSFER ORDER 13

8.3 MASTER DATA - STOCK POSITIONS 13 8.4 INVENTORY DOCUMENTS IN WM 13 9 QUALITY MANAGEMENT (QM) : 14 9.1 INSPECTION LOT / INFO RECORD 14 9.2 QUALITY NOTIFICATION 14 9.3 CERTIFICATE PROFILE 14 10 PRODUCTION PLANNING (PP) 15 10.1 WORK CENTER 15 10.2 ROUTINGS/OPERATIONS 15 10.3 BILL OF MATERIAL 15 10.4 PRODUCTION ORDERS 15 10.5 PLANNED ORDERS 16 10.6 KANBAN 16 10.7 RESERVATIONS 16 10.8 CAPACITY PLANNING 16

10.9 PLANNED INDEPENDENT REQUIREMENTS 16 10.10 EQUIPMENT 16 11 PROJECT SYSTEM (PS) 17 11.1 BASIC DATA 17

12 PLANT MAINTENANCE (PM) 17 13 HUMAN RESOURCES 18 13.1 SETTINGS 18 13.2 MASTER DATA 18 13.3 INFOTYPES 18

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

T5T Attendance and Absence Texts T501 Employee group

T503 Employee group, subgroup T503K Employee subgroup

T510N Pay Scales for Annual Salaries (NA)

T9A 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