1. Home
  2. Resources
  3. SAP Tables
  4. MDIP - Material: MRP Profiles (Field Contents)

SAP Table MDIP

Material: MRP Profiles (Field Contents)

MDIP (Material: MRP Profiles (Field Contents)) 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 MDIP to other SAP tables.

MDIP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
DISPR Material: MRP profile DISPR CHAR 4 0
DISMM MRP Type DISMM T438A CHAR 2 0
DISPO MRP Controller (Materials Planner) DISPO T024D CHAR 3 0
KZDIE Indicator: MRP controller is buyer (deactivated) KZDIE CHAR 1 0
X Yes
NULL No
MAABC ABC Indicator MAABC TMABC CHAR 1 0
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 0
DZEIT In-house production time DZEIT DEC 3 0
FHORI Scheduling Margin Key for Floats FHORI T436A CHAR 3 0
SBDKZ Dependent requirements ind. for individual and coll. reqmts SBDKZ CHAR 1 0
NULL Individual and collective requirements
1 Individual requirements only
2 Collective requirements only
KZBED Indicator for Requirements Grouping KZBED CHAR 1 0
T Display of dependent requirements as a daily total
0 In rep. mfg, individual record in addn to total requirements
EISBE Safety Stock EISBE QUAN 13 3
MINBE Reorder Point MINBE QUAN 13 3
DISLS Lot size (materials planning) DISLS T439A CHAR 2 0
BSTRF Rounding value for purchase order quantity BSTRF QUAN 13 3
BSTMI Minimum Lot Size BSTMI QUAN 13 3
BSTMA Maximum Lot Size BSTMA QUAN 13 3
BSTFE Fixed lot size BSTFE QUAN 13 3
MABST Maximum stock level MABST QUAN 13 3
AUSSS Assembly scrap in percent AUSSS DEC 5 2
LOSFX Ordering costs LOSFX CURR 11 2
LAGPR Storage costs indicator LAGPR T439L CHAR 1 0
AUFTL Splitting Indicator AUFTL T439P CHAR 1 0
LGRAD Service level LGRAD DEC 3 1
WEBAZ Goods Receipt Processing Time in Days WEBAZ DEC 3 0
USEQU Quota arrangement usage USEQU TMQ2 CHAR 1 0
PERKZ Period Indicator PERKZ CHAR 1 0
P Period according to fiscal year variant
M Monthly
W Weekly
T Daily
NULL Initial value
PERIV Fiscal Year Variant PERIV T009 CHAR 2 0
EKGRP Purchasing Group EKGRP T024 CHAR 3 0
MRPPP PPC planning calendar MRPPP T439G CHAR 3 0
SAUFT Ind.: Repetitive mfg allowed SA_SAUFT CHAR 1 0
X Yes
NULL No
SFEPR Repetitive manufacturing profile SFEPR T437S CHAR 4 0
FXHOR Planning time fence FXHOR NUMC 3 0
VRMOD Consumption mode VRMOD CHAR 1 0
1 Backward consumption only
2 Backward/forward consumption
3 Forward consumption only
4 Forward/backward consumption
VINT1 Consumption period: backward VINT1 NUMC 3 0
VINT2 Consumption period: forward VINT2 NUMC 3 0
DISGR MRP Group DISGR T438M CHAR 4 0
KAUSF Component scrap in percent KAUSF DEC 5 2
ALTSL Method for Selecting Alternative Bills of Material ALTSL CHAR 1 0
NULL Selection by order quant.
1 Selection by explosion date
2 Selection by production version
3 Selection only by production version
MISKZ Mixed MRP indicator MISKZ CHAR 1 0
1 Subassembly planning with final assembly
2 Gross requirements planning
3 Subassembly planning without final assembly
WZEIT Total replenishment lead time (in workdays) WZEIT DEC 3 0
VPMAT Planning material VPMAT MARA CHAR 18 0
VPWRK Planning plant VPWRK MARC CHAR 4 0
VPREF Conv. factor f. plng material VPREF CHAR 10 0
TAKZT Takt time TAKZT DEC 3 0
RWPRO Range of coverage profile RWPRO T438R CHAR 3 0
LFRHY Planning cycle LFRHY T439G CHAR 3 0
RDPRF Rounding Profile RDPRF RDPR CHAR 4 0
STRGR Planning strategy group STRGR T461P CHAR 2 0
SOBSL Special procurement type SOBSL T460A CHAR 2 0
RGEKZ Indicator: Backflush RGEKM CHAR 1 0
1 Always backflush
2 Work center decides whether to backflush
SCHGT Indicator: Bulk Material SCHGT CHAR 1 0
X Yes
NULL No
WAERS Currency Key WAERS TCURC CUKY 5 0
SHFLG Safety time indicator (with or without safety time) SHFLG CHAR 1 0
NULL Ignore safety time
1 Safety time for independent reqmts
2 Safety time for all requirements
SHZET Safety time (in workdays) SHZET NUMC 2 0
MDACH Action control: planned order processing MDACH T46AC CHAR 2 0
LGPRO Issue Storage Location LGPRO T001L CHAR 4 0
MTVFP Checking Group for Availability Check MTVFP TMVF CHAR 2 0
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
KZECH Determination of batch entry in the production/process order KZECH CHAR 1 0
NULL 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 EISLO QUAN 13 3
PLIFZX Consider Planned Delivery Time of the MRP Area MD_PLIFZ_DB CHAR 1 0
NULL Use Planned Delivery Time of the Plant
X Use Planned Delivery Time of the MRP Area

MDIP foreign key relationships

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