SAP table MDIP (Material: MRP Profiles (Field Contents))

SAP table MDIP has 2 primary key fields being MANDT,DISPR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
DISPR Material: MRP profile CHAR 4 0 DISPR
DISMM MRP Type CHAR 2 0 T438A DISMM
DISPO MRP Controller CHAR 3 0 T024D DISPO
KZDIE Indicator: MRP controller is buyer (deactivated) CHAR 1 0 KZDIE
MAABC ABC Indicator CHAR 1 0 TMABC MAABC
PLIFZ Planned Delivery Time in Days DEC 3 0 PLIFZ
DZEIT In-house production time DEC 3 0 DZEIT
FHORI Scheduling Margin Key for Floats CHAR 3 0 T436A FHORI
SBDKZ Dependent requirements ind. for individual and coll. reqmts CHAR 1 0 SBDKZ
Individual and collective requirements
1 Individual requirements only
2 Collective requirements only
KZBED Indicator for Requirements Grouping CHAR 1 0 KZBED
0 In rep. mfg, individual record in addn to total requirements
T Display of dependent requirements as a daily total
EISBE Safety Stock QUAN 13 3 EISBE
MINBE Reorder Point QUAN 13 3 MINBE
DISLS Lot Sizing Procedure within Materials Planning CHAR 2 0 T439A DISLS
BSTRF Rounding value for purchase order quantity QUAN 13 3 BSTRF
BSTMI Minimum Lot Size QUAN 13 3 BSTMI
BSTMA Maximum Lot Size QUAN 13 3 BSTMA
BSTFE Fixed lot size QUAN 13 3 BSTFE
MABST Maximum Stock Level QUAN 13 3 MABST
AUSSS Assembly scrap in percent DEC 5 2 AUSSS
LOSFX Lot-Size-Independent Costs CURR 11 2 LOSFX
LAGPR Storage Costs Percentage Code CHAR 1 0 T439L LAGPR
AUFTL Splitting Indicator CHAR 1 0 T439P AUFTL
LGRAD Service level DEC 3 1 LGRAD
WEBAZ Goods receipt processing time in days DEC 3 0 WEBAZ
USEQU Quota arrangement usage CHAR 1 0 TMQ2 USEQU
PERKZ Period Indicator CHAR 1 0 PERKZ
Initial value
M Monthly
P Period according to fiscal year variant
T Daily
W Weekly
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
MRPPP PPC Planning Calendar CHAR 3 0 T439G MRPPP
SAUFT Indicator: Repetitive Manufacturing Allowed CHAR 1 0 SA_SAUFT
SFEPR Repetitive Manufacturing Profile CHAR 4 0 T437S SFEPR
FXHOR Planning time fence NUMC 3 0 FXHOR
VRMOD Consumption mode CHAR 1 0 VRMOD
1 Backward consumption only
2 Backward/forward consumption
3 Forward consumption only
4 Forward/backward consumption
5 Period-specific consumption
VINT1 Consumption period: backward NUMC 3 0 VINT1
VINT2 Consumption period: forward NUMC 3 0 VINT2
DISGR MRP Group CHAR 4 0 T438M DISGR
KAUSF Component Scrap in Percent DEC 5 2 KAUSF
ALTSL Method for Selecting Alternative Bills of Material CHAR 1 0 ALTSL
Selection by order quant.
1 Selection by explosion date
2 Selection by production version
3 Selection only by production version
MISKZ Mixed MRP indicator CHAR 1 0 MISKZ
1 Subassembly planning with final assembly
2 Gross requirements planning
3 Subassembly planning without final assembly
WZEIT Total replenishment lead time (in workdays) DEC 3 0 WZEIT
VPMAT Planning material CHAR 40 0 MARA VPMAT
VPWRK Planning plant CHAR 4 0 MARC VPWRK
VPREF Conv. factor f. plng material CHAR 10 0 VPREF
TAKZT Takt time DEC 3 0 TAKZT
RWPRO Range of coverage profile CHAR 3 0 T438R RWPRO
LFRHY Planning Cycle CHAR 3 0 T439G LFRHY
RDPRF Rounding Profile CHAR 4 0 RDPR RDPRF
STRGR Planning Strategy Group CHAR 2 0 T461P STRGR
SOBSL Special procurement type CHAR 2 0 T460A SOBSL
RGEKZ Indicator: Backflush CHAR 1 0 RGEKM
1 Always Backflush
2 Work center decides whether to backflush
SCHGT Indicator: bulk material CHAR 1 0 SCHGT
WAERS Currency Key CUKY 5 0 TCURC WAERS
SHFLG Safety time indicator (with or without safety time) CHAR 1 0 SHFLG
Ignore safety time
1 Safety time for independent reqmts
2 Safety time for all requirements
SHZET Safety Time (in Workdays) NUMC 2 0 SHZET
MDACH Action Control: Planned Order Processing CHAR 2 0 T46AC MDACH
LGPRO Issue Storage Location CHAR 4 0 T001L LGPRO
MTVFP Checking Group for Availability Check CHAR 2 0 TMVF MTVFP
BESKZ Procurement Type CHAR 1 0 BESKZ
No Procurement
E In-House Production
F External Procurement
X Both Procurement Types
KZECH Determination of batch entry in the production/process order CHAR 1 0 KZECH
Batch in goods issue; no confirmation required
1 Manual batch determination required upon release of order
2 Batch not required in prod./process order; confirmation reqd
3 Automatic batch determination upon release of order
EISLO Minimum Safety Stock QUAN 13 3 EISLO
PLIFZX Consider Planned Delivery Time of the MRP Area CHAR 1 0 MD_PLIFZ_DB
Use Planned Delivery Time of the Plant
X Use Planned Delivery Time of the MRP Area
LGFSB Default storage location for external procurement CHAR 4 0 T001L LGFSB

MDIP foreign key relationships

Table Field Check Table Check Field
0 MDIP AUFTL T439P Split-up for forecast requirements MANDT
0 MDIP AUFTL T439P Split-up for forecast requirements PERKZ
0 MDIP AUFTL T439P Split-up for forecast requirements AUFTL
1 MDIP DISGR T438M Control Parameter for MRP -Material Level- MANDT
1 MDIP DISGR T438M Control Parameter for MRP -Material Level- WERKS
1 MDIP DISGR T438M Control Parameter for MRP -Material Level- MTART
0 MDIP DISLS T439A MRP Lot Sizes MANDT
0 MDIP DISLS T439A MRP Lot Sizes DISLS
1 MDIP DISMM T438A MRP Type MANDT
1 MDIP DISMM T438A MRP Type DISMM
0 MDIP DISPO T024D MRP Controllers MANDT
0 MDIP DISPO T024D MRP Controllers WERKS
0 MDIP DISPO T024D MRP Controllers DISPO
1 MDIP EKGRP T024 Purchasing Groups EKGRP
0 MDIP FHORI T436A Floats for scheduling MANDT
0 MDIP FHORI T436A Floats for scheduling FHORI
1 MDIP LAGPR T439L Warehouse costs for MRP lot size MANDT
1 MDIP LAGPR T439L Warehouse costs for MRP lot size LAGPR
0 MDIP LFRHY T439G PP Planning periods: header table MANDT
0 MDIP LFRHY T439G PP Planning periods: header table WERKS
1 MDIP LGFSB T001L Storage Locations MANDT
1 MDIP LGFSB T001L Storage Locations WERKS
0 MDIP LGPRO T001L Storage Locations MANDT
0 MDIP LGPRO T001L Storage Locations WERKS
1 MDIP MAABC TMABC Values Table for the ABC Indicator for Materials MANDT
0 MDIP MANDT T000 Clients MANDT
1 MDIP MDACH T46AC Action control MANDT
1 MDIP MDACH T46AC Action control MDACH
1 MDIP MDACH T46AC Action control ACCFM
1 MDIP MDACH T46AC Action control ACCTO
0 MDIP MRPPP T439G PP Planning periods: header table MANDT
0 MDIP MRPPP T439G PP Planning periods: header table WERKS
1 MDIP MTVFP TMVF Availability Check Control MTVFP
0 MDIP PERIV T009 Fiscal Year Variants MANDT
0 MDIP PERIV T009 Fiscal Year Variants PERIV
1 MDIP RDPRF RDPR Rounding profile MANDT
1 MDIP RDPRF RDPR Rounding profile WERKS
1 MDIP RDPRF RDPR Rounding profile RDPRF
1 MDIP RDPRF RDPR Rounding profile RDZAE
0 MDIP RWPRO T438R Range of coverage profile MANDT
0 MDIP RWPRO T438R Range of coverage profile RWPRO
1 MDIP SFEPR T437S Repetitive Manufacturing Profile Table MANDT
0 MDIP SOBSL T460A Special procurement key MANDT
0 MDIP SOBSL T460A Special procurement key WERKS
0 MDIP SOBSL T460A Special procurement key SOBSL
1 MDIP STRGR T461P Planning strategy group MANDT
1 MDIP STRGR T461P Planning strategy group STRGR
0 MDIP USEQU TMQ2 Quota Arrangement Rules MANDT
0 MDIP USEQU TMQ2 Quota Arrangement Rules USEQU
1 MDIP VPMAT MARA General Material Data MANDT
1 MDIP VPMAT MARA General Material Data MATNR
0 MDIP VPWRK MARC Plant Data for Material MANDT
0 MDIP VPWRK MARC Plant Data for Material MATNR
0 MDIP VPWRK MARC Plant Data for Material WERKS
1 MDIP WAERS TCURC Currency Codes MANDT
1 MDIP WAERS TCURC Currency Codes WAERS