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 |
Possible values
|
||||||||||
AEKNZ | Change indicator | AEKNZ | CHAR | 1 | 0 |
Possible values
|
||||||||||
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 |
Possible values
|
||||||||||
LTKNZ | Long Text Indicator | MPLTX | CHAR | 1 | 0 |
Possible values
|
||||||||||
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 |
Possible values
|
||||||||||
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 |
Possible values
|
||||||||||
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 |
Possible values
|
||||||||||
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 |
Possible values
|
||||||||||
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 |
Possible values
|
||||||||||
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 |