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 | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||
|
||||||||||||||||
|
SHPRO
Period Profile for Safety Time
|
SHPRO | T438V |
CHAR
|
3 | 0 | |||||||||||
|
AHDIS
MRP relevancy for dependent requirements
|
AHDIS |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
AUTRU
Reset Forecast Model Automatically
|
AUTRU |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
PSTAT
Maintenance status
|
PSTAT_D |
CHAR
|
15 | 0 | ||||||||||||
|
KZKFK
Indicator: take correction factors into account
|
KZKFK |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
SHFLG
Safety time indicator (with or without safety time)
|
SHFLG |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
APOKZ
Indicator: Is material relevant for APO
|
APOKZ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
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 | WERKS |
T438M
Control Parameter for MRP -Material Level-
|
WERKS |
| MDMA | DISGR | MDMA | DISGR |
T438M
Control Parameter for MRP -Material Level-
|
MTART |
| MDMA | DISGR | MDMA | MANDT |
T438M
Control Parameter for MRP -Material Level-
|
MANDT |
| 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 | WERKS |
T024D
MRP controllers
|
WERKS |
| MDMA | DISPO | MDMA | DISPO |
T024D
MRP controllers
|
DISPO |
| MDMA | DISPO | MDMA | MANDT |
T024D
MRP controllers
|
MANDT |
| MDMA | DISPR | MDMA | MANDT |
MDIP
Material: MRP Profiles (Field Contents)
|
MANDT |
| MDMA | DISPR | MDMA | DISPR |
MDIP
Material: MRP Profiles (Field Contents)
|
DISPR |
| 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 | WERKS |
T439G
PPplanning periods: header table
|
WERKS |
| MDMA | LFRHY | MDMA | LFRHY |
T439G
PPplanning periods: header table
|
MRPPP |
| MDMA | LFRHY | MDMA | MANDT |
T439G
PPplanning periods: header table
|
MANDT |
| MDMA | LGFSB | MDMA | WERKS |
MDLG
Customizing: MRP Area Storage Location
|
WERKS |
| MDMA | LGFSB | MDMA | LGFSB |
MDLG
Customizing: MRP Area Storage Location
|
LGORT |
| MDMA | LGFSB | MDMA | MANDT |
MDLG
Customizing: MRP Area Storage Location
|
MANDT |
| MDMA | LGFSB | MDMA | BERID |
MDLG
Customizing: MRP Area Storage Location
|
BERID |
| MDMA | LGPRO | MDMA | LGPRO |
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 | 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 | MDMA | RDPRF |
RDPR
Rounding profile
|
RDPRF |
| MDMA | RDPRF | * |
RDPR
Rounding profile
|
RDZAE | |
| MDMA | RDPRF | SYST | MANDT |
RDPR
Rounding profile
|
MANDT |
| MDMA | RDPRF | * |
RDPR
Rounding profile
|
WERKS | |
| MDMA | RWPRO | MDMA | MANDT |
T438R
Range of coverage profile
|
MANDT |
| MDMA | RWPRO | MDMA | WERKS |
T438R
Range of coverage profile
|
WERKS |
| MDMA | RWPRO | MDMA | RWPRO |
T438R
Range of coverage profile
|
RWPRO |
| 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 | SOBSL |
T460A
Special procurement key
|
SOBSL |
| MDMA | SOBSL | MDMA | MANDT |
T460A
Special procurement key
|
MANDT |
| MDMA | SOBSL | MDMA | WERKS |
T460A
Special procurement key
|
WERKS |
| MDMA | WERKS | MDMA | MANDT |
T001W
Plants/Branches
|
MANDT |
| MDMA | WERKS | MDMA | WERKS |
T001W
Plants/Branches
|
WERKS |