SAP Table DIMPOS

Maintenance item

DIMPOS (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 DIMPOS to other SAP tables.

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

DIMPOS foreign key relationships

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