MPOS SAP (Maintenance item) Table details

Dictionary Type: Table
Description: Maintenance item




ABAP Code to SELECT data from MPOS
Related tables to MPOS
Access table MPOS




Table field list including key, data, relationships and ABAP select examples

MPOS is a standard SAP Table which is used to store Maintenance item data and is available within R/3 SAP systems depending on the version and release level.

The MPOS table consists of various fields, each holding specific information or linking keys about Maintenance item data available in SAP. These include WAPOS (Maintenance item), WARPL (Maintenance Plan), WSTRA (Maintenance strategy), WPPOS (Item in the maintenance plan).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP MPOS table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
WAPOSMaintenance item WAPOSCHAR16ALPHAPOSNUMPSMPOSL
WARPLMaintenance Plan WARPLCHAR12MPLAALPHAWARPLMPLMPLAL
WSTRAMaintenance strategy STRATCHAR6T351WSTRASTRSTRAA
WPPOSItem in the maintenance plan WPPOSNUMC4WPPOS
PSTXTItem Short Text POSTXTCHAR40TEXT40
EQUNREquipment Number EQUNRCHAR18EQUIALPHAEQUNREQNEQUI
OBKNRObject list number OBJKNRINT410Assigned to domainOBJKN
ERKNZCreation indicator ERKNZCHAR1FLAG
AEKNZChange indicator AEKNZCHAR1FLAG
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERSDTDate of creation EDATUMDATS8DATUM
AEDATChanged On AEDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
PLNTYTask List Type PLNTYCHAR1TCA01PLNTYPTYH_TCA01
PLNNRKey for Task List Group PLNNRCHAR8ALPHAPLNNRPLNPLKS
PLNALGroup Counter PLNALCHAR2ALPHAALTNRPAL
STATUSMaintenance Item Status MPSTATCHAR1FLAG
LTKNZLong Text Indicator MPLTXCHAR1XFELD
WPGRPPlanner Group for Customer Service and Plant Maintenance INGRPCHAR3T024IINGRPIHG
OBJTYObject types of the CIM resource CR_OBJTYCHAR2CR_OBJTY
GEWRKObject ID of the Work Center LGWIDNUMC8CRIDCR_OBJID
IWERKMaintenance Planning Plant IWERKCHAR4T399IWERKSIWK
LANGULanguage key of the long text MPLANGULANG1Assigned to domainISOLASPRAS
ILOANLocation and account assignment for technical object ILOANCHAR12ILOAILOAN
ILOAIILOA Individual ILOAICHAR1X
LAUFNOrder number LAUFNCHAR12AUFKALPHAAUFNRANR
BAUTLAssembly BAUTLCHAR18MARAMATN1MATNRMAT
ANLZUSyst.Condition ANLZUCHAR1Assigned to domainANLZU
AUARTOrder Type AUFARTCHAR4T003OAUFARTAAT
INACTIndicator that maintenance item is inactive INACTCHAR1FLAG
ILARTMaintenance activity type ILACHAR3T353IILARTH_T350I
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
IND_ABRVOIndicator showing settlement rule maintained IND_ABRVOCHAR1CHAR01
PSPELWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
STD_NETZKey for Task List Group PLNNRCHAR8ALPHAPLNNRPLNPLKS
STD_AVONumber of the task list node PLNKNNUMC8KNTNR
KDAUFSales Document VBELN_VACHAR10Assigned to domainALPHAVBELNAUN
KDPOSSales Document Item POSNR_VANUMC6Assigned to domainPOSNRAPO
MITYPMaintenance item category MITYPCHAR2T399PCHAR2
BSTNRPurchase Order Number BSTNRCHAR10Assigned to domainALPHAEBELNBES
BSTPOPurchase Order Item Number BSTPONUMC5Assigned to domainEBELP
PACKNOPackage number PACKNONUMC10Assigned to domainPACKNO
NETPRNet price NETPRCURR11(2) WERTV6
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
SAKTOCost Element KSTARCHAR10Assigned to domainALPHAKSTARKAT
AUFNRSettlement order ILOM_ORDSTCHAR12Assigned to domainALPHAAUFNRORDE
APFKTExecution factor for whole task list APFKTDEC3AFAKT
SCRRENTYSCREEN TYPE: for order-order category (see domain) SCREENTYCHAR4CHAR4
SERIALNRSerial Number GERNRCHAR18GERNRGERNRSER
SERMATMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
DEVICEIDAdditional Device Data DEVICEIDCHAR40DEVICEID
QMNUMNotification No QMNUMCHAR12QMELALPHAQMNUMIQM
QMARTNotification Type QMARTCHAR2TQ80QMARTQMR
LBLNIEntry Sheet Number LBLNICHAR10Assigned to domainALPHALBLNILBLESSR
TASK_DETERMINEAutomatic task determination in the notification TASK_DETERMINECHAR1CHAR1
PRIOKPriority PRIOKCHAR1T356PRIOKPRIOK
QMKATCatalog Type - Coding QMKATCHAR1Assigned to domainQKATART
QMGRPCode Group - Coding QMGRPCHAR8Assigned to domainQCODEGRP
QMCODCoding QMCODCHAR4Assigned to domainQCODE
PHYNRPhysical Sample Number QPHYSPRNRCHAR12Assigned to domainALPHAQPHYSPRNRQPN
ARTInspection Type QPARTCHAR8Assigned to domainQPARTQLA
PRUEFLOSInspection Lot Number QPLOSNUMC12Assigned to domainQPLOSQLSQALS
TSTMP_BWTime Stamp for BI Delta Extraction TSTMP_BW_EXTDEC16RKE_TSTMP
NO_AUFRELKZDo Not Release Immediately NO_AUFRELKZCHAR1XFELD
.INCLU--AP 0
DESNUMCU: Design Number /CUM/DESNUMCHAR12Assigned to domainALPHA/CUM/DESNUM/CUM/DESNUM
.INCLU--AP 0
CYCLESEQINDCycle Set Sequence CYCLESETSEQNUMC2NUMC2
ADPSPReference Element PM/PS ADDCOMPARE_CORECHAR40Assigned to domainADDCOMPARE_COREADCP
IND_MPOS_APIMaintenance Item Was Created/Changed by API IND_MPOS_APICHAR2IND_API

Key field Non-key field



How do I retrieve data from SAP table MPOS using ABAP code

The following ABAP code Example will allow you to do a basic selection on MPOS to SELECT all data from the table
DATA: WA_MPOS TYPE MPOS.

SELECT SINGLE *
FROM MPOS
INTO CORRESPONDING FIELDS OF WA_MPOS
WHERE...

How to access SAP table MPOS

Within an ECC or HANA version of SAP you can also view further information about MPOS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!