C_ProductStoreMRP

Consumption View: Product Store MRP Area | view: CPRDSTOREMRP | Extraction: Not supported | Component: Material Master

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

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

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

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

Column Name	Description

Column Name	Description
IsMarkedForDeletion	Deletion Indicator	Show values
ProductSafetyTimeMRPRelevance	Safety time indicator (with or without safety time)	Show values
DependentRqmtMRPRelevance	MRP relevancy for dependent requirements	Show values
IsPlannedDeliveryTime	Consider Planned Delivery Time of the MRP Area	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
MaintenanceStatusName	Maintenance status	PSTAT
PlannedDeliveryDurationInDays	Planned Delivery Time in Days	DEC3
RqmtQtyRcptTaktTmeInWrkgDays	Takt time	DEC3
SrvcLvl	Service level	DEC2_1

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