MDIP SAP (Material: MRP Profiles (Field Contents)) Table details

Dictionary Type: Table
Description: Material: MRP Profiles (Field Contents)




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




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

MDIP is a standard SAP Table which is used to store Material: MRP Profiles (Field Contents) data and is available within R/3 SAP systems depending on the version and release level.

The MDIP table consists of various fields, each holding specific information or linking keys about Material: MRP Profiles (Field Contents) data available in SAP. These include DISPR (Material: MRP profile), DISMM (MRP Type), DISPO (MRP Controller (Materials Planner)), KZDIE (Indicator: MRP controller is buyer (deactivated)).. 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)

Text table = T401T


SAP MDIP 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 MANDTCLNT3T000MANDT
DISPRMaterial: MRP profile DISPRCHAR4DISPRDPR
DISMMMRP Type DISMMCHAR2T438ADISMM
DISPOMRP Controller (Materials Planner) DISPOCHAR3T024DDISPODGRHS_T024D
KZDIEIndicator: MRP controller is buyer (deactivated) KZDIECHAR1XFELD
MAABCABC Indicator MAABCCHAR1TMABCMAABC
PLIFZPlanned Delivery Time in Days PLIFZDEC3DEC3
DZEITIn-house production time DZEITDEC3DEC3
FHORIScheduling Margin Key for Floats FHORICHAR3T436AFHORI
SBDKZDependent requirements ind. for individual and coll. reqmts SBDKZCHAR1SBDKZ
KZBEDIndicator for Requirements Grouping KZBEDCHAR1KZBED
EISBESafety Stock EISBEQUAN13(3) MENG13
MINBEReorder Point MINBEQUAN13(3) MENG13
DISLSLot size (materials planning) DISLSCHAR2T439ADISLS
BSTRFRounding value for purchase order quantity BSTRFQUAN13(3) MENG13
BSTMIMinimum Lot Size BSTMIQUAN13(3) MENG13
BSTMAMaximum Lot Size BSTMAQUAN13(3) MENG13
BSTFEFixed lot size BSTFEQUAN13(3) MENG13
MABSTMaximum stock level MABSTQUAN13(3) MENG13
AUSSSAssembly scrap in percent AUSSSDEC5(2) DEC3_2
LOSFXOrdering costs LOSFXCURR11(2) WERT11
LAGPRStorage costs indicator LAGPRCHAR1T439LLAGPR
AUFTLSplitting Indicator AUFTLCHAR1T439PAUFTL
LGRADService level LGRADDEC3(1) DEC2_1
WEBAZGoods Receipt Processing Time in Days WEBAZDEC3DEC3
USEQUQuota arrangement usage USEQUCHAR1TMQ2USEQU
PERKZPeriod Indicator PERKZCHAR1PERKZPKZ
PERIVFiscal Year Variant PERIVCHAR2T009PERIV
EKGRPPurchasing Group EKGRPCHAR3T024EKGRPEKG
MRPPPPPC planning calendar MRPPPCHAR3T439GMRPPP
SAUFTInd.: Repetitive mfg allowed SA_SAUFTCHAR1XFELD
SFEPRRepetitive manufacturing profile SFEPRCHAR4T437SSFEPR
FXHORPlanning time fence FXHORNUMC3FXHOR
VRMODConsumption mode VRMODCHAR1VRMOD
VINT1Consumption period: backward VINT1NUMC3VRINT
VINT2Consumption period: forward VINT2NUMC3VRINT
DISGRMRP Group DISGRCHAR4T438MDISGR
KAUSFComponent scrap in percent KAUSFDEC5(2) DEC3_2
ALTSLMethod for Selecting Alternative Bills of Material ALTSLCHAR1ALTSL
MISKZMixed MRP indicator MISKZCHAR1MISKZ
WZEITTotal replenishment lead time (in workdays) WZEITDEC3DEC3
VPMATPlanning material VPMATCHAR18MARAMATN1MATNR
VPWRKPlanning plant VPWRKCHAR4MARCWERKS
VPREFConv. factor f. plng material VPREFCHAR10CHAR10
TAKZTTakt time TAKZTDEC3DEC3
RWPRORange of coverage profile RWPROCHAR3T438RRWPRO
LFRHYPlanning cycle LFRHYCHAR3T439GMRPPP
RDPRFRounding Profile RDPRFCHAR4RDPRRDPRF
STRGRPlanning strategy group STRGRCHAR2T461PSTRGR
SOBSLSpecial procurement type SOBSLCHAR2T460ASOBSL
RGEKZIndicator: Backflush RGEKMCHAR1RGEKM
SCHGTIndicator: Bulk Material SCHGTCHAR1XFELD
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
SHFLGSafety time indicator (with or without safety time) SHFLGCHAR1SHFLG
SHZETSafety time (in workdays) SHZETNUMC2NUMC2
MDACHAction control: planned order processing MDACHCHAR2T46ACMDACH
LGPROIssue Storage Location LGPROCHAR4T001LLGORT
MTVFPChecking Group for Availability Check MTVFPCHAR2TMVFMTVFP
BESKZProcurement Type BESKZCHAR1BESKZMBS
KZECHDetermination of batch entry in the production/process order KZECHCHAR1KZECH
EISLOMinimum Safety Stock EISLOQUAN13(3) MENG13
PLIFZXConsider Planned Delivery Time of the MRP Area MD_PLIFZ_DBCHAR1MD_PLIFZ_DB

Key field Non-key field



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

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

SELECT SINGLE *
FROM MDIP
INTO CORRESPONDING FIELDS OF WA_MDIP
WHERE...

How to access SAP table MDIP

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