SAP table MPOS (Maintenance item)

SAP table MPOS has 2 primary key fields being MANDT,WAPOS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
WAPOS Maintenance item CHAR 16 0 WAPOS
WARPL Maintenance Plan CHAR 12 0 MPLA WARPL
WSTRA Maintenance Strategy CHAR 6 0 T351 STRAT
WPPOS Item in the maintenance plan NUMC 4 0 WPPOS
PSTXT Item Short Text CHAR 40 0 POSTXT
EQUNR Equipment Number CHAR 18 0 EQUI EQUNR
OBKNR Object list number INT8 19 0 OBJKNR
ERKNZ Creation Indicator CHAR 1 0 ERKNZ
AEKNZ Change indicator CHAR 1 0 AEKNZ
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERSDT Date of creation DATS 8 0 EDATUM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
PLNTY Task List Type CHAR 1 0 TCA01 PLNTY
PLNNR Key for Task List Group CHAR 8 0 PLNNR
PLNAL Group Counter CHAR 2 0 PLNAL
STATUS Maintenance Item Status CHAR 1 0 MPSTAT
LTKNZ Long Text Indicator CHAR 1 0 MPLTX
WPGRP Planner Group for Customer Service and Plant Maintenance CHAR 3 0 T024I INGRP
OBJTY Object types of the CIM resource CHAR 2 0 CR_OBJTY
A Work Center
AA Work center alias
FH Production resources/tools
G Group
H Hierarchy
GEWRK Object ID of the Work Center NUMC 8 0 CRID LGWID
IWERK Maintenance Planning Plant CHAR 4 0 T399I IWERK
LANGU Language key of the long text LANG 1 0 MPLANGU
ILOAN Location and account assignment for technical object CHAR 12 0 ILOA ILOAN
ILOAI ILOA Individual CHAR 1 0 ILOAI
LAUFN Order number CHAR 12 0 AUFK LAUFN
BAUTL Assembly CHAR 40 0 MARA BAUTL
ANLZU System Condition CHAR 1 0 ANLZU
AUART Order Type CHAR 4 0 T003O AUFART
INACT Indicator that maintenance item is inactive CHAR 1 0 INACT
ILART Maintenance activity type CHAR 3 0 T353I ILA
GSBER Business Area CHAR 4 0 TGSB GSBER
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
IND_ABRVO Indicator showing settlement rule maintained CHAR 1 0 IND_ABRVO
PSPEL Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
STD_NETZ Key for Task List Group CHAR 8 0 PLNNR
STD_AVO Number of the Task List Node NUMC 8 0 PLNKN
KDAUF Sales Document CHAR 10 0 VBELN_VA
KDPOS Sales Document Item NUMC 6 0 POSNR_VA
MITYP Maintenance item category CHAR 2 0 T399P MITYP
BSTNR Purchase order number CHAR 10 0 BSTNR
BSTPO Purchase order item number NUMC 5 0 BSTPO
PACKNO Package number NUMC 10 0 PACKNO
NETPR Net Price CURR 11 2 NETPR
WAERS Currency Key CUKY 5 0 TCURC WAERS
SAKTO Cost Element CHAR 10 0 KSTAR
AUFNR Settlement order CHAR 12 0 ILOM_ORDST
APFKT Execution factor for whole task list DEC 3 0 APFKT
SCRRENTY SCREEN TYPE: for order-order category (see domain) CHAR 4 0 SCREENTY
SERIALNR Serial Number CHAR 18 0 GERNR
SERMAT Material Number CHAR 40 0 MARA MATNR
DEVICEID Additional Device Data CHAR 40 0 DEVICEID
QMNUM Notification Number CHAR 12 0 QMEL QMNUM
QMART Notification Type CHAR 2 0 TQ80 QMART
LBLNI Entry Sheet Number CHAR 10 0 LBLNI
TASK_DETERMINE Automatic task determination in the notification CHAR 1 0 TASK_DETERMINE
PRIOK Priority CHAR 1 0 T356 PRIOK
QMKAT Catalog Type - Coding CHAR 1 0 QMKAT
QMGRP Code Group - Coding CHAR 8 0 QMGRP
DUMMY_MPOS_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
QMCOD Coding CHAR 4 0 QMCOD
PHYNR Material Sample Number CHAR 12 0 QPHYSPRNR
ART Inspection Type CHAR 8 0 QPART
PRUEFLOS Inspection Lot Number NUMC 12 0 QPLOS
TSTMP_BW Time Stamp for BI Delta Extraction DEC 16 0 TSTMP_BW_EXT
NO_AUFRELKZ Do Not Release Immediately CHAR 1 0 NO_AUFRELKZ
SERVICE_DOCUMENT_TYPE Business Transaction Type CHAR 4 0 CRMT_PROCESS_TYPE
SERVICE_CONTRACT Transaction ID CHAR 10 0 CRMT_OBJECT_ID_DB
SERVICE_CONTRACT_ITEM Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
SERVICE_TEMPLATE Transaction ID CHAR 10 0 CRMT_OBJECT_ID_DB
SERVICE_PRIORITY Activity Priority NUMC 1 0 * CRMT_PRIORITY
PRODUCT Product Number CHAR 40 0 * PRODUCTNUMBER
DESNUM CU: Design Number CHAR 12 0 * /CUM/DESNUM
CYCLESEQIND Cycle Set Sequence NUMC 2 0 CYCLESETSEQ
ADPSP Reference Element PM/PS CHAR 40 0 ADDCOMPARE_CORE
IND_MPOS_API Maintenance Item Was Created/Changed by API CHAR 2 0 IND_MPOS_API
RBNR Catalog Profile CHAR 9 0 * RBNR
RBNRI Origin of catalog profile CHAR 1 0 EAM_RBNRI_MITEM
0 Maintenance Plan Category
1 Equipment Master Record
2 Functional Location Master Record
3 Individual Maintenance Catalog
4 Material Master Record

MPOS foreign key relationships

Table Field Check Table Check Field
0 MPOS AUART T003O Order Types AUART
1 MPOS BAUTL MARA General Material Data MANDT
1 MPOS BAUTL MARA General Material Data MATNR
0 MPOS EQUNR EQUI Equipment master data MANDT
1 MPOS GEWRK CRID CIM Resource - Entities MANDT
1 MPOS GEWRK CRID CIM Resource - Entities OBJID
0 MPOS GSBER TGSB Business Areas MANDT
0 MPOS GSBER TGSB Business Areas GSBER
1 MPOS ILART T353I Maintenance activity types MANDT
1 MPOS ILART T353I Maintenance activity types ILART
0 MPOS ILOAN ILOA PM Object Location and Account Assignment MANDT
0 MPOS ILOAN ILOA PM Object Location and Account Assignment ILOAN
1 MPOS IWERK T399I Planning plant parameters MANDT
0 MPOS LAUFN AUFK Order master data AUFNR
1 MPOS MANDT T000 Clients MANDT
0 MPOS MITYP T399P Maintenance item category parameter MANDT
0 MPOS MITYP T399P Maintenance item category parameter MITYP
1 MPOS OBJNR ONR00 General Object Number MANDT
0 MPOS PLNTY TCA01 Task list types MANDT
1 MPOS PRIOK T356 Priorities MANDT
1 MPOS PRIOK T356 Priorities ARTPR
0 MPOS QMART TQ80 Notification Types MANDT
0 MPOS QMART TQ80 Notification Types QMART
1 MPOS QMNUM QMEL Quality Notification MANDT
1 MPOS QMNUM QMEL Quality Notification QMNUM
0 MPOS SERMAT MARA General Material Data MANDT
0 MPOS SERMAT MARA General Material Data MATNR
1 MPOS WAERS TCURC Currency Codes MANDT
1 MPOS WAERS TCURC Currency Codes WAERS
0 MPOS WARPL MPLA Maintenance plan WARPL
1 MPOS WPGRP T024I Maintenance planner groups INGRP
0 MPOS WSTRA T351 Maintenance strategy MANDT