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
X Yes
NULL No
SHPRO Period Profile for Safety Time SHPRO T438V CHAR 3 0
AHDIS MRP relevancy for dependent requirements AHDIS CHAR 1 0
NULL Materials for dependent requirements are planned
1 Materials for dependent requirements are not planned
AUTRU Reset Forecast Model Automatically AUTRU CHAR 1 0
X Yes
NULL No
PSTAT Maintenance status PSTAT_D CHAR 15 0
KZKFK Indicator: take correction factors into account KZKFK CHAR 1 0
X Yes
NULL No
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
APOKZ Indicator: Is material relevant for APO APOKZ CHAR 1 0
NULL Material is not relevant to APO
1 ATP check will be carried out in APO for material
2 ATP check and planning will be carried out in APO
3 Is active in APO integration model (set automatically)
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
NULL Use Planned Delivery Time of the Plant
X Use Planned Delivery Time of the MRP Area

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