SAP table MDMA (MRP Area for Material)

SAP table MDMA has 3 primary key fields being MANDT,MATNR,BERID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
BERID MRP Area CHAR 10 0 MDLV BERID
WERKS MRP Area: Plant CHAR 4 0 T001W WERKDP
DISPR Material: MRP profile CHAR 4 0 MDIP DISPR
DISMM MRP Type CHAR 2 0 T438A DISMM
DISPO MRP Controller CHAR 3 0 T024D DISPO
DISGR MRP Group CHAR 4 0 T438M DISGR
MINBE Reorder Point QUAN 13 3 MINBE
LFRHY Planning Cycle CHAR 3 0 T439G LFRHY
FXHOR Planning time fence NUMC 3 0 FXHOR
DISLS Lot Sizing Procedure within Materials Planning CHAR 2 0 T439A DISLS
RDPRF Rounding Profile CHAR 4 0 RDPR RDPRF
BSTRF Rounding value for purchase order quantity QUAN 13 3 BSTRF
BSTMI Minimum Lot Size QUAN 13 3 BSTMI
BSTMA Maximum Lot Size QUAN 13 3 BSTMA
MABST Maximum Stock Level QUAN 13 3 MABST
TAKZT Takt time DEC 3 0 TAKZT
AUSSS Assembly scrap in percent DEC 5 2 AUSSS
SOBSL Special procurement type CHAR 2 0 T460A SOBSL
LGPRO Issue Storage Location CHAR 4 0 MDLG LGPRO
LGFSB Default storage location for external procurement CHAR 4 0 MDLG LGFSB
MRPPP PPC Planning Calendar CHAR 3 0 T439G MRPPP
EISBE Safety Stock QUAN 13 3 EISBE
RWPRO Range of coverage profile CHAR 3 0 T438R RWPRO
SHZET Safety Time (in Workdays) NUMC 2 0 SHZET
BSTFE Fixed lot size QUAN 13 3 BSTFE
LOSFX Lot-Size-Independent Costs CURR 11 2 LOSFX
LAGPR Storage Costs Percentage Code CHAR 1 0 T439L LAGPR
LGRAD Service level DEC 3 1 LGRAD
PROPR Forecast profile CHAR 4 0 PROPR
VRBMT Reference material for consumption CHAR 40 0 VRBMT
VRBDB Reference MRP area - consumption CHAR 10 0 VRBDB
VRBDT To date of the material to be copied for consumption DATS 8 0 VRBDT
VRBFK Multiplier for reference material for consumption DEC 4 2 VRBFK
LOEKZ Deletion Indicator CHAR 1 0 LVORM
SHPRO Period Profile for Safety Time CHAR 3 0 T438V SHPRO
AHDIS MRP relevancy for dependent requirements CHAR 1 0 AHDIS
Materials for dependent requirements are planned
1 Materials for dependent requirements are not planned
AUTRU Reset Forecast Model Automatically CHAR 1 0 AUTRU
PSTAT Maintenance status CHAR 15 0 PSTAT_D
KZKFK Indicator: take correction factors into account CHAR 1 0 KZKFK
SHFLG Safety time indicator (with or without safety time) CHAR 1 0 SHFLG
Ignore safety time
1 Safety time for independent reqmts
2 Safety time for all requirements
APOKZ Indicator: Is material relevant for APO CHAR 1 0 APOKZ
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 DEC 3 0 PLIFZ
PLIFZX Consider Planned Delivery Time of the MRP Area CHAR 1 0 MD_PLIFZ_DB
Use Planned Delivery Time of the Plant
X Use Planned Delivery Time of the MRP Area
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
AEZEIT Time of Change TIMS 6 0 AEZEIT
SFTY_STK_METH MRP Safety Stock Method CHAR 2 0 MRP_SSTOCK_METHOD
MB Time-dependent Safety Stock
SCM_MATLOCID_GUID16 Internal Key for Product RAW 16 0 /SCMB/MDL_MATID
SCM_MATLOCID_GUID22 Internal Number (UID) for Location Product CHAR 22 0 /SAPAPO/MATLOCID
SCM_GRPRT Goods Receipt Processing Time DEC 11 0 /SAPAPO/GRPRT
SCM_GIPRT Goods Issue Processing Time DEC 11 0 /SAPAPO/GIPRT
SCM_RRP_TYPE PP Planning Procedure CHAR 1 0 /SAPAPO/PPS_PLANNING_TYPE
SCM_HEUR_ID PPC Heuristics CHAR 12 0 /SAPAPO/PROD_HEUR_ID
SCM_PACKAGE_ID Planning Package to Which Product Belongs CHAR 12 0 /SAPAPO/PROD_HEUR_PACKID
SCM_CONHAP Handling Capacity Consumption in Unit of Measure (Gds Rcpt) QUAN 13 3 /SAPAPO/SNPCONHAP
SCM_HUNIT Unit of Measure: Handling Capacity in Goods Receipt UNIT 3 0 * /SAPAPO/HUNIT
SCM_CONHAP_OUT Handling Capacity Consumption in Unit of Measure (Gds Issue) QUAN 13 3 /SAPAPO/SNPCONHAP_OUT
SCM_HUNIT_OUT Unit of Measure: Handling Capacity in Goods Issue UNIT 3 0 * /SAPAPO/HUNIT_OUT
SCM_RRP_SEL_GROUP Planning Group CHAR 2 0 /SAPAPO/RRP_SEL_GROUP
SCM_LSUOM Unit of Measure of Lot Size UNIT 3 0 * /SAPAPO/LSUOM
SCM_REORD_DUR Reorder Days' Supply (in Workdays) DEC 11 0 /SAPAPO/REORD_DUR
SCM_TARGET_DUR Target Days' Supply in Workdays DEC 11 0 /SAPAPO/TARGET_DUR
SCM_TSTRID Planning Calendar for Periodic Lot Sizing Procedure CHAR 10 0 * /SAPAPO/LOT_TSTRID
SCM_THRUPUT_TIME Throughput Time DEC 11 0 /SAPAPO/THRUPUT_TIME
SCM_TPOP Third-Party Order Processing CHAR 2 0 /SAPAPO/TPOP
No
01 Yes
02 Both
SCM_SAFTY_V Safety Stock for Virtual Child Location QUAN 13 3 SAFTYV
SCM_PPSAFTYSTK Safety Stock at Parent Location QUAN 13 3 PPSAFTYSTK
SCM_PPSAFTYSTK_V Safety Stock of Parent Location Virtual Child Location QUAN 13 3 PPSAFTYSTKV
SCM_REPSAFTY Repair Safety Stock QUAN 13 3 REPSAFTY
SCM_REPSAFTY_V Repair Safety Stock for Virtual Child Location QUAN 13 3 REPSAFTYV
SCM_REORD_V Reorder Point for Virtual Child Location QUAN 13 3 REORD_V
SCM_MAXSTOCK_V Maximum Stock Level for Virtual Child Locations QUAN 13 3 MAXSTOCK_V
SCM_SCOST_PRCNT Cost Factor for Stockholding Costs DEC 3 2 /SAPAPO/PERCENT_SCOST
SCM_PROC_COST Procurement Costs for Product DEC 13 3 /SAPAPO/PROC_COST
SCM_NDCOSTWE Goods Receiving Costs DEC 13 3 NDCOSTWE
SCM_NDCOSTWA Goods Issue Costs DEC 13 3 NDCOSTWA
SCM_CONINP Consumption of Storage Capacity per Unit of Material QUAN 13 3 /SAPAPO/SNPCONINP
SCM_IUNIT Unit of Measurement of Size UNIT 3 0 * /SAPAPO/UNIT
MAXDOS_PEN Penalty exceeding time dependent Max Days' of Supply DEC 13 3 PPO_MAXDOS_PENALTY
MAXDOS_FLG Is Max Dos Active CHAR 1 0 PPO_MAXDOS_FLAG
SAFTYSTOCK_METHOD Method for Calculating Safety Stock CHAR 2 0 /SAPAPO/MSDP_SB_METHOD
No Safety Stock
MB Safety Stock (Time-Dependent Maintenance)
MM Maximum of MB and MZ (Time-Dependent Maintenance)
MZ Safety Days' Supply (Time-Dependent Maintenance)
SB Safety Stock from Location Product Master
SM Max.of Safety Stock and Safety Days'Sup.from Loc.Prod.Master
SZ Safety Days' Supply from Location Product Master
TARGET_STOCK_LEVEL_METH Target Stock Level Method CHAR 1 0 /SAPAPO/TARGET_METHOD
Target days' supply from product master
7 No target stock level
AUTO_DET_SFTYSTK_METH Safety stock method Automatic determination CHAR 1 0 SAFTY_STOCK_METH_DETN
Safety stock Method is not Automatically determined
X Safety stock Method is Automatically determined
USE_PERIOD_FACTOR Use Period Factor CHAR 1 0 /SAPAPO/RRP_REQ_COVER_FLAG
Application-Dependent Standard
X Availability from Period Duration and Period Factor
PERIOD_FACTOR_VALUE Period Factor for Calculating the Availability Date/Time DEC 4 3 /SAPAPO/RRP_REQ_COVER_TYPE
0 Factor for Availability Date Within the Period
PERIOD_FACTOR_TDS Period factor Time dependent Stock Levels DEC 4 3 PERIOD_FACTOR_TDS
SDM_VERSION Silent Data migration status from MDMA table CHAR 2 0 SDM_MIG_STATUS_MDMA

MDMA foreign key relationships

Table Field Check Table Check Field
0 MDMA BERID MDLV Customizing MRP Area MANDT
0 MDMA BERID MDLV Customizing MRP Area BERID
1 MDMA DISGR T438M Control Parameter for MRP -Material Level- MANDT
1 MDMA DISGR T438M Control Parameter for MRP -Material Level- WERKS
1 MDMA DISGR T438M Control Parameter for MRP -Material Level- MTART
0 MDMA DISLS T439A MRP Lot Sizes MANDT
0 MDMA DISLS T439A MRP Lot Sizes DISLS
1 MDMA DISMM T438A MRP Type MANDT
1 MDMA DISMM T438A MRP Type DISMM
0 MDMA DISPO T024D MRP Controllers MANDT
0 MDMA DISPO T024D MRP Controllers WERKS
0 MDMA DISPO T024D MRP Controllers DISPO
1 MDMA DISPR MDIP Material: MRP Profiles (Field Contents) MANDT
0 MDMA LAGPR T439L Warehouse costs for MRP lot size MANDT
0 MDMA LAGPR T439L Warehouse costs for MRP lot size LAGPR
1 MDMA LFRHY T439G PP Planning periods: header table MANDT
1 MDMA LFRHY T439G PP Planning periods: header table WERKS
0 MDMA LGFSB MDLG Customizing: MRP Area Storage Location MANDT
0 MDMA LGFSB MDLG Customizing: MRP Area Storage Location BERID
0 MDMA LGFSB MDLG Customizing: MRP Area Storage Location WERKS
0 MDMA LGFSB MDLG Customizing: MRP Area Storage Location LGORT
1 MDMA LGPRO MDLG Customizing: MRP Area Storage Location MANDT
1 MDMA LGPRO MDLG Customizing: MRP Area Storage Location BERID
1 MDMA LGPRO MDLG Customizing: MRP Area Storage Location WERKS
1 MDMA LGPRO MDLG Customizing: MRP Area Storage Location LGORT
0 MDMA MANDT T000 Clients MANDT
1 MDMA MATNR MARA General Material Data MANDT
1 MDMA MATNR MARA General Material Data MATNR
0 MDMA MRPPP T439G PP Planning periods: header table MANDT
0 MDMA MRPPP T439G PP Planning periods: header table WERKS
1 MDMA RDPRF RDPR Rounding profile MANDT
1 MDMA RDPRF RDPR Rounding profile WERKS
1 MDMA RDPRF RDPR Rounding profile RDPRF
1 MDMA RDPRF RDPR Rounding profile RDZAE
0 MDMA RWPRO T438R Range of coverage profile MANDT
0 MDMA RWPRO T438R Range of coverage profile RWPRO
1 MDMA SHPRO T438V Period Profile for Safety Time MANDT
0 MDMA SOBSL T460A Special procurement key MANDT
0 MDMA SOBSL T460A Special procurement key WERKS
0 MDMA SOBSL T460A Special procurement key SOBSL
1 MDMA WERKS T001W Plants/Branches MANDT
1 MDMA WERKS T001W Plants/Branches WERKS