SAP table DIMPOS (Maintenance item)

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
GEWRKE Main work center for maintenance tasks CHAR 8 0 GEWRK

DIMPOS foreign key relationships

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