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 | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
KZBED
Indicator for Requirements Grouping
|
KZBED |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
SFEPR
Repetitive manufacturing profile
|
SFEPR | T437S |
CHAR
|
4 | 0 | |||||||||||||
|
FXHOR
Planning time fence
|
FXHOR |
NUMC
|
3 | 0 | ||||||||||||||
|
VRMOD
Consumption mode
|
VRMOD |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
MISKZ
Mixed MRP indicator
|
MISKZ |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
SCHGT
Indicator: Bulk Material
|
SCHGT |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
WAERS
Currency Key
|
WAERS | TCURC |
CUKY
|
5 | 0 | |||||||||||||
|
SHFLG
Safety time indicator (with or without safety time)
|
SHFLG |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
KZECH
Determination of batch entry in the production/process order
|
KZECH |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
EISLO
Minimum Safety Stock
|
EISLO |
QUAN
|
13 | 3 | ||||||||||||||
|
PLIFZX
Consider Planned Delivery Time of the MRP Area
|
MD_PLIFZ_DB |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
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 | MDIP | MANDT |
T438M
Control Parameter for MRP -Material Level-
|
MANDT |
| MDIP | DISGR | * |
T438M
Control Parameter for MRP -Material Level-
|
WERKS | |
| MDIP | DISGR | MDIP | DISGR |
T438M
Control Parameter for MRP -Material Level-
|
MTART |
| MDIP | DISLS | MDIP | MANDT |
T439A
MRP Lot Sizes
|
MANDT |
| MDIP | DISLS | MDIP | DISLS |
T439A
MRP Lot Sizes
|
DISLS |
| MDIP | DISMM | MDIP | MANDT |
T438A
MRP Type
|
MANDT |
| MDIP | DISMM | MDIP | DISMM |
T438A
MRP Type
|
DISMM |
| MDIP | DISPO | MDIP | MANDT |
T024D
MRP controllers
|
MANDT |
| MDIP | DISPO | * |
T024D
MRP controllers
|
WERKS | |
| MDIP | DISPO | MDIP | DISPO |
T024D
MRP controllers
|
DISPO |
| MDIP | EKGRP | MDIP | EKGRP |
T024
Purchasing Groups
|
EKGRP |
| MDIP | EKGRP | MDIP | MANDT |
T024
Purchasing Groups
|
MANDT |
| MDIP | FHORI | MDIP | FHORI |
T436A
Floats for scheduling
|
FHORI |
| MDIP | FHORI | MDIP | MANDT |
T436A
Floats for scheduling
|
MANDT |
| MDIP | FHORI | * |
T436A
Floats for scheduling
|
WERKS | |
| MDIP | LAGPR | MDIP | LAGPR |
T439L
Warehouse costs for MRP lot size
|
LAGPR |
| MDIP | LAGPR | MDIP | MANDT |
T439L
Warehouse costs for MRP lot size
|
MANDT |
| MDIP | LAGPR | * |
T439L
Warehouse costs for MRP lot size
|
WERKS | |
| 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 | * |
T001L
Storage Locations
|
WERKS | |
| MDIP | LGPRO | MDIP | LGPRO |
T001L
Storage Locations
|
LGORT |
| MDIP | LGPRO | MDIP | MANDT |
T001L
Storage Locations
|
MANDT |
| MDIP | MAABC | MDIP | MANDT |
TMABC
Values Table for the ABC Indicator for Materials
|
MANDT |
| MDIP | MAABC | MDIP | MAABC |
TMABC
Values Table for the ABC Indicator for Materials
|
MAABC |
| MDIP | MANDT | MDIP | MANDT |
T000
Clients
|
MANDT |
| MDIP | MDACH | MDIP | MDACH |
T46AC
Action control
|
MDACH |
| MDIP | MDACH | * |
T46AC
Action control
|
ACCFM | |
| MDIP | MDACH | * |
T46AC
Action control
|
ACCTO | |
| MDIP | MDACH | MDIP | MANDT |
T46AC
Action control
|
MANDT |
| MDIP | MRPPP | MDIP | MANDT |
T439G
PPplanning periods: header table
|
MANDT |
| MDIP | MRPPP | * |
T439G
PPplanning periods: header table
|
WERKS | |
| MDIP | MRPPP | MDIP | MRPPP |
T439G
PPplanning periods: header table
|
MRPPP |
| MDIP | MTVFP | MDIP | MTVFP |
TMVF
Availability Check Control
|
MTVFP |
| MDIP | MTVFP | MDIP | MANDT |
TMVF
Availability Check Control
|
MANDT |
| MDIP | PERIV | MDIP | MANDT |
T009
Fiscal Year Variants
|
MANDT |
| MDIP | PERIV | MDIP | PERIV |
T009
Fiscal Year Variants
|
PERIV |
| MDIP | RDPRF | * |
RDPR
Rounding profile
|
WERKS | |
| MDIP | RDPRF | MDIP | RDPRF |
RDPR
Rounding profile
|
RDPRF |
| MDIP | RDPRF | * |
RDPR
Rounding profile
|
RDZAE | |
| MDIP | RDPRF | MDIP | MANDT |
RDPR
Rounding profile
|
MANDT |
| MDIP | RWPRO | MDIP | RWPRO |
T438R
Range of coverage profile
|
RWPRO |
| MDIP | RWPRO | MDIP | MANDT |
T438R
Range of coverage profile
|
MANDT |
| MDIP | RWPRO | * |
T438R
Range of coverage profile
|
WERKS | |
| MDIP | SFEPR | MDIP | MANDT |
T437S
Repetitive Manufacturing Profile Table
|
MANDT |
| MDIP | SFEPR | MDIP | SFEPR |
T437S
Repetitive Manufacturing Profile Table
|
SFPRO |
| MDIP | SOBSL | MDIP | MANDT |
T460A
Special procurement key
|
MANDT |
| MDIP | SOBSL | * |
T460A
Special procurement key
|
WERKS | |
| MDIP | SOBSL | MDIP | SOBSL |
T460A
Special procurement key
|
SOBSL |
| 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 |