I_ProductPlantMRPTP

BO View for Product MRP Area | view: IPRDPLNTMRPTP | TRAN | Extraction: Not supported | Component: Material Master

Tables used: MARA, MARA, MDMA, T001, T001K, T001W

🔑 Keys (3)
💰 Amounts (1)
∑ Quantities (14)
📅 Dates (1)
☰ Categorical (12)
Other (20)
🔗 Relations (21)

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
ReorderDaysSupplyInWorkDayCalc	Reorder Days' Supply (in Workdays)
TargetDaysSupplyInWorkDaysCalc	Target Days' Supply in Workdays
LocProdGoodsRcptProcHoursCalc	Goods Receipt Processing Time
LocProdGoodsIssueProcHoursCalc	Goods Issue Processing Time
📏 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
DependentRqmtMRPRelevance	MRP relevancy for dependent requirements	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
ProductPlanningPackage	Planning Package to Which Product Belongs
ProductPlanningGroup	Planning Group
ReorderDaysSupplyInWorkDays	Reorder Days' Supply (in Workdays)	CMD_PRD_TSTRDURAG_DEC
TargetDaysSupplyInWorkDays	Target 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 Base Unit of Measure Client	`I_PRODUCTPLANTMRPTP.BASEUNIT == T006.MSEHI` `I_PRODUCTPLANTMRPTP.MANDT == T006.MANDT`
Currency Key Currency Key Client	`I_PRODUCTPLANTMRPTP.CURRENCY == TCURC.WAERS` `I_PRODUCTPLANTMRPTP.MANDT == TCURC.MANDT`
Default storage location for external procurement Default storage location for external procurement MRP Area MRP Area Client MRP Area: Plant MRP Area: Plant	`I_PRODUCTPLANTMRPTP.DFLTSTORAGELOCATIONEXTPROCMT == MDLG.LGORT` `I_PRODUCTPLANTMRPTP.MRPAREA == MDLG.BERID` `I_PRODUCTPLANTMRPTP.MRPAREAFOREDIT == MDLG.BERID` `I_PRODUCTPLANTMRPTP.MANDT == MDLG.MANDT` `I_PRODUCTPLANTMRPTP.PLANT == MDLG.WERKS` `I_PRODUCTPLANTMRPTP.PLANTFOREDIT == MDLG.WERKS`
Lot Sizing Procedure within Materials Planning Lot Sizing Procedure within Materials Planning Client	`I_PRODUCTPLANTMRPTP.LOTSIZINGPROCEDURE == T439A.DISLS` `I_PRODUCTPLANTMRPTP.MANDT == T439A.MANDT`
MRP area ID MRP Area MRP Area Client	`I_PRODUCTPLANTMRPTP.MRPAREA == MDLV.BERID` `I_PRODUCTPLANTMRPTP.MRPAREAFOREDIT == MDLV.BERID` `I_PRODUCTPLANTMRPTP.MANDT == MDLV.MANDT`
MRP area ID MRP Area MRP Area Client	`I_PRODUCTPLANTMRPTP.MRPAREA == MDLV.BERID` `I_PRODUCTPLANTMRPTP.MRPAREAFOREDIT == MDLV.BERID` `I_PRODUCTPLANTMRPTP.MANDT == MDLV.MANDT`
MRP Group MRP Group Client MRP Area: Plant MRP Area: Plant	`I_PRODUCTPLANTMRPTP.MRPGROUP == T438M.MTART` `I_PRODUCTPLANTMRPTP.MANDT == T438M.MANDT` `I_PRODUCTPLANTMRPTP.PLANT == T438M.WERKS` `I_PRODUCTPLANTMRPTP.PLANTFOREDIT == T438M.WERKS`
PPC Planning Calendar PPC Planning Calendar Client MRP Area: Plant MRP Area: Plant	`I_PRODUCTPLANTMRPTP.MRPPLANNINGCALENDAR == T439G.MRPPP` `I_PRODUCTPLANTMRPTP.MANDT == T439G.MANDT` `I_PRODUCTPLANTMRPTP.PLANT == T439G.WERKS` `I_PRODUCTPLANTMRPTP.PLANTFOREDIT == T439G.WERKS`
MRP Controller MRP Controller Client MRP Area: Plant MRP Area: Plant	`I_PRODUCTPLANTMRPTP.MRPRESPONSIBLE == T024D.DISPO` `I_PRODUCTPLANTMRPTP.MANDT == T024D.MANDT` `I_PRODUCTPLANTMRPTP.PLANT == T024D.WERKS` `I_PRODUCTPLANTMRPTP.PLANTFOREDIT == T024D.WERKS`
MRP Type MRP Type Client	`I_PRODUCTPLANTMRPTP.MRPTYPE == T438A.DISMM` `I_PRODUCTPLANTMRPTP.MANDT == T438A.MANDT`
Period Profile for Safety Time Period Profile for Safety Time Client MRP Area: Plant MRP Area: Plant	`I_PRODUCTPLANTMRPTP.PERDPRFLFORSFTYTME == T438V.SHPRO` `I_PRODUCTPLANTMRPTP.MANDT == T438V.MANDT` `I_PRODUCTPLANTMRPTP.PLANT == T438V.WERKS` `I_PRODUCTPLANTMRPTP.PLANTFOREDIT == T438V.WERKS`
Planning Cycle Planning Cycle Client MRP Area: Plant MRP Area: Plant	`I_PRODUCTPLANTMRPTP.PLANANDORDERDAYDETERMINATION == T439G.MRPPP` `I_PRODUCTPLANTMRPTP.MANDT == T439G.MANDT` `I_PRODUCTPLANTMRPTP.PLANT == T439G.WERKS` `I_PRODUCTPLANTMRPTP.PLANTFOREDIT == T439G.WERKS`
MRP Area: Plant Client MRP Area: Plant MRP Area: Plant	`I_PRODUCTPLANTMRPTP.MANDT == T001W.MANDT` `I_PRODUCTPLANTMRPTP.PLANT == T001W.WERKS` `I_PRODUCTPLANTMRPTP.PLANTFOREDIT == T001W.WERKS`
MRP Area: Plant Client MRP Area: Plant MRP Area: Plant	`I_PRODUCTPLANTMRPTP.MANDT == T001W.MANDT` `I_PRODUCTPLANTMRPTP.PLANT == T001W.WERKS` `I_PRODUCTPLANTMRPTP.PLANTFOREDIT == T001W.WERKS`
Special procurement type Client Special procurement type MRP Area: Plant MRP Area: Plant	`I_PRODUCTPLANTMRPTP.MANDT == T460A.MANDT` `I_PRODUCTPLANTMRPTP.PROCUREMENTSUBTYPE == T460A.SOBSL` `I_PRODUCTPLANTMRPTP.PLANT == T460A.WERKS` `I_PRODUCTPLANTMRPTP.PLANTFOREDIT == T460A.WERKS`
Material Number Material Number Material Number Client	`I_PRODUCTPLANTMRPTP.PRODUCTFOREDIT == MARA.MATNR` `I_PRODUCTPLANTMRPTP.PRODUCT == MARA.MATNR` `I_PRODUCTPLANTMRPTP.MANDT == MARA.MANDT`
Material Number Material Number Material Number Client	`I_PRODUCTPLANTMRPTP.PRODUCTFOREDIT == MARA.MATNR` `I_PRODUCTPLANTMRPTP.PRODUCT == MARA.MATNR` `I_PRODUCTPLANTMRPTP.MANDT == MARA.MANDT`
Range of coverage profile Range of coverage profile Client MRP Area: Plant MRP Area: Plant	`I_PRODUCTPLANTMRPTP.RANGEOFCVRGPRFLCODE == T438R.RWPRO` `I_PRODUCTPLANTMRPTP.MANDT == T438R.MANDT` `I_PRODUCTPLANTMRPTP.PLANT == T438R.WERKS` `I_PRODUCTPLANTMRPTP.PLANTFOREDIT == T438R.WERKS`
Rounding Profile Rounding Profile ? ? Client	`I_PRODUCTPLANTMRPTP.ROUNDINGPROFILE == RDPR.RDPRF` `I_PRODUCTPLANTMRPTP.[column in domain "RDZAE"] == RDPR.RDZAE` `I_PRODUCTPLANTMRPTP.[column in domain "WERKS_D"] == RDPR.WERKS` `I_PRODUCTPLANTMRPTP.MANDT == RDPR.MANDT`
Storage costs percentage Storage Costs Percentage Code Client MRP Area: Plant MRP Area: Plant	`I_PRODUCTPLANTMRPTP.STORAGECOSTSPERCENTAGECODE == T439L.LAGPR` `I_PRODUCTPLANTMRPTP.MANDT == T439L.MANDT` `I_PRODUCTPLANTMRPTP.PLANT == T439L.WERKS` `I_PRODUCTPLANTMRPTP.PLANTFOREDIT == T439L.WERKS`
Production storage location Issue Storage Location MRP Area MRP Area Client MRP Area: Plant MRP Area: Plant	`I_PRODUCTPLANTMRPTP.STORAGELOCATION == MDLG.LGORT` `I_PRODUCTPLANTMRPTP.MRPAREA == MDLG.BERID` `I_PRODUCTPLANTMRPTP.MRPAREAFOREDIT == MDLG.BERID` `I_PRODUCTPLANTMRPTP.MANDT == MDLG.MANDT` `I_PRODUCTPLANTMRPTP.PLANT == MDLG.WERKS` `I_PRODUCTPLANTMRPTP.PLANTFOREDIT == MDLG.WERKS`