MDKP SAP (Header Data for MRP Document) Table details

Dictionary Type: Table
Description: Header Data for MRP Document




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




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

MDKP is a standard SAP Table which is used to store Header Data for MRP Document data and is available within R/3 SAP systems depending on the version and release level.

The MDKP table consists of various fields, each holding specific information or linking keys about Header Data for MRP Document data available in SAP. These include DTART (Type of MRP list), MATNR (Material Number), PLWRK (Plant), PLSCN (Planning Scenario of Long-Term Planning).. 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 MDKP 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
DTARTType of MRP list DTARTCHAR2DTART
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
PLWRKPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
PLSCNPlanning Scenario of Long-Term Planning PLSCNNUMC3PLSCPLSCNPLS
DTNUMNumber of material requirements planning table DTNUMNUMC10NUM10
DSDATMRP date DSDATDATS8DATUM
BDBKZSelection indicator for processed MRP lists BDBKZCHAR1XFELD
SLKZ1Selection indicator for exception groups SLKZXCHAR1CHAR1
SLKZ2Selection indicator for exception groups SLKZXCHAR1CHAR1
SLKZ3Selection indicator for exception groups SLKZXCHAR1CHAR1
SLKZ4Selection indicator for exception groups SLKZXCHAR1CHAR1
SLKZ5Selection indicator for exception groups SLKZXCHAR1CHAR1
SLKZ6Selection indicator for exception groups SLKZXCHAR1CHAR1
SLKZ7Selection indicator for exception groups SLKZXCHAR1CHAR1
SLKZ8Selection indicator for exception groups SLKZXCHAR1CHAR1
VRKZ1Processing indicator 01 VRKZ1CHAR1XFELD
VRKZ2Processing indicator 02 VRKZ2CHAR1XFELD
VRKZ3Processing indicator - 03 VRKZ3CHAR1XFELD
MTARTMaterial Type MTARTCHAR4T134MTARTMTA
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
DISSTLow-Level Code DISSTCHAR3DISST
BESKZProcurement Type BESKZCHAR1BESKZMBS
SOBSLSpecial procurement type SOBSLCHAR2T460ASOBSL
SOBESSpecial procurement type SOBESCHAR1SOBES
WRK02Planning/production plant WRK02CHAR4T001WWERKS
DISMMMRP Type DISMMCHAR2T438ADISMM
DISVFMRP procedure DISVFCHAR1DISVF
DISPOMRP Controller (Materials Planner) DISPOCHAR3T024DDISPODGRHS_T024D
PLDISPlanning controller (no longer used) PLDISCHAR3T024DDISPO
EKGRPPurchasing Group EKGRPCHAR3T024EKGRPEKG
MTWZTMaterial replenishment lead time MTWZTDEC3DEC3
WEBAZGoods Receipt Processing Time in Days WEBAZDEC3DEC3
BEAZTProcessing time for purchase order proposal BEAZTDEC3DEC3
FIXTREnd of planning time fence (date) FIXTRDATS8DATUM
MFHKZPlanning time fence set manually (MFXDT) MFHKZCHAR1XFELD
DISLSLot size (materials planning) DISLSCHAR2T439ADISLS
LOSVFLot-sizing procedure for short-term period LOSVFCHAR1LOSVF
LOSKZLot-size indicator for the short-term period LOSKZCHAR1LOSKZ
PERAZNumber of periods for the short-term area PERAZDEC3DEC03
EISBESafety Stock EISBEQUAN13(3) MENG13
MINBEReorder Point MINBEQUAN13(3) MENG13
HOEBEMaximum stock level MABSTQUAN13(3) MENG13
BSTMIMinimum Lot Size BSTMIQUAN13(3) MENG13
BSTMAMaximum Lot Size BSTMAQUAN13(3) MENG13
BSTFXFixed lot size BSTFEQUAN13(3) MENG13
BSTRFRounding value for purchase order quantity BSTRFQUAN13(3) MENG13
SUM01Plant stock / only plant segment SUM01WQUAN13(3) MENG13
SUM02No longer used/do not use!! NOUSEQUAN13(3) MENG13
SUM03No longer used/do not use!! NOUSEQUAN13(3) MENG13
SUM04No longer used/do not use!! NOUSEQUAN13(3) MENG13
SUM05No longer used/do not use!! NOUSEQUAN13(3) MENG13
NEGBSNegative stock NEGBSQUAN13(3) MENG13
MSGIDMessage identification MSGIDCHAR20Assigned to domainARBGB
MSGARMessage Type MSGTYCHAR1MSGAR
MSGNRMessage number MSGNRCHAR3T100MSGNR
MSGV1Message variable 01 MSGV1CHAR50CHAR50
MSGV2Message variable 02 MSGV2CHAR50CHAR50
MSGV3Message variable 03 MSGV3CHAR50CHAR50
MSGV4Message variable 04 MSGV4CHAR50CHAR50
DISGRMRP Group DISGRCHAR4T438MDISGR
PERIVFiscal Year Variant PERIVCHAR2T009PERIV
MRPPPPPC planning calendar MRPPPCHAR3T439GMRPPP
BDARFRequirements quantity from material requirements planning BDARFQUAN13(3) MENG13
LFRHYPlanning cycle LFRHYCHAR3T439GMRPPP
RDPRFRounding Profile RDPRFCHAR4Assigned to domainRDPRF
BERW1Stock Days' Supply Without Receipts BERW1DEC4(1) DECV3_1
BERW2First Receipt Days' Supply BERW2DEC4(1) DECV3_1
KZAUSDiscontinuation indicator KZAUSCHAR1KZAUS
AUSDTEffective-Out Date AUSDTDATS8DATUM
NFMATFollow-Up Material NFMATCHAR18Assigned to domainMATN1MATNRMAT
AUSZ1Exception group in the MRP list AUSZXCHAR2CHAR2
AUSZ2Exception group in the MRP list AUSZXCHAR2CHAR2
AUSZ3Exception group in the MRP list AUSZXCHAR2CHAR2
AUSZ4Exception group in the MRP list AUSZXCHAR2CHAR2
AUSZ5Exception group in the MRP list AUSZXCHAR2CHAR2
AUSZ6Exception group in the MRP list AUSZXCHAR2CHAR2
AUSZ7Exception group in the MRP list AUSZXCHAR2CHAR2
AUSZ8Exception group in the MRP list AUSZXCHAR2CHAR2
BEADAMRP list processing date BEADADATS8DATUM
NAUKZIndicator: new exception in the MRP list NAUKZCHAR1CHAR1
SAUFTInd.: Repetitive mfg allowed SA_SAUFTCHAR1XFELD
KZPROMOIndicator: Material in promotion KZPROMOCHAR1CHAR1
SHFLGSafety time indicator (with or without safety time) SHFLGCHAR1SHFLG
SHZETSafety time (in workdays) SHZETNUMC2NUMC2
FABKZIndicator: Item Relevant to JIT Delivery Schedules FABKZCHAR1FABKZ
MFXDTManual firming date MFXDTDATS8DATUM
BSKFLFlag whether stock correction factors exist BSKFLCHAR1XFLAG
MAABCABC Indicator MAABCCHAR1Assigned to domainMAABC
CFLAGAggregated MRP list COMPMRPLCHAR1XFELD
GRRELRelevant for requirements grouping for project stock GRRELCHAR1XFELD
RWPRORange of coverage profile RWPROCHAR3Assigned to domainRWPRO
SHPROPeriod Profile for Safety Time SHPROCHAR3Assigned to domainSHPRO
AHDISMRP relevancy for dependent requirements AHDISCHAR1AHDIS
BERW4Second Receipt Days' Supply BERW4DEC4(1) DECV3_1
BADONIndicator: BAdI is Active MD_BADI_ONCHAR1XFELD
HANAONHANA Optimizations Active / Inactive PPH_HANA_ONCHAR1XFELD

Key field Non-key field



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

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

SELECT SINGLE *
FROM MDKP
INTO CORRESPONDING FIELDS OF WA_MDKP
WHERE...

How to access SAP table MDKP

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