SAP Table MDMA
MRP Area for Material
MDMA (MRP Area for Material) 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 MDMA to other SAP tables.
MDMA table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||
MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||||
BERID | MRP Area | BERID | MDLV | CHAR | 10 | 0 | ||||||||||
WERKS | MRP area: Plant | WERKDP | T001W | CHAR | 4 | 0 | ||||||||||
DISPR | Material: MRP profile | DISPR | MDIP | CHAR | 4 | 0 | ||||||||||
DISMM | MRP Type | DISMM | T438A | CHAR | 2 | 0 | ||||||||||
DISPO | MRP Controller (Materials Planner) | DISPO | T024D | CHAR | 3 | 0 | ||||||||||
DISGR | MRP Group | DISGR | T438M | CHAR | 4 | 0 | ||||||||||
MINBE | Reorder Point | MINBE | QUAN | 13 | 3 | |||||||||||
LFRHY | Planning cycle | LFRHY | T439G | CHAR | 3 | 0 | ||||||||||
FXHOR | Planning time fence | FXHOR | NUMC | 3 | 0 | |||||||||||
DISLS | Lot size (materials planning) | DISLS | T439A | CHAR | 2 | 0 | ||||||||||
RDPRF | Rounding Profile | RDPRF | RDPR | CHAR | 4 | 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 | |||||||||||
MABST | Maximum stock level | MABST | QUAN | 13 | 3 | |||||||||||
TAKZT | Takt time | TAKZT | DEC | 3 | 0 | |||||||||||
AUSSS | Assembly scrap in percent | AUSSS | DEC | 5 | 2 | |||||||||||
SOBSL | Special procurement type | SOBSL | T460A | CHAR | 2 | 0 | ||||||||||
LGPRO | Issue Storage Location | LGPRO | MDLG | CHAR | 4 | 0 | ||||||||||
LGFSB | Default storage location for external procurement | LGFSB | MDLG | CHAR | 4 | 0 | ||||||||||
MRPPP | PPC planning calendar | MRPPP | T439G | CHAR | 3 | 0 | ||||||||||
EISBE | Safety Stock | EISBE | QUAN | 13 | 3 | |||||||||||
RWPRO | Range of coverage profile | RWPRO | T438R | CHAR | 3 | 0 | ||||||||||
SHZET | Safety time (in workdays) | SHZET | NUMC | 2 | 0 | |||||||||||
BSTFE | Fixed lot size | BSTFE | QUAN | 13 | 3 | |||||||||||
LOSFX | Ordering costs | LOSFX | CURR | 11 | 2 | |||||||||||
LAGPR | Storage costs indicator | LAGPR | T439L | CHAR | 1 | 0 | ||||||||||
LGRAD | Service level | LGRAD | DEC | 3 | 1 | |||||||||||
PROPR | Forecast profile | PROPR | CHAR | 4 | 0 | |||||||||||
VRBMT | Reference material for consumption | VRBMT | CHAR | 18 | 0 | |||||||||||
VRBDB | Reference MRP area - consumption | VRBDB | CHAR | 10 | 0 | |||||||||||
VRBDT | To date of the material to be copied for consumption | VRBDT | DATS | 8 | 0 | |||||||||||
VRBFK | Multiplier for reference material for consumption | VRBFK | DEC | 4 | 2 | |||||||||||
LOEKZ | Deletion Indicator | LVORM | CHAR | 1 | 0 |
Possible values
|
||||||||||
SHPRO | Period Profile for Safety Time | SHPRO | T438V | CHAR | 3 | 0 | ||||||||||
AHDIS | MRP relevancy for dependent requirements | AHDIS | CHAR | 1 | 0 |
Possible values
|
||||||||||
AUTRU | Reset Forecast Model Automatically | AUTRU | CHAR | 1 | 0 |
Possible values
|
||||||||||
PSTAT | Maintenance status | PSTAT_D | CHAR | 15 | 0 | |||||||||||
KZKFK | Indicator: take correction factors into account | KZKFK | CHAR | 1 | 0 |
Possible values
|
||||||||||
SHFLG | Safety time indicator (with or without safety time) | SHFLG | CHAR | 1 | 0 |
Possible values
|
||||||||||
APOKZ | Indicator: Is material relevant for APO | APOKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||
PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3 | 0 | |||||||||||
PLIFZX | Consider Planned Delivery Time of the MRP Area | MD_PLIFZ_DB | CHAR | 1 | 0 |
Possible values
|
MDMA foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
MDMA | BERID | MDMA | MANDT | MDLV | Customizing MRP Area | MANDT |
MDMA | BERID | MDMA | BERID | MDLV | Customizing MRP Area | BERID |
MDMA | DISGR | MDMA | MANDT | T438M | Control Parameter for MRP -Material Level- | MANDT |
MDMA | DISGR | MDMA | WERKS | T438M | Control Parameter for MRP -Material Level- | WERKS |
MDMA | DISGR | MDMA | DISGR | T438M | Control Parameter for MRP -Material Level- | MTART |
MDMA | DISLS | MDMA | MANDT | T439A | MRP Lot Sizes | MANDT |
MDMA | DISLS | MDMA | DISLS | T439A | MRP Lot Sizes | DISLS |
MDMA | DISMM | MDMA | MANDT | T438A | MRP Type | MANDT |
MDMA | DISMM | MDMA | DISMM | T438A | MRP Type | DISMM |
MDMA | DISPO | MDMA | MANDT | T024D | MRP controllers | MANDT |
MDMA | DISPO | MDMA | WERKS | T024D | MRP controllers | WERKS |
MDMA | DISPO | MDMA | DISPO | T024D | MRP controllers | DISPO |
MDMA | DISPR | MDMA | DISPR | MDIP | Material: MRP Profiles (Field Contents) | DISPR |
MDMA | DISPR | MDMA | MANDT | MDIP | Material: MRP Profiles (Field Contents) | MANDT |
MDMA | LAGPR | MDMA | MANDT | T439L | Warehouse costs for MRP lot size | MANDT |
MDMA | LAGPR | MDMA | WERKS | T439L | Warehouse costs for MRP lot size | WERKS |
MDMA | LAGPR | MDMA | LAGPR | T439L | Warehouse costs for MRP lot size | LAGPR |
MDMA | LFRHY | MDMA | MANDT | T439G | PPplanning periods: header table | MANDT |
MDMA | LFRHY | MDMA | WERKS | T439G | PPplanning periods: header table | WERKS |
MDMA | LFRHY | MDMA | LFRHY | T439G | PPplanning periods: header table | MRPPP |
MDMA | LGFSB | MDMA | MANDT | MDLG | Customizing: MRP Area Storage Location | MANDT |
MDMA | LGFSB | MDMA | BERID | MDLG | Customizing: MRP Area Storage Location | BERID |
MDMA | LGFSB | MDMA | WERKS | MDLG | Customizing: MRP Area Storage Location | WERKS |
MDMA | LGFSB | MDMA | LGFSB | MDLG | Customizing: MRP Area Storage Location | LGORT |
MDMA | LGPRO | MDMA | MANDT | MDLG | Customizing: MRP Area Storage Location | MANDT |
MDMA | LGPRO | MDMA | BERID | MDLG | Customizing: MRP Area Storage Location | BERID |
MDMA | LGPRO | MDMA | WERKS | MDLG | Customizing: MRP Area Storage Location | WERKS |
MDMA | LGPRO | MDMA | LGPRO | MDLG | Customizing: MRP Area Storage Location | LGORT |
MDMA | MANDT | MDMA | MANDT | T000 | Clients | MANDT |
MDMA | MATNR | MDMA | MANDT | MARA | General Material Data | MANDT |
MDMA | MATNR | MDMA | MATNR | MARA | General Material Data | MATNR |
MDMA | MRPPP | MDMA | MANDT | T439G | PPplanning periods: header table | MANDT |
MDMA | MRPPP | MDMA | WERKS | T439G | PPplanning periods: header table | WERKS |
MDMA | MRPPP | MDMA | MRPPP | T439G | PPplanning periods: header table | MRPPP |
MDMA | RDPRF | SYST | MANDT | RDPR | Rounding profile | MANDT |
MDMA | RDPRF | * | RDPR | Rounding profile | WERKS | |
MDMA | RDPRF | MDMA | RDPRF | RDPR | Rounding profile | RDPRF |
MDMA | RDPRF | * | RDPR | Rounding profile | RDZAE | |
MDMA | RWPRO | MDMA | WERKS | T438R | Range of coverage profile | WERKS |
MDMA | RWPRO | MDMA | RWPRO | T438R | Range of coverage profile | RWPRO |
MDMA | RWPRO | MDMA | MANDT | T438R | Range of coverage profile | MANDT |
MDMA | SHPRO | MDMA | MANDT | T438V | Period Profile for Safety Time | MANDT |
MDMA | SHPRO | MDMA | WERKS | T438V | Period Profile for Safety Time | WERKS |
MDMA | SHPRO | MDMA | SHPRO | T438V | Period Profile for Safety Time | SHPRO |
MDMA | SOBSL | MDMA | MANDT | T460A | Special procurement key | MANDT |
MDMA | SOBSL | MDMA | WERKS | T460A | Special procurement key | WERKS |
MDMA | SOBSL | MDMA | SOBSL | T460A | Special procurement key | SOBSL |
MDMA | WERKS | MDMA | MANDT | T001W | Plants/Branches | MANDT |
MDMA | WERKS | MDMA | WERKS | T001W | Plants/Branches | WERKS |