1. Home
  2. Resources
  3. SAP Tables
  4. MPDITEM - Maintenance Plan Items

SAP Table MPDITEM

Maintenance Plan Items

MPDITEM (Maintenance Plan Items) 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 MPDITEM to other SAP tables.

MPDITEM table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
PLAN_DATA_ID Document Identification GUID MPD_DOCID RAW 16 0
COUNTER MPD: Counter of the MP Item for MP Header Data MPD_ITEM_COUNTER INT4 10 0
PSTXT Item Short Text POSTXT CHAR 40 0
IWERK Maintenance Planning Plant IWERK T001W CHAR 4 0
WPGRP Planner Group for Customer Service and Plant Maintenance INGRP T024I CHAR 3 0
AUART Order Type AUFART T003O CHAR 4 0
GEWRK Main work center for maintenance tasks GEWRK CHAR 8 0
WERGW Plant associated with main work center WERGW T001W CHAR 4 0
GSBER Business Area GSBER CHAR 4 0
PRIOK Priority PRIOK CHAR 1 0
KDAUF Sales Document VBELN_VA CHAR 10 0
KDPOS Sales Document Item POSNR_VA NUMC 6 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
CYCLESEQIND Cycle Set Sequence CYCLESETSEQ NUMC 2 0
QMART Notification Type QMART TQ80 CHAR 2 0
TASK_DETERMINE Automatic task determination in the notification TASK_DETERMINE CHAR 1 0

MPDITEM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MPDITEM AUART MPDITEM MANDT T003O Order Types CLIENT
MPDITEM AUART MPDITEM AUART T003O Order Types AUART
MPDITEM IWERK MPDITEM MANDT T001W Plants/Branches MANDT
MPDITEM IWERK MPDITEM IWERK T001W Plants/Branches WERKS
MPDITEM PLNTY MPDITEM MANDT TCA01 Task list types MANDT
MPDITEM PLNTY MPDITEM PLNTY TCA01 Task list types PLNTY
MPDITEM QMART MPDITEM MANDT TQ80 Notification Types MANDT
MPDITEM QMART MPDITEM QMART TQ80 Notification Types QMART
MPDITEM WERGW MPDITEM MANDT T001W Plants/Branches MANDT
MPDITEM WERGW MPDITEM WERGW T001W Plants/Branches WERKS
MPDITEM WPGRP MPDITEM MANDT T024I Maintenance planner groups MANDT
MPDITEM WPGRP MPDITEM IWERK T024I Maintenance planner groups IWERK
MPDITEM WPGRP MPDITEM WPGRP T024I Maintenance planner groups INGRP