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
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
X Flag set. Event has occurred.
NULL Flag is Not Set
AEKNZ Change indicator AEKNZ CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
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
X Flag set. Event has occurred.
NULL Flag is Not Set
LTKNZ Long Text Indicator MPLTX CHAR 1 0
X Yes
NULL No
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
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
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
X Yes
NULL No
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
X Flag set. Event has occurred.
NULL Flag is Not Set
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
X Yes
NULL No
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
C Business Object Was Created by API (Created)
U Business Object Was Changed by API (Update)
CU Business Object Was Created/Changed by API

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 MANDT EQUI Equipment master data MANDT
MPOS EQUNR MPOS EQUNR EQUI Equipment master data EQUNR
MPOS GEWRK MPOS OBJTY CRID CIM Resource - Entities OBJTY
MPOS GEWRK MPOS GEWRK CRID CIM Resource - Entities OBJID
MPOS GEWRK MPOS MANDT CRID CIM Resource - Entities MANDT
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 ILOAN ILOA PM Object Location and Account Assignment ILOAN
MPOS ILOAN MPOS MANDT ILOA PM Object Location and Account Assignment MANDT
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 MITYP T399P Maintenance item category parameter MITYP
MPOS MITYP MPOS MANDT T399P Maintenance item category parameter MANDT
MPOS OBJNR MPOS MANDT ONR00 General Object Number MANDT
MPOS OBJNR MPOS OBJNR ONR00 General Object Number OBJNR
MPOS PLNTY MPOS MANDT TCA01 Task list types MANDT
MPOS PLNTY MPOS PLNTY TCA01 Task list types PLNTY
MPOS PRIOK * T356 Priorities ARTPR
MPOS PRIOK MPOS PRIOK T356 Priorities PRIOK
MPOS PRIOK MPOS MANDT T356 Priorities MANDT
MPOS QMART MPOS MANDT TQ80 Notification Types MANDT
MPOS QMART MPOS QMART TQ80 Notification Types QMART
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 WARPL MPLA Maintenance plan WARPL
MPOS WARPL MPOS MANDT MPLA Maintenance plan MANDT
MPOS WPGRP MPOS WPGRP T024I Maintenance planner groups INGRP
MPOS WPGRP MPOS MANDT T024I Maintenance planner groups MANDT
MPOS WPGRP MPOS IWERK T024I Maintenance planner groups IWERK
MPOS WSTRA MPOS MANDT T351 Maintenance strategy MANDT
MPOS WSTRA MPOS WSTRA T351 Maintenance strategy STRAT