I_ProductPlantMRP

MRP area data of a Product | view: IPRDPLNTMRP | Extraction: Not supported | Component: Material Master
Tables used: MARA, MARA, MDMA, T001, T001K, T001W
Column Name Description
Product FK Material Number
MRPArea FK MRP Area
Plant FK MRP Area: Plant
Column Name Description
💲 Currency Key (Currency):
LotSizeIndependentCosts Lot-Size-Independent Costs
Column Name Description
📏 Base Unit of Measure (BaseUnit):
ReorderThresholdQuantity Reorder Point
LotSizeRoundingQuantity Rounding value for purchase order quantity
MinimumLotSizeQuantity Minimum Lot Size
MaximumLotSizeQuantity Maximum Lot Size
MaximumStockQuantity Maximum Stock Level
SafetyStockQuantity Safety Stock
FixedLotSizeQuantity Fixed lot size
📏 Unit of Measure: Handling Capacity in Goods Receipt (GRHandlingCapacityUnit):
GRHandlingCapacityQuantity Handling Capacity Consumption in Unit of Measure (Gds Rcpt)
📏 Unit of Measure: Handling Capacity in Goods Issue (GIHandlingCapacityUnit):
GIHandlingCapacityQuantity Handling Capacity Consumption in Unit of Measure (Gds Issue)
📏 Unit of Measurement of Size (ConsumptionOfStorageCapUnit):
ConsumptionOfStorageCapacity Consumption of Storage Capacity per Unit of Material
Column Name Description
CreationDate To date of the material to be copied for consumption
Column Name Description
IsMarkedForDeletion Deletion Indicator Show values
IsMRPDependentRqmt MRP relevancy for dependent requirements Show values
DependentRqmtMRPRelevance MRP relevancy for dependent requirements Show values
IsSafetyTime Safety time indicator (with or without safety time) Show values
ProductSafetyTimeMRPRelevance Safety time indicator (with or without safety time) Show values
IsPlannedDeliveryTime Consider Planned Delivery Time of the MRP Area Show values
MRPSafetyStockMethod MRP Safety Stock Method Show values
MaxDaysOfSupplyIsActive Is Max Dos Active Show values
AdvncdPlngSftyStkMeth Method for Calculating Safety Stock Show values
AdvncdPlngTgtStkLvlMeth Target Stock Level Method Show values
SftyStkMethIsAutomlyDtmnd Checkbox Show values
PeriodFactorIsUsed Use Period Factor Show values
AdvncdPlngPeriodFactorValue Period Factor for Calculating the Availability Date/Time Show values
TimeDepdntStkLvlPerdFactorVal Period factor Time dependent Stock Levels Show values
Column Name Description Domain name
PlanningTimeFence Planning time fence FXHOR
AssemblyScrapPercent Assembly scrap in percent DEC3_2
SafetyDuration Safety Time (in Workdays) NUMC2
SrvcLvl Service level DEC2_1
MaintenanceStatusName Maintenance status PSTAT
PlannedDeliveryDurationInDays Planned Delivery Time in Days DEC3
RqmtQtyRcptTaktTmeInWrkgDays Takt time DEC3
PPPlanningProcedure PP Planning Procedure
ProdnPlngHeuristic PPC Heuristics
ProductPlanningGroup Planning Group
ProductPlanningPackage Planning Package to Which Product Belongs
TargetDaysSupplyInWorkDays Target Days' Supply in Workdays CMD_PRD_TSTRDURAG_DEC
ReorderDaysSupplyInWorkDays Reorder Days' Supply (in Workdays) CMD_PRD_TSTRDURAG_DEC
PlngCalendarPerdcLotSizing Planning Calendar for Periodic Lot Sizing Procedure /SAPAPO/TSTRID
LocProdGoodsReceiptProcHours Goods Receipt Processing Time CMD_PRD_TSTRDURAG_DEC
LocProdGoodsIssueProcHours Goods Issue Processing Time CMD_PRD_TSTRDURAG_DEC
ProductProcurementCostsVal Procurement Costs for Product /SAPAPO/DEC13
GoodsReceiptHandlingCost Goods Receiving Costs
GoodsIssueHandlingCost Goods Issue Costs
MaxDaysOfSupplyPenaltyAmount Penalty exceeding time dependent Max Days' of Supply /SAPAPO/DEC13
Master Data Relations Join Conditions
Unit of Measure
  • Client
  • Base Unit of Measure
  • I_PRODUCTPLANTMRP.MANDT == T006.MANDT
  • I_PRODUCTPLANTMRP.BASEUNIT == T006.MSEHI
Currency Key
  • Client
  • Currency Key
  • I_PRODUCTPLANTMRP.MANDT == TCURC.MANDT
  • I_PRODUCTPLANTMRP.CURRENCY == TCURC.WAERS
Default storage location for external procurement
  • MRP Area: Plant
  • MRP Area
  • Default storage location for external procurement
  • Client
  • I_PRODUCTPLANTMRP.PLANT == MDLG.WERKS
  • I_PRODUCTPLANTMRP.MRPAREA == MDLG.BERID
  • I_PRODUCTPLANTMRP.DFLTSTORAGELOCATIONEXTPROCMT == MDLG.LGORT
  • I_PRODUCTPLANTMRP.MANDT == MDLG.MANDT
Lot Sizing Procedure within Materials Planning
  • Lot Sizing Procedure within Materials Planning
  • Client
  • I_PRODUCTPLANTMRP.LOTSIZINGPROCEDURE == T439A.DISLS
  • I_PRODUCTPLANTMRP.MANDT == T439A.MANDT
MRP area ID
  • MRP Area
  • Client
  • I_PRODUCTPLANTMRP.MRPAREA == MDLV.BERID
  • I_PRODUCTPLANTMRP.MANDT == MDLV.MANDT
MRP Group
  • MRP Area: Plant
  • MRP Group
  • Client
  • I_PRODUCTPLANTMRP.PLANT == T438M.WERKS
  • I_PRODUCTPLANTMRP.MRPGROUP == T438M.MTART
  • I_PRODUCTPLANTMRP.MANDT == T438M.MANDT
PPC Planning Calendar
  • MRP Area: Plant
  • Client
  • PPC Planning Calendar
  • I_PRODUCTPLANTMRP.PLANT == T439G.WERKS
  • I_PRODUCTPLANTMRP.MANDT == T439G.MANDT
  • I_PRODUCTPLANTMRP.MRPPLANNINGCALENDAR == T439G.MRPPP
MRP Controller
  • MRP Area: Plant
  • MRP Controller
  • Client
  • I_PRODUCTPLANTMRP.PLANT == T024D.WERKS
  • I_PRODUCTPLANTMRP.MRPRESPONSIBLE == T024D.DISPO
  • I_PRODUCTPLANTMRP.MANDT == T024D.MANDT
MRP Type
  • MRP Type
  • Client
  • I_PRODUCTPLANTMRP.MRPTYPE == T438A.DISMM
  • I_PRODUCTPLANTMRP.MANDT == T438A.MANDT
Period Profile for Safety Time
  • MRP Area: Plant
  • Period Profile for Safety Time
  • Client
  • I_PRODUCTPLANTMRP.PLANT == T438V.WERKS
  • I_PRODUCTPLANTMRP.PERDPRFLFORSFTYTME == T438V.SHPRO
  • I_PRODUCTPLANTMRP.MANDT == T438V.MANDT
Planning Cycle
  • MRP Area: Plant
  • Planning Cycle
  • Client
  • I_PRODUCTPLANTMRP.PLANT == T439G.WERKS
  • I_PRODUCTPLANTMRP.PLANANDORDERDAYDETERMINATION == T439G.MRPPP
  • I_PRODUCTPLANTMRP.MANDT == T439G.MANDT
MRP Area: Plant
  • MRP Area: Plant
  • Client
  • I_PRODUCTPLANTMRP.PLANT == T001W.WERKS
  • I_PRODUCTPLANTMRP.MANDT == T001W.MANDT
Special procurement type
  • MRP Area: Plant
  • Special procurement type
  • Client
  • I_PRODUCTPLANTMRP.PLANT == T460A.WERKS
  • I_PRODUCTPLANTMRP.PROCUREMENTSUBTYPE == T460A.SOBSL
  • I_PRODUCTPLANTMRP.MANDT == T460A.MANDT
Material Number
  • Material Number
  • Client
  • I_PRODUCTPLANTMRP.PRODUCT == MARA.MATNR
  • I_PRODUCTPLANTMRP.MANDT == MARA.MANDT
Range of coverage profile
  • MRP Area: Plant
  • Client
  • Range of coverage profile
  • I_PRODUCTPLANTMRP.PLANT == T438R.WERKS
  • I_PRODUCTPLANTMRP.MANDT == T438R.MANDT
  • I_PRODUCTPLANTMRP.RANGEOFCVRGPRFLCODE == T438R.RWPRO
Rounding Profile
  • ?
  • ?
  • Rounding Profile
  • Client
  • I_PRODUCTPLANTMRP.[column in domain "RDZAE"] == RDPR.RDZAE
  • I_PRODUCTPLANTMRP.[column in domain "WERKS_D"] == RDPR.WERKS
  • I_PRODUCTPLANTMRP.ROUNDINGPROFILE == RDPR.RDPRF
  • I_PRODUCTPLANTMRP.MANDT == RDPR.MANDT
Storage costs percentage
  • MRP Area: Plant
  • Storage Costs Percentage Code
  • Client
  • I_PRODUCTPLANTMRP.PLANT == T439L.WERKS
  • I_PRODUCTPLANTMRP.STORAGECOSTSPERCENTAGECODE == T439L.LAGPR
  • I_PRODUCTPLANTMRP.MANDT == T439L.MANDT
Production storage location
  • MRP Area: Plant
  • Issue Storage Location
  • MRP Area
  • Client
  • I_PRODUCTPLANTMRP.PLANT == MDLG.WERKS
  • I_PRODUCTPLANTMRP.STORAGELOCATION == MDLG.LGORT
  • I_PRODUCTPLANTMRP.MRPAREA == MDLG.BERID
  • I_PRODUCTPLANTMRP.MANDT == MDLG.MANDT