Sap Tables For All Modules
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Sap Tables For All Modules as PDF for free.
More details
- Words: 2,790
- Pages: 24
BC – Tables in SAP
TABLES IN SAP
1
CUSTOMISING ..................................................................................................................... 4
1.1 1.1.1 1.1.2 1.1.3 1.1.4 1.2 1.2.1 1.2.2 1.3 1.3.1 1.3.2 1.4
GENERAL SETTINGS ................................................................................................................... 4 Countries ............................................................................................................................... 4 Currency ............................................................................................................................... 4 Unit of measure ..................................................................................................................... 4 Calendar functions ................................................................................................................ 4 ENTERPRISE STRUCTURE ............................................................................................................ 4 Definition .............................................................................................................................. 4 Assignment ........................................................................................................................... 6 FINANCIAL ACCOUNTING ......................................................................................................... 6 Company code ....................................................................................................................... 6 Fi document ........................................................................................................................... 6 NOT CATEGORIZED .................................................................................................................... 6
2
BASIC DATA / ADMINISTRATION ................................................................................ 8
2.1 WORKBENCH RELATED TABLES ................................................................................................. 8 2.1.1 Data dictionary tables ........................................................................................................... 8 2.1.2 Workbench ............................................................................................................................. 8 2.2 ADMINISTRATION ...................................................................................................................... 8 2.2.1 User administration .............................................................................................................. 8 2.2.2 Batch input queue.................................................................................................................. 9 2.2.3 Job processing ........................................................................................................................ 9 2.2.4 Spool ...................................................................................................................................... 9 2.2.5 Runtime errors ...................................................................................................................... 9 2.2.6 Message control ..................................................................................................................... 9 2.2.7 EDI ........................................................................................................................................ 9 2.2.8 Change documents ................................................................................................................ 9 2.2.9 Reporting tree table ............................................................................................................... 9 2.2.10 LIS structure/control tables ................................................................................................... 9 3
MASTER DATA: .................................................................................................................. 10
3.1 3.1.1 3.1.2 3.2 3.3 3.4 3.5
MATERIAL MASTER: ................................................................................................................. 10 Basic data text (sap script) .................................................................................................. 10 Batches................................................................................................................................. 10 CUSTOMER MASTER DATA ....................................................................................................... 10 VENDOR ................................................................................................................................... 11 CUSTOMER – MATERIAL INFO RECORD.................................................................................... 11 BANK DATA.............................................................................................................................. 11
4
CHARACTERISTICS: ......................................................................................................... 12
4.1
CHARACTERISTICS: .................................................................................................................. 12
1
SAP Tables For All Modules.doc
Page 1
05/09/2008
BC – Tables in SAP
4.2 4.3
CLASS TYPES AND OBJECTS : .................................................................................................... 12 LINKS: ...................................................................................................................................... 12
5
FI/CO : ................................................................................................................................... 13
5.1 FI : ............................................................................................................................................ 13 5.1.1 Master data ......................................................................................................................... 13 5.1.2 Accounting documents // indices ........................................................................................ 13 5.1.3 Payment run ....................................................................................................................... 13 5.2 CO : .......................................................................................................................................... 13 5.2.1 Cost center master data ....................................................................................................... 13 5.2.2 Cost center accounting ........................................................................................................ 13 6
SALES AND DISTRIBUTION (SD) : ............................................................................... 15
6.1 6.2 6.3 6.4 6.5 6.6
SALES ORDER : .......................................................................................................................... 15 BILLING DOCUMENT : .............................................................................................................. 15 SHIPPING : ................................................................................................................................ 15 DELIVERY : ............................................................................................................................... 15 PRICING : .................................................................................................................................. 15 CONTRACTS : ............................................................................................................................ 15
7
MATERIAL MANAGEMENT (MM) : ............................................................................. 16
7.1 7.2
MATERIAL DOCUMENT ............................................................................................................ 16 PURCHASING ........................................................................................................................... 16
8
WAREHOUSE MANAGEMENT (WM) : ......................................................................... 17
8.1 8.2 8.3 8.4
TRANSFER REQUIREMENT ........................................................................................................ 17 TRANSFER ORDER .................................................................................................................... 17 MASTER DATA - STOCK POSITIONS .......................................................................................... 17 INVENTORY DOCUMENTS IN WM ........................................................................................... 17
9
QUALITY MANAGEMENT (QM) : ................................................................................. 18
9.1 9.2 9.3
INSPECTION LOT / INFO RECORD ............................................................................................. 18 QUALITY NOTIFICATION .......................................................................................................... 18 CERTIFICATE PROFILE .............................................................................................................. 18
10
PRODUCTION PLANNING (PP) ..................................................................................... 19
10.1 10.2 10.3 10.4 10.5 10.6 10.7 10.8 10.9
WORK CENTER ......................................................................................................................... 19 ROUTINGS/OPERATIONS .......................................................................................................... 19 BILL OF MATERIAL ................................................................................................................... 19 PRODUCTION ORDERS.............................................................................................................. 19 PLANNED ORDERS ................................................................................................................... 20 KANBAN ............................................................................................................................... 20 RESERVATIONS......................................................................................................................... 20 CAPACITY PLANNING .............................................................................................................. 20 PLANNED INDEPENDENT REQUIREMENTS............................................................................... 20
2
SAP Tables For All Modules.doc
Page 2
05/09/2008
BC – Tables in SAP
11
PROJECT SYSTEM (PS)...................................................................................................... 22
11.1 11.2
BASIC DATA.............................................................................................................................. 22 EQUIPMENT.............................................................................................................................. 22
12
PLANT MAINTENANCE (PM) ......................................................................................... 22
12.1 12.2 12.3 12.4
HUMAN RESOURCES ................................................................................................................ 23 SETTINGS .................................................................................................................................. 23 MASTER DATA ......................................................................................................................... 23 INFOTYPES ................................................................................................................................ 23
3
SAP Tables For All Modules.doc
Page 3
05/09/2008
BC – Tables in SAP
1
Customising
1.1
General settings
1.1.1 Countries T005
Countries
1.1.2 Currency TCURC TCURR TCURT TCURX
Currency codes Wisselkoersen Currency name Decimal places for currencies.
1.1.3 Unit of measure T006
Units of measure
1.1.4 Calendar functions T247 TFACD T015M TTZZ TTZD TTZDF TTZDV TTZDT TTZ5 TTZ5S
1.2
Month names Factory calendar definition Month names Time zones Summer time rules Summer time rules (fixed annual dates) Summer time rules (variable dates) Summer time rules texts Assign Time Tones to Countries Assign time zones to regions
Enterprise structure
1.2.1 Definition FI T880 T001 CO TKA01 LO T001W T499S TSPA SD TVKO TVTW TVBUR TVKBT TVKGR
Company Company code Controlling area Plant / sales organisation Locations Division Sales organisation / company code Distribution channel Sales office Sales office text Sales group
4
SAP Tables For All Modules.doc
Page 4
05/09/2008
BC – Tables in SAP
TVGRT T171T MM T001L T024E T3001 TVST TVLA TTDS
Sales group text Sales district text Storage locations Purchasing organization Warehouse number Shipping point Loading point Transportation
5
SAP Tables For All Modules.doc
Page 5
05/09/2008
BC – Tables in SAP
1.2.2 Assignment CO TKA02 LO T001K
Assign company code to controlling area Assign plant (valuation area) to company code
SD TVKO TVKOV TVKOS TVTA TVKBZ TVBVK TVKWZ MM T024E T024W T001K TVSWZ T320
Sales organisation / company code Distribution channel / sales organisation Division to sales organization Sales aria Sales office to sales area Sales group to sales office Plants to sales organization Purchasing organization / company code Plant to Purchase organization Link plant ( = valuation area) / company code Shipping point to plant Assignment MM Storage Location to WM Warehouse
1.3
Financial accounting
1.3.1 Company code T004 T077S T009 T880 T014
Chart of accounts Account group (g/l accounts) Fiscal year variants Global company data Credit control area
1.3.2 Fi document T010O T010P T001B T003 T012
1.4
Posting period variant Posting Period Variant Names Permitted Posting Periods Document types House banks
Not categorized T007a T134 T179 T179T TJ02T TINC TVFK T390
Tax keys Material types Materials: Product Hierarchies Materials: Product hierarchies: Texts Status text Customer incoterms Billing doc types PM: Shop papers for print control
6
SAP Tables For All Modules.doc
Page 6
05/09/2008
BC – Tables in SAP
7
SAP Tables For All Modules.doc
Page 7
05/09/2008
BC – Tables in SAP
2 2.1
Basic data / administration Workbench related tables
2.1.1 Data dictionary tables DD02L DD02T DD03L DD03T
Tables in SAP Tables description Field names in SAP Field description in SAP
2.1.2 Workbench TADIR TRDIR TFDIR TLIBG TLIBT TFTIT TSTC TSTCT T100 VARID D020T TDEVC TDEVCT
2.2
Directory of R/3 Repository Objects System table TRDIR Function Module Person responsible for function class Function Group Short Texts Function Module Short Text Transaction codes in SAP Transaction codes texts Message text (vb e000) Variant data Screen texts Development class Texts for development classes
Administration
2.2.1 User administration USR01 USR02 USR03 USR04 USR11 UST12 USR12 USR13 USR40 TOBJ TOBC TPRPROF DEVACCESS
User master Logon data User address data User master authorizations User Master Texts for Profiles (USR10) User 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
8
SAP Tables For All Modules.doc
Page 8
05/09/2008
BC – Tables in SAP
2.2.2 Batch input queue APQD APQI
DATA DEFINITION Queue Queue info definition
2.2.3 Job processing TBTCO TBTCP
Job status overview table 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 NAST NACH
Processing programs for output Message status Printer determination
2.2.7 EDI EDIDC EDIDD EDID2 EDIDS EDPAR EDPVW EDPI1 EDPO1/2/3
Control record Data record Data record 3.0 Version EDI status record Convert External < > Internal Partner Number EDI partner types EDI partner profile inbound EDI partner profile outbound
2.2.8 Change documents CDHDR CDPOS JCDS
Change document header Change document positioned 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
9
SAP Tables For All Modules.doc
Page 9
05/09/2008
BC – Tables in SAP
3 3.1
MASTER DATA: Material master: MARA MAKT MARC MVKE MARD MSKA MSPR MARM MEAN PGMI PROP MAPR MBEW MVER MLGN MLGT MPRP MDTB MDKP MLAN MTQSS
Material master Material text Material per plant / stock Material master, sales data Storage location / stock Sales order stock Project stock Units of measure International article number Planning material Forecast parameters Link MARC <=> PROP Material valuation Material consumption Material / Warehouse number Material / Storage type Forecast profiles MRP table Header data for MRP document Tax data material master Material master view: QM
3.1.1 Basic data text (sap script) STXB STXH STXL
SAP script: Texts in non-SAP script format STXD SAP script text file header STXD SAP script text file lines
3.1.2 Batches MCHA MCH1 MCHB
3.2
Batches Batches Stock: batches
Customer master data KNA1 KNB1 KNVV KNBK KNVH KNVP
Customer master Customer / company Customer sales data Bank details Customer hierarchy Customer partners
10
SAP Tables For All Modules.doc
Page 10
05/09/2008
BC – Tables in SAP
KNVS KNVK KNVI
3.3
Vendor LFA1 LFB1 LFB5 LFM1 LFM2 LFBK
3.4
Vendor master Vendor per company code Vendor dunning data Purchasing organization data Purchasing data Bank details
Customer – material info record KNMT
3.5
Shipment data for customer Contact persons Customer master tax indicator
Customer material info record
Bank data BNKA
Master bank data
11
SAP Tables For All Modules.doc
Page 11
05/09/2008
BC – Tables in SAP
4 4.1
Characteristics: Characteristics: CABN CABNT CAWN CAWNT AUSP
4.2
Class types and objects : TCLAO TCLA TCLAT TCLT TCLC
4.3
Characteristics ( o.a. batch/vendor) Characteristics description Characteristics ( o.a. material) Characteristics description Characteristic Values
Several class types for object Class types ( vb. lfa1 => v10 en 010) Class type text Classifiable objects Classification status
Links: INOB KLAH KSSK KSML
Link between Internal Number and Object Class header data Allocation Table: Object (vb.matnr) to Class Characteristics for a class (internal number)
12
SAP Tables For All Modules.doc
Page 12
05/09/2008
BC – Tables in SAP
5 5.1
FI/CO : FI :
5.1.1 Master data SKA1 BNKA
Accounts Bank master record
5.1.2 Accounting documents // indices BKPF BSEG BSID BSIK BSIM BSIP BSIS BSAD BSAK BSAS
Accounting documents item level Accounting: Secondary index for customers Accounting: Secondary index for vendors Secondary Index, Documents for Material Index for vendor validation of double documents Accounting: Secondary index for G/L accounts Accounting: Index for customers (cleared items) Accounting: Index for vendors (cleared items) Accounting: Index for G/L accounts (cleared items)
5.1.3 Payment run REGUH REGUP
5.2
Settlement data from payment program Processed items from payment program
CO : TKA01 TKA02 KEKO KEPH KALO KANZ
Controlling areas Controlling area assignment Product-costing header Cost components for cost of goods manuf. Costing objects Sales order items - costing objects
5.2.1 Cost center master data CSKS CSKT CRCO
Cost Center Master Data Cost center texts Assignment of Work Center to Cost Center
5.2.2 Cost center accounting
.
COSP COEP COBK COST
CO Object: Cost Totals for External Postings CO Object: Line Items (by Period) CO Object: Document header CO Object: Price Totals
13
SAP Tables For All Modules.doc
Page 13
05/09/2008
BC – Tables in SAP
14
SAP Tables For All Modules.doc
Page 14
05/09/2008
BC – Tables in SAP
6
Sales and Distribution (SD) : VBFA VTFA
6.1
Sales order : VBAK VBAP VBPA VBKD VBEP
6.2
Delivery header Delivery item
Pricing : KONH KONP KONV KOND
6.6
Shipment header Shipment item Stage in transport Stage in transport per shipment item Shipment partners Handling Unit - Header Table Packing: Handling Unit Item (Contents)
Delivery : LIKP LIPS
6.5
header data Item data
Shipping : VTTK VTTP VTTS VTSP VTPA VEKP VEPO
6.4
Header data Item data Partners in sales order Sales district data Data related to line items, delivery lines
Billing document : VBRK VBRP
6.3
Document flow (alg.) Flow shipping documents
Conditions header Conditions items Procedure ( billing doc or sales order)
contracts : VEDA
Contract data
15
SAP Tables For All Modules.doc
Page 15
05/09/2008
BC – Tables in SAP
7 7.1
Material Management (MM) : Material document MKPF MSEG
7.2
material document material document (item level)
Purchasing EKKO EKPO EKPV EKET VETVG EKES EKKN EKAN EKPA EIPO EINA EINE EORD EBAN EBKN
Purchase document Purchase document (item level) Shipping-Specific Data on Stock Tfr. for Purch. Doc. Item Delivery schedule Delivery Due Index for Stock Transfer Order Acceptance/Fulfillment Confirmations Account assignment in purchasing Vendor address purchasing Partner functions Item export / import data Purchase info record (main data) Purchase info record (organisational data) Source list Purchase requisition Purchase Requisition Account Assignment
16
SAP Tables For All Modules.doc
Page 16
05/09/2008
BC – Tables in SAP
8 8.1
Warehouse Management (WM) : Transfer requirement LTBK LTBP
8.2
Transfer order LTAK LTAP
8.3
Transfer order - header Transfer order - item
Master data - stock positions LQUA
8.4
Transfer requirement - header Transfer requirement - item
Quants
Inventory documents in WM LINK LINP LINV
Inventory document header Inventory document item Inventory data per quant
17
SAP Tables For All Modules.doc
Page 17
05/09/2008
BC – Tables in SAP
9
9.1
Quality Management (QM) :
Inspection lot / info record QALS QAMB QAVE QDPS QMAT QINF QDQL QDPS
9.2
Quality notification TQ80 QMEL QMFE QMUR QMSM QMMA QMIH
9.3
Inspection lot record Link inspection lot - material document Inspection usage decision Inspection stages Inspection type - material parameters Inspection info record (vendor - material) Quality level Inspection stages
Notification types Quality notification Quality notification – items Quality notification – causes Quality notification – tasks Quality notification – activities Quality message - maintenance data excerpt
Certificate profile QCVMT QCVM QCVK
Certificate profile characteristic level: texts Certificate profile characteristic level Certificate profile header
18
SAP Tables For All Modules.doc
Page 18
05/09/2008
BC – Tables in SAP
10 Production Planning (PP) 10.1 Work center CRHH CRHS CRHD CRTX Resource/Tool CRCO KAKO CRCA TC24
Work center hierarchy Hierarchy structure Work center header Text for the Work Center or Production Assignment of Work Center to Cost Center Capacity Header Segment Work Center Capacity Allocation Person responsible for the workcenter
10.2 Routings/operations MAPL PLAS PLFH PLFL PLKO PLKZ PLPH PLPO PLPR PLMZ
Allocation of task lists to materials Task list - selection of operations/activities Task list - production resources/tools Task list - sequences Task list - header Task list: main header Phases / suboperations Task list operation / activity Log collector for tasklists Allocation of BOM - items to operations
10.3 Bill of material STKO STPO STAS STPN STPU STZU PLMZ MAST KDST
BOM - header BOM - item BOMs - Item Selection BOMs - follow-up control BOM - sub-item Permanent BOM data Allocation of BOM - items to operations Material to BOM link Sales order to BOM link
10.4 Production orders AUFK AFIH AUFM AFKO
Production order headers Maintenance order header Goods movement for prod. order Order header data PP orders
19
SAP Tables For All Modules.doc
Page 19
05/09/2008
BC – Tables in SAP
AFPO RESB AFVC AFVV AFVU AFFL AFFH JSTO JEST AFRU
Order item Order componenten Order operations Quantities/dates/values in the operation User fields of the operation Work order sequence PRT assignment data for the work order(routing) Status profile Object status Order completion confirmations
PRT’s voor production orders AFFH CRVD_A DRAW TDWA TDWD TDWE
PRT assignment data for the work order Link of PRT to Document Document Info Record Document Types Data Carrier/Network Nodes Data Carrier Type
10.5 Planned orders PLAF
Planned orders
10.6 KANBAN PKPS PKHD PKER
Kanban identification, control cycle Kanban control cycle (header data) Error log for Kanban containers
10.7 Reservations RESB RKPF
Material reservations header
10.8 Capacity planning KBKO KBED KBEZ capacities/splits)
Header record for capacity requirements Capacity requirements records Add. data for table KBED (for indiv.
10.9 Planned independent requirements PBIM PBED PBHI PBIV
Independent requirements for material Independent requirement data Independent requirement history Independent requirement index
PBIC
Independent requirement index for customer req.
20
SAP Tables For All Modules.doc
Page 20
05/09/2008
BC – Tables in SAP
21
SAP Tables For All Modules.doc
Page 21
05/09/2008
BC – Tables in SAP
11 Project system (PS) 11.1 Basic data PRHI PROJ PRPS
Work Breakdown Structure, Edges (Hierarchy Pointer) Project definition WBS (Work Breakdown Structure) Element Master Data
RPSCO MSPR
Project info database: Costs, revenues, finances Project stock
11.2 Equipment EQUI EQKT EQUZ
Equipment master data Equipment short text Equipment time segment
12 Plant maintenance (PM) IHPA OBJK ILOA AFIH
Plant Maintenance: Partners Plant Maintenance Object List PM Object Location and Account Assignment Maintenance order header
22
SAP Tables For All Modules.doc
Page 22
05/09/2008
BC – Tables in SAP
12.1 Human resources 12.2 Settings T582A
Infotypes: Customer-Specific Settings
12.3 Master data T527X T528T T554T T501
Organizational Units Position Texts Attendance and Absence Texts Employee group
T503 T503K T510N T549A T750X
Employee group, subgroup Employee subgroup Pay Scales for Annual Salaries (NA) Payroll Accounting Areas Vacancy
12.4 Infotypes PA0001 PA0002 PA0006 PA0007 PA0016 PA0008 PA0105 PA1007 PA1035 PA2001
Org. Assignment Personal Data Addresses Planned Working Time Contract elements Basic pay Communications Vacancies Training Absences
Other important table JEST TJ02
System Status with object number System status description.
MRP Related MDKP MDTB MDVL MDVM PBVPV REUL SAFK 23
Header Data for MRP Document MRP Table Planning file entry for long term planning Enry in MRP file Material Index for consumption of planning Material stock transfer reservation index Run schedule master data
SAP Tables For All Modules.doc
Page 23
05/09/2008
BC – Tables in SAP
SQ01 EDMSG
Abap query ALE message type table
If you liked the document kindly share it with your friends and tell them to visit www.sap-topjobs.com
24
SAP Tables For All Modules.doc
Page 24
05/09/2008
TABLES IN SAP
1
CUSTOMISING ..................................................................................................................... 4
1.1 1.1.1 1.1.2 1.1.3 1.1.4 1.2 1.2.1 1.2.2 1.3 1.3.1 1.3.2 1.4
GENERAL SETTINGS ................................................................................................................... 4 Countries ............................................................................................................................... 4 Currency ............................................................................................................................... 4 Unit of measure ..................................................................................................................... 4 Calendar functions ................................................................................................................ 4 ENTERPRISE STRUCTURE ............................................................................................................ 4 Definition .............................................................................................................................. 4 Assignment ........................................................................................................................... 6 FINANCIAL ACCOUNTING ......................................................................................................... 6 Company code ....................................................................................................................... 6 Fi document ........................................................................................................................... 6 NOT CATEGORIZED .................................................................................................................... 6
2
BASIC DATA / ADMINISTRATION ................................................................................ 8
2.1 WORKBENCH RELATED TABLES ................................................................................................. 8 2.1.1 Data dictionary tables ........................................................................................................... 8 2.1.2 Workbench ............................................................................................................................. 8 2.2 ADMINISTRATION ...................................................................................................................... 8 2.2.1 User administration .............................................................................................................. 8 2.2.2 Batch input queue.................................................................................................................. 9 2.2.3 Job processing ........................................................................................................................ 9 2.2.4 Spool ...................................................................................................................................... 9 2.2.5 Runtime errors ...................................................................................................................... 9 2.2.6 Message control ..................................................................................................................... 9 2.2.7 EDI ........................................................................................................................................ 9 2.2.8 Change documents ................................................................................................................ 9 2.2.9 Reporting tree table ............................................................................................................... 9 2.2.10 LIS structure/control tables ................................................................................................... 9 3
MASTER DATA: .................................................................................................................. 10
3.1 3.1.1 3.1.2 3.2 3.3 3.4 3.5
MATERIAL MASTER: ................................................................................................................. 10 Basic data text (sap script) .................................................................................................. 10 Batches................................................................................................................................. 10 CUSTOMER MASTER DATA ....................................................................................................... 10 VENDOR ................................................................................................................................... 11 CUSTOMER – MATERIAL INFO RECORD.................................................................................... 11 BANK DATA.............................................................................................................................. 11
4
CHARACTERISTICS: ......................................................................................................... 12
4.1
CHARACTERISTICS: .................................................................................................................. 12
1
SAP Tables For All Modules.doc
Page 1
05/09/2008
BC – Tables in SAP
4.2 4.3
CLASS TYPES AND OBJECTS : .................................................................................................... 12 LINKS: ...................................................................................................................................... 12
5
FI/CO : ................................................................................................................................... 13
5.1 FI : ............................................................................................................................................ 13 5.1.1 Master data ......................................................................................................................... 13 5.1.2 Accounting documents // indices ........................................................................................ 13 5.1.3 Payment run ....................................................................................................................... 13 5.2 CO : .......................................................................................................................................... 13 5.2.1 Cost center master data ....................................................................................................... 13 5.2.2 Cost center accounting ........................................................................................................ 13 6
SALES AND DISTRIBUTION (SD) : ............................................................................... 15
6.1 6.2 6.3 6.4 6.5 6.6
SALES ORDER : .......................................................................................................................... 15 BILLING DOCUMENT : .............................................................................................................. 15 SHIPPING : ................................................................................................................................ 15 DELIVERY : ............................................................................................................................... 15 PRICING : .................................................................................................................................. 15 CONTRACTS : ............................................................................................................................ 15
7
MATERIAL MANAGEMENT (MM) : ............................................................................. 16
7.1 7.2
MATERIAL DOCUMENT ............................................................................................................ 16 PURCHASING ........................................................................................................................... 16
8
WAREHOUSE MANAGEMENT (WM) : ......................................................................... 17
8.1 8.2 8.3 8.4
TRANSFER REQUIREMENT ........................................................................................................ 17 TRANSFER ORDER .................................................................................................................... 17 MASTER DATA - STOCK POSITIONS .......................................................................................... 17 INVENTORY DOCUMENTS IN WM ........................................................................................... 17
9
QUALITY MANAGEMENT (QM) : ................................................................................. 18
9.1 9.2 9.3
INSPECTION LOT / INFO RECORD ............................................................................................. 18 QUALITY NOTIFICATION .......................................................................................................... 18 CERTIFICATE PROFILE .............................................................................................................. 18
10
PRODUCTION PLANNING (PP) ..................................................................................... 19
10.1 10.2 10.3 10.4 10.5 10.6 10.7 10.8 10.9
WORK CENTER ......................................................................................................................... 19 ROUTINGS/OPERATIONS .......................................................................................................... 19 BILL OF MATERIAL ................................................................................................................... 19 PRODUCTION ORDERS.............................................................................................................. 19 PLANNED ORDERS ................................................................................................................... 20 KANBAN ............................................................................................................................... 20 RESERVATIONS......................................................................................................................... 20 CAPACITY PLANNING .............................................................................................................. 20 PLANNED INDEPENDENT REQUIREMENTS............................................................................... 20
2
SAP Tables For All Modules.doc
Page 2
05/09/2008
BC – Tables in SAP
11
PROJECT SYSTEM (PS)...................................................................................................... 22
11.1 11.2
BASIC DATA.............................................................................................................................. 22 EQUIPMENT.............................................................................................................................. 22
12
PLANT MAINTENANCE (PM) ......................................................................................... 22
12.1 12.2 12.3 12.4
HUMAN RESOURCES ................................................................................................................ 23 SETTINGS .................................................................................................................................. 23 MASTER DATA ......................................................................................................................... 23 INFOTYPES ................................................................................................................................ 23
3
SAP Tables For All Modules.doc
Page 3
05/09/2008
BC – Tables in SAP
1
Customising
1.1
General settings
1.1.1 Countries T005
Countries
1.1.2 Currency TCURC TCURR TCURT TCURX
Currency codes Wisselkoersen Currency name Decimal places for currencies.
1.1.3 Unit of measure T006
Units of measure
1.1.4 Calendar functions T247 TFACD T015M TTZZ TTZD TTZDF TTZDV TTZDT TTZ5 TTZ5S
1.2
Month names Factory calendar definition Month names Time zones Summer time rules Summer time rules (fixed annual dates) Summer time rules (variable dates) Summer time rules texts Assign Time Tones to Countries Assign time zones to regions
Enterprise structure
1.2.1 Definition FI T880 T001 CO TKA01 LO T001W T499S TSPA SD TVKO TVTW TVBUR TVKBT TVKGR
Company Company code Controlling area Plant / sales organisation Locations Division Sales organisation / company code Distribution channel Sales office Sales office text Sales group
4
SAP Tables For All Modules.doc
Page 4
05/09/2008
BC – Tables in SAP
TVGRT T171T MM T001L T024E T3001 TVST TVLA TTDS
Sales group text Sales district text Storage locations Purchasing organization Warehouse number Shipping point Loading point Transportation
5
SAP Tables For All Modules.doc
Page 5
05/09/2008
BC – Tables in SAP
1.2.2 Assignment CO TKA02 LO T001K
Assign company code to controlling area Assign plant (valuation area) to company code
SD TVKO TVKOV TVKOS TVTA TVKBZ TVBVK TVKWZ MM T024E T024W T001K TVSWZ T320
Sales organisation / company code Distribution channel / sales organisation Division to sales organization Sales aria Sales office to sales area Sales group to sales office Plants to sales organization Purchasing organization / company code Plant to Purchase organization Link plant ( = valuation area) / company code Shipping point to plant Assignment MM Storage Location to WM Warehouse
1.3
Financial accounting
1.3.1 Company code T004 T077S T009 T880 T014
Chart of accounts Account group (g/l accounts) Fiscal year variants Global company data Credit control area
1.3.2 Fi document T010O T010P T001B T003 T012
1.4
Posting period variant Posting Period Variant Names Permitted Posting Periods Document types House banks
Not categorized T007a T134 T179 T179T TJ02T TINC TVFK T390
Tax keys Material types Materials: Product Hierarchies Materials: Product hierarchies: Texts Status text Customer incoterms Billing doc types PM: Shop papers for print control
6
SAP Tables For All Modules.doc
Page 6
05/09/2008
BC – Tables in SAP
7
SAP Tables For All Modules.doc
Page 7
05/09/2008
BC – Tables in SAP
2 2.1
Basic data / administration Workbench related tables
2.1.1 Data dictionary tables DD02L DD02T DD03L DD03T
Tables in SAP Tables description Field names in SAP Field description in SAP
2.1.2 Workbench TADIR TRDIR TFDIR TLIBG TLIBT TFTIT TSTC TSTCT T100 VARID D020T TDEVC TDEVCT
2.2
Directory of R/3 Repository Objects System table TRDIR Function Module Person responsible for function class Function Group Short Texts Function Module Short Text Transaction codes in SAP Transaction codes texts Message text (vb e000) Variant data Screen texts Development class Texts for development classes
Administration
2.2.1 User administration USR01 USR02 USR03 USR04 USR11 UST12 USR12 USR13 USR40 TOBJ TOBC TPRPROF DEVACCESS
User master Logon data User address data User master authorizations User Master Texts for Profiles (USR10) User 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
8
SAP Tables For All Modules.doc
Page 8
05/09/2008
BC – Tables in SAP
2.2.2 Batch input queue APQD APQI
DATA DEFINITION Queue Queue info definition
2.2.3 Job processing TBTCO TBTCP
Job status overview table 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 NAST NACH
Processing programs for output Message status Printer determination
2.2.7 EDI EDIDC EDIDD EDID2 EDIDS EDPAR EDPVW EDPI1 EDPO1/2/3
Control record Data record Data record 3.0 Version EDI status record Convert External < > Internal Partner Number EDI partner types EDI partner profile inbound EDI partner profile outbound
2.2.8 Change documents CDHDR CDPOS JCDS
Change document header Change document positioned 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
9
SAP Tables For All Modules.doc
Page 9
05/09/2008
BC – Tables in SAP
3 3.1
MASTER DATA: Material master: MARA MAKT MARC MVKE MARD MSKA MSPR MARM MEAN PGMI PROP MAPR MBEW MVER MLGN MLGT MPRP MDTB MDKP MLAN MTQSS
Material master Material text Material per plant / stock Material master, sales data Storage location / stock Sales order stock Project stock Units of measure International article number Planning material Forecast parameters Link MARC <=> PROP Material valuation Material consumption Material / Warehouse number Material / Storage type Forecast profiles MRP table Header data for MRP document Tax data material master Material master view: QM
3.1.1 Basic data text (sap script) STXB STXH STXL
SAP script: Texts in non-SAP script format STXD SAP script text file header STXD SAP script text file lines
3.1.2 Batches MCHA MCH1 MCHB
3.2
Batches Batches Stock: batches
Customer master data KNA1 KNB1 KNVV KNBK KNVH KNVP
Customer master Customer / company Customer sales data Bank details Customer hierarchy Customer partners
10
SAP Tables For All Modules.doc
Page 10
05/09/2008
BC – Tables in SAP
KNVS KNVK KNVI
3.3
Vendor LFA1 LFB1 LFB5 LFM1 LFM2 LFBK
3.4
Vendor master Vendor per company code Vendor dunning data Purchasing organization data Purchasing data Bank details
Customer – material info record KNMT
3.5
Shipment data for customer Contact persons Customer master tax indicator
Customer material info record
Bank data BNKA
Master bank data
11
SAP Tables For All Modules.doc
Page 11
05/09/2008
BC – Tables in SAP
4 4.1
Characteristics: Characteristics: CABN CABNT CAWN CAWNT AUSP
4.2
Class types and objects : TCLAO TCLA TCLAT TCLT TCLC
4.3
Characteristics ( o.a. batch/vendor) Characteristics description Characteristics ( o.a. material) Characteristics description Characteristic Values
Several class types for object Class types ( vb. lfa1 => v10 en 010) Class type text Classifiable objects Classification status
Links: INOB KLAH KSSK KSML
Link between Internal Number and Object Class header data Allocation Table: Object (vb.matnr) to Class Characteristics for a class (internal number)
12
SAP Tables For All Modules.doc
Page 12
05/09/2008
BC – Tables in SAP
5 5.1
FI/CO : FI :
5.1.1 Master data SKA1 BNKA
Accounts Bank master record
5.1.2 Accounting documents // indices BKPF BSEG BSID BSIK BSIM BSIP BSIS BSAD BSAK BSAS
Accounting documents item level Accounting: Secondary index for customers Accounting: Secondary index for vendors Secondary Index, Documents for Material Index for vendor validation of double documents Accounting: Secondary index for G/L accounts Accounting: Index for customers (cleared items) Accounting: Index for vendors (cleared items) Accounting: Index for G/L accounts (cleared items)
5.1.3 Payment run REGUH REGUP
5.2
Settlement data from payment program Processed items from payment program
CO : TKA01 TKA02 KEKO KEPH KALO KANZ
Controlling areas Controlling area assignment Product-costing header Cost components for cost of goods manuf. Costing objects Sales order items - costing objects
5.2.1 Cost center master data CSKS CSKT CRCO
Cost Center Master Data Cost center texts Assignment of Work Center to Cost Center
5.2.2 Cost center accounting
.
COSP COEP COBK COST
CO Object: Cost Totals for External Postings CO Object: Line Items (by Period) CO Object: Document header CO Object: Price Totals
13
SAP Tables For All Modules.doc
Page 13
05/09/2008
BC – Tables in SAP
14
SAP Tables For All Modules.doc
Page 14
05/09/2008
BC – Tables in SAP
6
Sales and Distribution (SD) : VBFA VTFA
6.1
Sales order : VBAK VBAP VBPA VBKD VBEP
6.2
Delivery header Delivery item
Pricing : KONH KONP KONV KOND
6.6
Shipment header Shipment item Stage in transport Stage in transport per shipment item Shipment partners Handling Unit - Header Table Packing: Handling Unit Item (Contents)
Delivery : LIKP LIPS
6.5
header data Item data
Shipping : VTTK VTTP VTTS VTSP VTPA VEKP VEPO
6.4
Header data Item data Partners in sales order Sales district data Data related to line items, delivery lines
Billing document : VBRK VBRP
6.3
Document flow (alg.) Flow shipping documents
Conditions header Conditions items Procedure ( billing doc or sales order)
contracts : VEDA
Contract data
15
SAP Tables For All Modules.doc
Page 15
05/09/2008
BC – Tables in SAP
7 7.1
Material Management (MM) : Material document MKPF MSEG
7.2
material document material document (item level)
Purchasing EKKO EKPO EKPV EKET VETVG EKES EKKN EKAN EKPA EIPO EINA EINE EORD EBAN EBKN
Purchase document Purchase document (item level) Shipping-Specific Data on Stock Tfr. for Purch. Doc. Item Delivery schedule Delivery Due Index for Stock Transfer Order Acceptance/Fulfillment Confirmations Account assignment in purchasing Vendor address purchasing Partner functions Item export / import data Purchase info record (main data) Purchase info record (organisational data) Source list Purchase requisition Purchase Requisition Account Assignment
16
SAP Tables For All Modules.doc
Page 16
05/09/2008
BC – Tables in SAP
8 8.1
Warehouse Management (WM) : Transfer requirement LTBK LTBP
8.2
Transfer order LTAK LTAP
8.3
Transfer order - header Transfer order - item
Master data - stock positions LQUA
8.4
Transfer requirement - header Transfer requirement - item
Quants
Inventory documents in WM LINK LINP LINV
Inventory document header Inventory document item Inventory data per quant
17
SAP Tables For All Modules.doc
Page 17
05/09/2008
BC – Tables in SAP
9
9.1
Quality Management (QM) :
Inspection lot / info record QALS QAMB QAVE QDPS QMAT QINF QDQL QDPS
9.2
Quality notification TQ80 QMEL QMFE QMUR QMSM QMMA QMIH
9.3
Inspection lot record Link inspection lot - material document Inspection usage decision Inspection stages Inspection type - material parameters Inspection info record (vendor - material) Quality level Inspection stages
Notification types Quality notification Quality notification – items Quality notification – causes Quality notification – tasks Quality notification – activities Quality message - maintenance data excerpt
Certificate profile QCVMT QCVM QCVK
Certificate profile characteristic level: texts Certificate profile characteristic level Certificate profile header
18
SAP Tables For All Modules.doc
Page 18
05/09/2008
BC – Tables in SAP
10 Production Planning (PP) 10.1 Work center CRHH CRHS CRHD CRTX Resource/Tool CRCO KAKO CRCA TC24
Work center hierarchy Hierarchy structure Work center header Text for the Work Center or Production Assignment of Work Center to Cost Center Capacity Header Segment Work Center Capacity Allocation Person responsible for the workcenter
10.2 Routings/operations MAPL PLAS PLFH PLFL PLKO PLKZ PLPH PLPO PLPR PLMZ
Allocation of task lists to materials Task list - selection of operations/activities Task list - production resources/tools Task list - sequences Task list - header Task list: main header Phases / suboperations Task list operation / activity Log collector for tasklists Allocation of BOM - items to operations
10.3 Bill of material STKO STPO STAS STPN STPU STZU PLMZ MAST KDST
BOM - header BOM - item BOMs - Item Selection BOMs - follow-up control BOM - sub-item Permanent BOM data Allocation of BOM - items to operations Material to BOM link Sales order to BOM link
10.4 Production orders AUFK AFIH AUFM AFKO
Production order headers Maintenance order header Goods movement for prod. order Order header data PP orders
19
SAP Tables For All Modules.doc
Page 19
05/09/2008
BC – Tables in SAP
AFPO RESB AFVC AFVV AFVU AFFL AFFH JSTO JEST AFRU
Order item Order componenten Order operations Quantities/dates/values in the operation User fields of the operation Work order sequence PRT assignment data for the work order(routing) Status profile Object status Order completion confirmations
PRT’s voor production orders AFFH CRVD_A DRAW TDWA TDWD TDWE
PRT assignment data for the work order Link of PRT to Document Document Info Record Document Types Data Carrier/Network Nodes Data Carrier Type
10.5 Planned orders PLAF
Planned orders
10.6 KANBAN PKPS PKHD PKER
Kanban identification, control cycle Kanban control cycle (header data) Error log for Kanban containers
10.7 Reservations RESB RKPF
Material reservations header
10.8 Capacity planning KBKO KBED KBEZ capacities/splits)
Header record for capacity requirements Capacity requirements records Add. data for table KBED (for indiv.
10.9 Planned independent requirements PBIM PBED PBHI PBIV
Independent requirements for material Independent requirement data Independent requirement history Independent requirement index
PBIC
Independent requirement index for customer req.
20
SAP Tables For All Modules.doc
Page 20
05/09/2008
BC – Tables in SAP
21
SAP Tables For All Modules.doc
Page 21
05/09/2008
BC – Tables in SAP
11 Project system (PS) 11.1 Basic data PRHI PROJ PRPS
Work Breakdown Structure, Edges (Hierarchy Pointer) Project definition WBS (Work Breakdown Structure) Element Master Data
RPSCO MSPR
Project info database: Costs, revenues, finances Project stock
11.2 Equipment EQUI EQKT EQUZ
Equipment master data Equipment short text Equipment time segment
12 Plant maintenance (PM) IHPA OBJK ILOA AFIH
Plant Maintenance: Partners Plant Maintenance Object List PM Object Location and Account Assignment Maintenance order header
22
SAP Tables For All Modules.doc
Page 22
05/09/2008
BC – Tables in SAP
12.1 Human resources 12.2 Settings T582A
Infotypes: Customer-Specific Settings
12.3 Master data T527X T528T T554T T501
Organizational Units Position Texts Attendance and Absence Texts Employee group
T503 T503K T510N T549A T750X
Employee group, subgroup Employee subgroup Pay Scales for Annual Salaries (NA) Payroll Accounting Areas Vacancy
12.4 Infotypes PA0001 PA0002 PA0006 PA0007 PA0016 PA0008 PA0105 PA1007 PA1035 PA2001
Org. Assignment Personal Data Addresses Planned Working Time Contract elements Basic pay Communications Vacancies Training Absences
Other important table JEST TJ02
System Status with object number System status description.
MRP Related MDKP MDTB MDVL MDVM PBVPV REUL SAFK 23
Header Data for MRP Document MRP Table Planning file entry for long term planning Enry in MRP file Material Index for consumption of planning Material stock transfer reservation index Run schedule master data
SAP Tables For All Modules.doc
Page 23
05/09/2008
BC – Tables in SAP
SQ01 EDMSG
Abap query ALE message type table
If you liked the document kindly share it with your friends and tell them to visit www.sap-topjobs.com
24
SAP Tables For All Modules.doc
Page 24
05/09/2008
Related Documents
Sap Tables For All Modules
May 2020 4
Sap Tables
May 2020 1
Sap Tables
November 2019 9
Sap Modules Overview
May 2020 0
List Of All Modules
June 2020 14