P_PRODUCTPLANTMRP

MRP area data of a Product | view: PPRDPLNTMRP | TRAN | Extraction: Not supported | Component: Material Requirements Planning

Tables used: MDLV, MDMA

🔑 Keys (3)
💰 Amounts (1)
∑ Quantities (7)
📅 Dates (1)
☰ Categorical (5)
Other (7)
🔗 Relations (16)

Column Name	Description
Product FK	Material Number
MRPArea FK	MRP Area
Plant FK	MRP Area: Plant

Column Name	Description
LotSizeIndependentCosts	Lot-Size-Independent Costs

Column Name	Description
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

Column Name	Description
CreationDate	To date of the material to be copied for consumption

Column Name	Description
MRPAreaCategory	MRP Area Category	Show values
IsMarkedForDeletion	Deletion Indicator	Show values
IsMRPDependentRqmt	MRP relevancy for dependent requirements	Show values
IsSafetyTime	Safety time indicator (with or without safety time)	Show values
IsPlannedDeliveryTime	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	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
TaktTime	Takt time	DEC3

Master Data Relations	Join Conditions
Default storage location for external procurement MRP Area Default storage location for external procurement Client MRP Area: Plant	`P_PRODUCTPLANTMRP.MRPAREA == MDLG.BERID` `P_PRODUCTPLANTMRP.DFLTSTORAGELOCATIONEXTPROCMT == MDLG.LGORT` `P_PRODUCTPLANTMRP.MANDT == MDLG.MANDT` `P_PRODUCTPLANTMRP.PLANT == MDLG.WERKS`
Storage costs percentage Storage Costs Percentage Code Client MRP Area: Plant	`P_PRODUCTPLANTMRP.ISSTORAGECOSTS == T439L.LAGPR` `P_PRODUCTPLANTMRP.MANDT == T439L.MANDT` `P_PRODUCTPLANTMRP.PLANT == T439L.WERKS`
Lot Sizing Procedure within Materials Planning Lot Sizing Procedure within Materials Planning Client	`P_PRODUCTPLANTMRP.LOTSIZINGPROCEDURE == T439A.DISLS` `P_PRODUCTPLANTMRP.MANDT == T439A.MANDT`
MRP area ID MRP Area Client	`P_PRODUCTPLANTMRP.MRPAREA == MDLV.BERID` `P_PRODUCTPLANTMRP.MANDT == MDLV.MANDT`
MRP Group MRP Group Client MRP Area: Plant	`P_PRODUCTPLANTMRP.MRPGROUP == T438M.MTART` `P_PRODUCTPLANTMRP.MANDT == T438M.MANDT` `P_PRODUCTPLANTMRP.PLANT == T438M.WERKS`
PPC Planning Calendar PPC Planning Calendar Client MRP Area: Plant	`P_PRODUCTPLANTMRP.MRPPLANNINGCALENDAR == T439G.MRPPP` `P_PRODUCTPLANTMRP.MANDT == T439G.MANDT` `P_PRODUCTPLANTMRP.PLANT == T439G.WERKS`
MRP Controller MRP Controller Client MRP Area: Plant	`P_PRODUCTPLANTMRP.MRPRESPONSIBLE == T024D.DISPO` `P_PRODUCTPLANTMRP.MANDT == T024D.MANDT` `P_PRODUCTPLANTMRP.PLANT == T024D.WERKS`
MRP Type MRP Type Client	`P_PRODUCTPLANTMRP.MRPTYPE == T438A.DISMM` `P_PRODUCTPLANTMRP.MANDT == T438A.MANDT`
Period Profile for Safety Time Period Profile for Safety Time Client MRP Area: Plant	`P_PRODUCTPLANTMRP.PERDPRFLFORSFTYTME == T438V.SHPRO` `P_PRODUCTPLANTMRP.MANDT == T438V.MANDT` `P_PRODUCTPLANTMRP.PLANT == T438V.WERKS`
Planning Cycle Planning Cycle Client MRP Area: Plant	`P_PRODUCTPLANTMRP.PLANANDORDERDAYDETERMINATION == T439G.MRPPP` `P_PRODUCTPLANTMRP.MANDT == T439G.MANDT` `P_PRODUCTPLANTMRP.PLANT == T439G.WERKS`
MRP Area: Plant Client MRP Area: Plant	`P_PRODUCTPLANTMRP.MANDT == T001W.MANDT` `P_PRODUCTPLANTMRP.PLANT == T001W.WERKS`
Special procurement type Client Special procurement type MRP Area: Plant	`P_PRODUCTPLANTMRP.MANDT == T460A.MANDT` `P_PRODUCTPLANTMRP.PROCUREMENTSUBTYPE == T460A.SOBSL` `P_PRODUCTPLANTMRP.PLANT == T460A.WERKS`
Material Number Material Number Client	`P_PRODUCTPLANTMRP.PRODUCT == MARA.MATNR` `P_PRODUCTPLANTMRP.MANDT == MARA.MANDT`
Range of coverage profile Client Range of coverage profile MRP Area: Plant	`P_PRODUCTPLANTMRP.MANDT == T438R.MANDT` `P_PRODUCTPLANTMRP.RANGEOFCVRGPRFLCODE == T438R.RWPRO` `P_PRODUCTPLANTMRP.PLANT == T438R.WERKS`
Rounding Profile ? ? Rounding Profile Client	`P_PRODUCTPLANTMRP.[column in domain "RDZAE"] == RDPR.RDZAE` `P_PRODUCTPLANTMRP.[column in domain "WERKS_D"] == RDPR.WERKS` `P_PRODUCTPLANTMRP.ROUNDINGPROFILE == RDPR.RDPRF` `P_PRODUCTPLANTMRP.MANDT == RDPR.MANDT`
Production storage location MRP Area Issue Storage Location Client MRP Area: Plant	`P_PRODUCTPLANTMRP.MRPAREA == MDLG.BERID` `P_PRODUCTPLANTMRP.STORAGELOCATION == MDLG.LGORT` `P_PRODUCTPLANTMRP.MANDT == MDLG.MANDT` `P_PRODUCTPLANTMRP.PLANT == MDLG.WERKS`