SAP Table MPOS
Maintenance item
MPOS (Maintenance item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MPOS to other SAP tables.
MPOS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
WAPOS
Maintenance item
|
WAPOS |
CHAR
|
16 | 0 | ||||||||||||
|
WARPL
Maintenance Plan
|
WARPL | MPLA |
CHAR
|
12 | 0 | |||||||||||
|
WSTRA
Maintenance strategy
|
STRAT | T351 |
CHAR
|
6 | 0 | |||||||||||
|
WPPOS
Item in the maintenance plan
|
WPPOS |
NUMC
|
4 | 0 | ||||||||||||
|
PSTXT
Item Short Text
|
POSTXT |
CHAR
|
40 | 0 | ||||||||||||
|
EQUNR
Equipment Number
|
EQUNR | EQUI |
CHAR
|
18 | 0 | |||||||||||
|
OBKNR
Object list number
|
OBJKNR |
INT4
|
10 | 0 | ||||||||||||
|
ERKNZ
Creation indicator
|
ERKNZ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
AEKNZ
Change indicator
|
AEKNZ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||||
|
ERSDT
Date of creation
|
EDATUM |
DATS
|
8 | 0 | ||||||||||||
|
AEDAT
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||||
|
AENAM
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||||||
|
PLNTY
Task List Type
|
PLNTY | TCA01 |
CHAR
|
1 | 0 | |||||||||||
|
PLNNR
Key for Task List Group
|
PLNNR |
CHAR
|
8 | 0 | ||||||||||||
|
PLNAL
Group Counter
|
PLNAL |
CHAR
|
2 | 0 | ||||||||||||
|
STATUS
Maintenance Item Status
|
MPSTAT |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
LTKNZ
Long Text Indicator
|
MPLTX |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
WPGRP
Planner Group for Customer Service and Plant Maintenance
|
INGRP | T024I |
CHAR
|
3 | 0 | |||||||||||
|
OBJTY
Object types of the CIM resource
|
CR_OBJTY |
CHAR
|
2 | 0 | ||||||||||||
|
||||||||||||||||
|
GEWRK
Object ID of the Work Center
|
LGWID | CRID |
NUMC
|
8 | 0 | |||||||||||
|
IWERK
Maintenance Planning Plant
|
IWERK | T399I |
CHAR
|
4 | 0 | |||||||||||
|
LANGU
Language key of the long text
|
MPLANGU |
LANG
|
1 | 0 | ||||||||||||
|
ILOAN
Location and account assignment for technical object
|
ILOAN | ILOA |
CHAR
|
12 | 0 | |||||||||||
|
ILOAI
ILOA Individual
|
ILOAI |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
LAUFN
Order number
|
LAUFN | AUFK |
CHAR
|
12 | 0 | |||||||||||
|
BAUTL
Assembly
|
BAUTL | MARA |
CHAR
|
18 | 0 | |||||||||||
|
ANLZU
Syst.Condition
|
ANLZU |
CHAR
|
1 | 0 | ||||||||||||
|
AUART
Order Type
|
AUFART | T003O |
CHAR
|
4 | 0 | |||||||||||
|
INACT
Indicator that maintenance item is inactive
|
INACT |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ILART
Maintenance activity type
|
ILA | T353I |
CHAR
|
3 | 0 | |||||||||||
|
GSBER
Business Area
|
GSBER | TGSB |
CHAR
|
4 | 0 | |||||||||||
|
OBJNR
Object number
|
J_OBJNR | ONR00 |
CHAR
|
22 | 0 | |||||||||||
|
IND_ABRVO
Indicator showing settlement rule maintained
|
IND_ABRVO |
CHAR
|
1 | 0 | ||||||||||||
|
PSPEL
Work Breakdown Structure Element (WBS Element)
|
PS_PSP_PNR |
NUMC
|
8 | 0 | ||||||||||||
|
STD_NETZ
Key for Task List Group
|
PLNNR |
CHAR
|
8 | 0 | ||||||||||||
|
STD_AVO
Number of the task list node
|
PLNKN |
NUMC
|
8 | 0 | ||||||||||||
|
KDAUF
Sales Document
|
VBELN_VA |
CHAR
|
10 | 0 | ||||||||||||
|
KDPOS
Sales Document Item
|
POSNR_VA |
NUMC
|
6 | 0 | ||||||||||||
|
MITYP
Maintenance item category
|
MITYP | T399P |
CHAR
|
2 | 0 | |||||||||||
|
BSTNR
Purchase Order Number
|
BSTNR |
CHAR
|
10 | 0 | ||||||||||||
|
BSTPO
Purchase Order Item Number
|
BSTPO |
NUMC
|
5 | 0 | ||||||||||||
|
PACKNO
Package number
|
PACKNO |
NUMC
|
10 | 0 | ||||||||||||
|
NETPR
Net price
|
NETPR |
CURR
|
11 | 2 | ||||||||||||
|
WAERS
Currency Key
|
WAERS | TCURC |
CUKY
|
5 | 0 | |||||||||||
|
SAKTO
Cost Element
|
KSTAR |
CHAR
|
10 | 0 | ||||||||||||
|
AUFNR
Settlement order
|
ILOM_ORDST |
CHAR
|
12 | 0 | ||||||||||||
|
APFKT
Execution factor for whole task list
|
APFKT |
DEC
|
3 | 0 | ||||||||||||
|
SCRRENTY
SCREEN TYPE: for order-order category (see domain)
|
SCREENTY |
CHAR
|
4 | 0 | ||||||||||||
|
SERIALNR
Serial Number
|
GERNR |
CHAR
|
18 | 0 | ||||||||||||
|
SERMAT
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||||||
|
DEVICEID
Additional Device Data
|
DEVICEID |
CHAR
|
40 | 0 | ||||||||||||
|
QMNUM
Notification No
|
QMNUM | QMEL |
CHAR
|
12 | 0 | |||||||||||
|
QMART
Notification Type
|
QMART | TQ80 |
CHAR
|
2 | 0 | |||||||||||
|
LBLNI
Entry Sheet Number
|
LBLNI |
CHAR
|
10 | 0 | ||||||||||||
|
TASK_DETERMINE
Automatic task determination in the notification
|
TASK_DETERMINE |
CHAR
|
1 | 0 | ||||||||||||
|
PRIOK
Priority
|
PRIOK | T356 |
CHAR
|
1 | 0 | |||||||||||
|
QMKAT
Catalog Type - Coding
|
QMKAT |
CHAR
|
1 | 0 | ||||||||||||
|
QMGRP
Code Group - Coding
|
QMGRP |
CHAR
|
8 | 0 | ||||||||||||
|
QMCOD
Coding
|
QMCOD |
CHAR
|
4 | 0 | ||||||||||||
|
PHYNR
Physical Sample Number
|
QPHYSPRNR |
CHAR
|
12 | 0 | ||||||||||||
|
ART
Inspection Type
|
QPART |
CHAR
|
8 | 0 | ||||||||||||
|
PRUEFLOS
Inspection Lot Number
|
QPLOS |
NUMC
|
12 | 0 | ||||||||||||
|
TSTMP_BW
Time Stamp for BI Delta Extraction
|
TSTMP_BW_EXT |
DEC
|
16 | 0 | ||||||||||||
|
NO_AUFRELKZ
Do Not Release Immediately
|
NO_AUFRELKZ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
DESNUM
CU: Design Number
|
/CUM/DESNUM |
CHAR
|
12 | 0 | ||||||||||||
|
CYCLESEQIND
Cycle Set Sequence
|
CYCLESETSEQ |
NUMC
|
2 | 0 | ||||||||||||
|
ADPSP
Reference Element PM/PS
|
ADDCOMPARE_CORE |
CHAR
|
40 | 0 | ||||||||||||
|
IND_MPOS_API
Maintenance Item Was Created/Changed by API
|
IND_MPOS_API |
CHAR
|
2 | 0 | ||||||||||||
|
||||||||||||||||
MPOS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| MPOS | AUART | MPOS | MANDT |
T003O
Order Types
|
CLIENT |
| MPOS | AUART | MPOS | AUART |
T003O
Order Types
|
AUART |
| MPOS | BAUTL | MPOS | MANDT |
MARA
General Material Data
|
MANDT |
| MPOS | BAUTL | MPOS | BAUTL |
MARA
General Material Data
|
MATNR |
| MPOS | EQUNR | MPOS | EQUNR |
EQUI
Equipment master data
|
EQUNR |
| MPOS | EQUNR | MPOS | MANDT |
EQUI
Equipment master data
|
MANDT |
| MPOS | GEWRK | MPOS | MANDT |
CRID
CIM Resource - Entities
|
MANDT |
| MPOS | GEWRK | MPOS | OBJTY |
CRID
CIM Resource - Entities
|
OBJTY |
| MPOS | GEWRK | MPOS | GEWRK |
CRID
CIM Resource - Entities
|
OBJID |
| MPOS | GSBER | MPOS | MANDT |
TGSB
Business Areas
|
MANDT |
| MPOS | GSBER | MPOS | GSBER |
TGSB
Business Areas
|
GSBER |
| MPOS | ILART | MPOS | MANDT |
T353I
Maintenance activity types
|
MANDT |
| MPOS | ILART | MPOS | ILART |
T353I
Maintenance activity types
|
ILART |
| MPOS | ILOAN | MPOS | MANDT |
ILOA
PM Object Location and Account Assignment
|
MANDT |
| MPOS | ILOAN | MPOS | ILOAN |
ILOA
PM Object Location and Account Assignment
|
ILOAN |
| MPOS | IWERK | MPOS | MANDT |
T399I
Planning plant parameters
|
MANDT |
| MPOS | IWERK | MPOS | IWERK |
T399I
Planning plant parameters
|
IWERK |
| MPOS | LAUFN | MPOS | MANDT |
AUFK
Order master data
|
MANDT |
| MPOS | LAUFN | MPOS | LAUFN |
AUFK
Order master data
|
AUFNR |
| MPOS | MANDT | MPOS | MANDT |
T000
Clients
|
MANDT |
| MPOS | MITYP | MPOS | MANDT |
T399P
Maintenance item category parameter
|
MANDT |
| MPOS | MITYP | MPOS | MITYP |
T399P
Maintenance item category parameter
|
MITYP |
| MPOS | OBJNR | MPOS | OBJNR |
ONR00
General Object Number
|
OBJNR |
| MPOS | OBJNR | MPOS | MANDT |
ONR00
General Object Number
|
MANDT |
| MPOS | PLNTY | MPOS | MANDT |
TCA01
Task list types
|
MANDT |
| MPOS | PLNTY | MPOS | PLNTY |
TCA01
Task list types
|
PLNTY |
| MPOS | PRIOK | MPOS | MANDT |
T356
Priorities
|
MANDT |
| MPOS | PRIOK | * |
T356
Priorities
|
ARTPR | |
| MPOS | PRIOK | MPOS | PRIOK |
T356
Priorities
|
PRIOK |
| MPOS | QMART | MPOS | QMART |
TQ80
Notification Types
|
QMART |
| MPOS | QMART | MPOS | MANDT |
TQ80
Notification Types
|
MANDT |
| MPOS | QMNUM | MPOS | MANDT |
QMEL
Quality Notification
|
MANDT |
| MPOS | QMNUM | MPOS | QMNUM |
QMEL
Quality Notification
|
QMNUM |
| MPOS | SERMAT | MPOS | MANDT |
MARA
General Material Data
|
MANDT |
| MPOS | SERMAT | MPOS | SERMAT |
MARA
General Material Data
|
MATNR |
| MPOS | WAERS | MPOS | MANDT |
TCURC
Currency Codes
|
MANDT |
| MPOS | WAERS | MPOS | WAERS |
TCURC
Currency Codes
|
WAERS |
| MPOS | WARPL | MPOS | MANDT |
MPLA
Maintenance plan
|
MANDT |
| MPOS | WARPL | MPOS | WARPL |
MPLA
Maintenance plan
|
WARPL |
| MPOS | WPGRP | MPOS | MANDT |
T024I
Maintenance planner groups
|
MANDT |
| MPOS | WPGRP | MPOS | IWERK |
T024I
Maintenance planner groups
|
IWERK |
| MPOS | WPGRP | MPOS | WPGRP |
T024I
Maintenance planner groups
|
INGRP |
| MPOS | WSTRA | MPOS | MANDT |
T351
Maintenance strategy
|
MANDT |
| MPOS | WSTRA | MPOS | WSTRA |
T351
Maintenance strategy
|
STRAT |