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 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
KZBED | Indicator for Requirements Grouping | KZBED | CHAR | 1 | 0 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
SFEPR | Repetitive manufacturing profile | SFEPR | T437S | CHAR | 4 | 0 | ||||||||||||
FXHOR | Planning time fence | FXHOR | NUMC | 3 | 0 | |||||||||||||
VRMOD | Consumption mode | VRMOD | CHAR | 1 | 0 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
MISKZ | Mixed MRP indicator | MISKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
SCHGT | Indicator: Bulk Material | SCHGT | CHAR | 1 | 0 |
Possible values
|
||||||||||||
WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||||||
SHFLG | Safety time indicator (with or without safety time) | SHFLG | CHAR | 1 | 0 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
KZECH | Determination of batch entry in the production/process order | KZECH | CHAR | 1 | 0 |
Possible values
|
||||||||||||
EISLO | Minimum Safety Stock | EISLO | QUAN | 13 | 3 | |||||||||||||
PLIFZX | Consider Planned Delivery Time of the MRP Area | MD_PLIFZ_DB | CHAR | 1 | 0 |
Possible values
|
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 |