MDMA

MRP Area for Material | #masterdata | Component: Master Data
Column Name Description
MANDT FK Client
MATNR FK Material Number
BERID FK MRP Area
Column Name Description
💲 Currency Key (T001.WAERS):
LOSFX Lot-Size-Independent Costs
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
MINBE Reorder Point
BSTRF Rounding value for purchase order quantity
BSTMI Minimum Lot Size
BSTMA Maximum Lot Size
MABST Maximum Stock Level
EISBE Safety Stock
BSTFE Fixed lot size
SCM_SAFTY_V Safety Stock for Virtual Child Location
SCM_PPSAFTYSTK Safety Stock at Parent Location
SCM_PPSAFTYSTK_V Safety Stock of Parent Location Virtual Child Location
SCM_REPSAFTY Repair Safety Stock
SCM_REPSAFTY_V Repair Safety Stock for Virtual Child Location
SCM_REORD_V Reorder Point for Virtual Child Location
SCM_MAXSTOCK_V Maximum Stock Level for Virtual Child Locations
SCM_CONINP Consumption of Storage Capacity per Unit of Material
📏 Unit of Measure: Handling Capacity in Goods Receipt (MARC.SCM_HUNIT):
SCM_CONHAP Handling Capacity Consumption in Unit of Measure (Gds Rcpt)
📏 Unit of Measure: Handling Capacity in Goods Issue (MARC.SCM_HUNIT_OUT):
SCM_CONHAP_OUT Handling Capacity Consumption in Unit of Measure (Gds Issue)
Column Name Description
VRBDT To date of the material to be copied for consumption
AEDAT Last Changed On
AEZEIT Time of Change
Column Name Description
LOEKZ Deletion Indicator Show values
AHDIS MRP relevancy for dependent requirements Show values
AUTRU Reset Forecast Model Automatically Show values
KZKFK Indicator: take correction factors into account Show values
SHFLG Safety time indicator (with or without safety time) Show values
APOKZ Indicator: Is material relevant for APO Show values
PLIFZX Consider Planned Delivery Time of the MRP Area Show values
SFTY_STK_METH MRP Safety Stock Method Show values
SCM_TPOP Third-Party Order Processing Show values
MAXDOS_FLG Is Max Dos Active Show values
SAFTYSTOCK_METHOD Method for Calculating Safety Stock Show values
TARGET_STOCK_LEVEL_METH Target Stock Level Method Show values
AUTO_DET_SFTYSTK_METH Safety stock method Automatic determination Show values
USE_PERIOD_FACTOR Use Period Factor Show values
PERIOD_FACTOR_VALUE Period Factor for Calculating the Availability Date/Time Show values
PERIOD_FACTOR_TDS Period factor Time dependent Stock Levels Show values
SDM_VERSION Silent Data migration status from MDMA table Show values
Column Name Description Domain name
FXHOR Planning time fence FXHOR
TAKZT Takt time DEC3
AUSSS Assembly scrap in percent DEC3_2
SHZET Safety Time (in Workdays) NUMC2
LGRAD Service level DEC2_1
PROPR Forecast profile PROPR
VRBMT Reference material for consumption MATNR
VRBDB Reference MRP area - consumption BERID
VRBFK Multiplier for reference material for consumption DEC2_2
PSTAT Maintenance status PSTAT
PLIFZ Planned Delivery Time in Days DEC3
AENAM Name of Person Who Changed Object USNAM
SCM_MATLOCID_GUID16 Internal Key for Product SYSUUID
SCM_MATLOCID_GUID22 Internal Number (UID) for Location Product /SAPAPO/MATLOCID
SCM_GRPRT Goods Receipt Processing Time TSTRDURAG
SCM_GIPRT Goods Issue Processing Time TSTRDURAG
SCM_RRP_TYPE PP Planning Procedure
SCM_HEUR_ID PPC Heuristics
SCM_PACKAGE_ID Planning Package to Which Product Belongs
SCM_RRP_SEL_GROUP Planning Group
SCM_REORD_DUR Reorder Days' Supply (in Workdays) TSTRDURAG
SCM_TARGET_DUR Target Days' Supply in Workdays TSTRDURAG
SCM_TSTRID Planning Calendar for Periodic Lot Sizing Procedure /SAPAPO/TSTRID
SCM_THRUPUT_TIME Throughput Time TSTRDURAG
SCM_SCOST_PRCNT Cost Factor for Stockholding Costs /SAPAPO/PERCENT_SCOST
SCM_PROC_COST Procurement Costs for Product /SAPAPO/DEC13
SCM_NDCOSTWE Goods Receiving Costs
SCM_NDCOSTWA Goods Issue Costs
MAXDOS_PEN Penalty exceeding time dependent Max Days' of Supply /SAPAPO/DEC13
Master Data Relations Join Conditions
MRP area ID
  • MDMA.MANDT == MDLV.MANDT
  • MDMA.BERID == MDLV.BERID
MRP Group
  • MRP Group
  • Client
  • MRP Area: Plant
  • MDMA.DISGR == T438M.MTART
  • MDMA.MANDT == T438M.MANDT
  • MDMA.WERKS == T438M.WERKS
Lot Sizing Procedure within Materials Planning
  • Lot Sizing Procedure within Materials Planning
  • Client
  • MDMA.DISLS == T439A.DISLS
  • MDMA.MANDT == T439A.MANDT
MRP Type
  • MDMA.MANDT == T438A.MANDT
  • MDMA.DISMM == T438A.DISMM
MRP Controller
  • MRP Area: Plant
  • MRP Controller
  • Client
  • MDMA.WERKS == T024D.WERKS
  • MDMA.DISPO == T024D.DISPO
  • MDMA.MANDT == T024D.MANDT
Material: MRP profile
  • MDMA.MANDT == MDIP.MANDT
  • MDMA.DISPR == MDIP.DISPR
Storage costs percentage
  • Storage Costs Percentage Code
  • MRP Area: Plant
  • MDMA.MANDT == T439L.MANDT
  • MDMA.LAGPR == T439L.LAGPR
  • MDMA.WERKS == T439L.WERKS
Planning Cycle
  • Planning Cycle
  • MRP Area: Plant
  • MDMA.MANDT == T439G.MANDT
  • MDMA.LFRHY == T439G.MRPPP
  • MDMA.WERKS == T439G.WERKS
Default storage location for external procurement
  • MRP Area: Plant
  • MRP Area
  • Default storage location for external procurement
  • MDMA.MANDT == MDLG.MANDT
  • MDMA.WERKS == MDLG.WERKS
  • MDMA.BERID == MDLG.BERID
  • MDMA.LGFSB == MDLG.LGORT
Production storage location
  • MRP Area: Plant
  • MRP Area
  • Issue Storage Location
  • MDMA.MANDT == MDLG.MANDT
  • MDMA.WERKS == MDLG.WERKS
  • MDMA.BERID == MDLG.BERID
  • MDMA.LGPRO == MDLG.LGORT
Client MDMA.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • MDMA.MATNR == MARA.MATNR
  • MDMA.MANDT == MARA.MANDT
PPC Planning Calendar
  • PPC Planning Calendar
  • MRP Area: Plant
  • MDMA.MANDT == T439G.MANDT
  • MDMA.MRPPP == T439G.MRPPP
  • MDMA.WERKS == T439G.WERKS
Rounding Profile
  • ?
  • Rounding Profile
  • ?
  • MDMA.MANDT == RDPR.MANDT
  • MDMA.[column in domain "WERKS_D"] == RDPR.WERKS
  • MDMA.RDPRF == RDPR.RDPRF
  • MDMA.[column in domain "RDZAE"] == RDPR.RDZAE
Range of coverage profile
  • MRP Area: Plant
  • Range of coverage profile
  • MDMA.MANDT == T438R.MANDT
  • MDMA.WERKS == T438R.WERKS
  • MDMA.RWPRO == T438R.RWPRO
Period Profile for Safety Time
  • MRP Area: Plant
  • Client
  • Period Profile for Safety Time
  • MDMA.WERKS == T438V.WERKS
  • MDMA.MANDT == T438V.MANDT
  • MDMA.SHPRO == T438V.SHPRO
Special procurement type
  • MRP Area: Plant
  • Special procurement type
  • MDMA.MANDT == T460A.MANDT
  • MDMA.WERKS == T460A.WERKS
  • MDMA.SOBSL == T460A.SOBSL
MRP Area: Plant
  • MDMA.MANDT == T001W.MANDT
  • MDMA.WERKS == T001W.WERKS