MPDPSD SAP (MPD: MPD and MP header data) Table details

Dictionary Type: Table
Description: MPD: MPD and MP header data




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




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

MPDPSD is a standard SAP Table which is used to store MPD: MPD and MP header data data and is available within R/3 SAP systems depending on the version and release level.

The MPDPSD table consists of various fields, each holding specific information or linking keys about MPD: MPD and MP header data data available in SAP. These include PLAN_DATA_ID (Document Identification GUID), DOKAR (Document Type), DOKNR (Document number), DOKVR (Document Version).. 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 MPDPSD 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 MANDTCLNT3Assigned to domainMANDT
PLAN_DATA_IDDocument Identification GUID MPD_DOCIDRAW16SYSUUID
DOKARDocument Type DOKARCHAR3TDWADOKARCV2
DOKNRDocument number DOKNRCHAR25DRAWALPHADOKNRCV1
DOKVRDocument Version DOKVRCHAR2DOKVRCV3
DOKTLDocument Part DOKTL_DCHAR3DOKTLCV4
AENNRChange Number AENNRCHAR12AENRAENNRAENNRAEN
MPTYPMaintenance Plan Category MPD_MPTYPCHAR2T399WMPTYPWAT
WSETCycle set for multiple counter plan WSETCHAR6Assigned to domainWSTRASET
WPTXTMaintenance Plan Text WPTXTCHAR40TEXT40
PLAN_SORTSort field for maintenance plans PLAN_SORTCHAR20T399GCHAR20
BEGRUTechnical object authorization group IAUTGCHAR4T370BIAUTG
VSPOSShift Factor for Late Completion VERSCHPLUSNUMC3NUM3
VSNEGShift Factor for Early Completion VERSCHNEGNUMC3NUM3
TOPOSTolerance for Late Completion (%) TOLERPLUSNUMC3NUM3
TOSNEGTolerance for Early Completion (%) TOLERNEGNUMC3NUM3
SFAKTCycle modification factor SFAKTDEC3(2) SFAKT
STICHScheduling indicator TERMKNZCHAR1TERMKNZ
FABKLFactory calendar key FABKLCHAR2Assigned to domainWFCID
ABRHOScheduling Period ABRHONUMC3ANZTA
HUNITUnit in scheduling interval HUNITUNIT3T006CUNITMEINS
HORIZHorizon until which dates in billing/invoice plan are valid HORIZDATS8DATUM
CALL_CONFIRMOnly Create New Call Object After Completing Predecessor CALL_CONFIRMCHAR1CHAR1
STADTStart date STADTDATS8DATUM
SZAEHStart counter reading SZAEHCCHAR22WZYKL
PSTXTItem Short Text POSTXTCHAR40TEXT40
IWERKMaintenance Planning Plant IWERKCHAR4T399IWERKSIWK
WPGRPPlanner Group for Customer Service and Plant Maintenance INGRPCHAR3T024IINGRPIHG
AUFARTOrder Type AUFARTCHAR4T003OAUFARTAAT
ILARTMaintenance activity type ILACHAR3Assigned to domainILARTH_T350I
GEWERKMain work center for maintenance tasks GEWRKCHAR8ARBPLVAP
WERGWPlant associated with main work center WERGWCHAR4T001WWERKS
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
PLNTYTask List Type PLNTYCHAR1Assigned to domainPLNTYPTYH_TCA01
PLNNRKey for Task List Group PLNNRCHAR8ALPHAPLNNRPLNPLKS
PLNALGroup Counter PLNALCHAR2ALPHAALTNRPAL
APFKTExecution factor for whole task list APFKTDEC3AFAKT
QMARTNotification Type QMARTCHAR2TQ80QMARTQMR
PRIOKPriority PRIOKCHAR1T356PRIOKPRIOK
TASK_DETERMINEAutomatic task determination in the notification TASK_DETERMINECHAR1CHAR1
DOC_UPDTPlanning and Scheduling Data Update Indicator MPD_UPDCHAR1XFELD
TLC_INDLife-Limited Component Indicator MPD_TLCCHAR1XFELD
MP_CRTD_INDMaintenance Plan Creation Indicator MPD_CRTD_INDCHAR1XFELD
COMPLIANCE_DATECompliance Date MPD_COMPL_DATEDATS8DATUM
JOBNAMEBackground job name BTCJOBCHAR32CHAR32
JOBCOUNTJob ID BTCJOBCNTCHAR8CHAR8
START_DATEMPD: Default Start Date for Maintenance Plans MPD_DEFAULT_START_DATEDATS8DATUM
START_TIMEMPD: Default Start Time for Maintenance Plans MPD_DEFAULT_START_TIMETIMS6TIME
OR_KNZIndicator for OR or AND link ANDORCHAR1RADIO
AND_KNZIndicator for OR or AND link ANDORCHAR1RADIO
VORLAUFLead Float in Days PUFF_VORLNUMC3NUM3
TOBE_UPDATEDMaintenance Plan to Be Updated TOBE_UPDATEDCHAR1XFELD
TOBE_RESTARTEDMaintenance Plan to Be Restarted TOBE_RESTARTEDCHAR1XFELD

Key field Non-key field



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

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

SELECT SINGLE *
FROM MPDPSD
INTO CORRESPONDING FIELDS OF WA_MPDPSD
WHERE...

How to access SAP table MPDPSD

Within an ECC or HANA version of SAP you can also view further information about MPDPSD 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!