C_ProductSupplyPlanning

Consumption - Product Supply Planning | view: CPRDSUPPLANNING | Extraction: Not supported | Component: Material Master

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

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities (8)
📅 Dates
☰ Categorical (7)
Other (11)
🔗 Relations (22)

Column Name	Description
Product FK	Product Number
Plant FK	Plant

Column Name	Description
💲 Currency Key (Currency):
LotSizeIndependentCosts	Lot-Size-Independent Costs

Column Name	Description
📏 Base Unit of Measure (BaseUnit):
FixedLotSizeQuantity	Fixed lot size
MaximumLotSizeQuantity	Maximum Lot Size
MinimumLotSizeQuantity	Minimum Lot Size
LotSizeRoundingQuantity	Rounding value for purchase order quantity
SafetyStockQuantity	Safety Stock
MinimumSafetyStockQuantity	Minimum Safety Stock
MaximumStockQuantity	Maximum Stock Level
ReorderThresholdQuantity	Reorder Point

Column Name	Description

Column Name	Description
ProcurementType	Procurement Type	Show values
IsSafetyTime	Safety time indicator (with or without safety time)	Show values
IsMRPDependentRqmt	MRP relevancy for dependent requirements	Show values
ProdRqmtsConsumptionMode	Consumption mode	Show values
MatlCompIsMarkedForBackflush	Indicator: Backflush	Show values
RepetitiveManufacturingIsAllwd	Repetitive Manufacturing Enabled	Show values
MRPSafetyStockMethod	MRP Safety Stock Method	Show values

Column Name	Description	Domain name
SafetyDuration	Safety Time (in Workdays)	NUMC2
PlanningTimeFence	Planning time fence	FXHOR
PlannedDeliveryDurationInDays	Planned Delivery Time in Days	DEC3
TotalReplenishmentLeadTime	Total replenishment lead time (in workdays)	DEC3
AssemblyScrapPercent	Assembly scrap in percent	DEC3_2
GoodsReceiptDuration	Goods receipt processing time in days	DEC3
RqmtQtyRcptTaktTmeInWrkgDays	Takt time	DEC3
SrvcLvl	Service level	DEC2_1
InHouseProductionTime	In-house production time	DEC3
BackwardCnsmpnPeriodInWorkDays	Consumption Period: Backward	VRINT
FwdConsumptionPeriodInWorkDays	Consumption period: Forward	VRINT

Master Data Relations	Join Conditions
Value Table for ABC Indicator ABC Indicator Client	`C_PRODUCTSUPPLYPLANNING.ABCINDICATOR == TMABC.MAABC` `C_PRODUCTSUPPLYPLANNING.MANDT == TMABC.MANDT`
Checking Group for Availability Check Client Checking Group for Availability Check	`C_PRODUCTSUPPLYPLANNING.MANDT == TMVF.MANDT` `C_PRODUCTSUPPLYPLANNING.AVAILABILITYCHECKTYPE == TMVF.MTVFP`
Unit of Measure Client Base Unit of Measure	`C_PRODUCTSUPPLYPLANNING.MANDT == T006.MANDT` `C_PRODUCTSUPPLYPLANNING.BASEUNIT == T006.MSEHI`
Currency Key Client Currency Key	`C_PRODUCTSUPPLYPLANNING.MANDT == TCURC.MANDT` `C_PRODUCTSUPPLYPLANNING.CURRENCY == TCURC.WAERS`
Default storage location for external procurement Plant Plant Default storage location for external procurement Client	`C_PRODUCTSUPPLYPLANNING.PLANTFOREDIT == T001L.WERKS` `C_PRODUCTSUPPLYPLANNING.PLANT == T001L.WERKS` `C_PRODUCTSUPPLYPLANNING.DFLTSTORAGELOCATIONEXTPROCMT == T001L.LGORT` `C_PRODUCTSUPPLYPLANNING.MANDT == T001L.MANDT`
Storage costs percentage Plant Plant Client Storage Costs Percentage Code	`C_PRODUCTSUPPLYPLANNING.PLANTFOREDIT == T439L.WERKS` `C_PRODUCTSUPPLYPLANNING.PLANT == T439L.WERKS` `C_PRODUCTSUPPLYPLANNING.MANDT == T439L.MANDT` `C_PRODUCTSUPPLYPLANNING.ISSTORAGECOSTS == T439L.LAGPR`
Lot size Lot Sizing Procedure within Materials Planning Client	`C_PRODUCTSUPPLYPLANNING.LOTSIZINGPROCEDURE == T439A.DISLS` `C_PRODUCTSUPPLYPLANNING.MANDT == T439A.MANDT`
Material Requirements Planning (MRP) Group MRP Group Plant Plant Client	`C_PRODUCTSUPPLYPLANNING.MRPGROUP == T438M.MTART` `C_PRODUCTSUPPLYPLANNING.PLANTFOREDIT == T438M.WERKS` `C_PRODUCTSUPPLYPLANNING.PLANT == T438M.WERKS` `C_PRODUCTSUPPLYPLANNING.MANDT == T438M.MANDT`
Key for time-phased materials planning PPC Planning Calendar Plant Plant Client	`C_PRODUCTSUPPLYPLANNING.MRPPLANNINGCALENDAR == T439G.MRPPP` `C_PRODUCTSUPPLYPLANNING.PLANTFOREDIT == T439G.WERKS` `C_PRODUCTSUPPLYPLANNING.PLANT == T439G.WERKS` `C_PRODUCTSUPPLYPLANNING.MANDT == T439G.MANDT`
MRP controller Plant Plant Client MRP Controller	`C_PRODUCTSUPPLYPLANNING.PLANTFOREDIT == T024D.WERKS` `C_PRODUCTSUPPLYPLANNING.PLANT == T024D.WERKS` `C_PRODUCTSUPPLYPLANNING.MANDT == T024D.MANDT` `C_PRODUCTSUPPLYPLANNING.MRPRESPONSIBLE == T024D.DISPO`
MRP type Client MRP Type	`C_PRODUCTSUPPLYPLANNING.MANDT == T438A.MANDT` `C_PRODUCTSUPPLYPLANNING.MRPTYPE == T438A.DISMM`
Period Profile for Safety Time Plant Plant Client Period Profile for Safety Time	`C_PRODUCTSUPPLYPLANNING.PLANTFOREDIT == T438V.WERKS` `C_PRODUCTSUPPLYPLANNING.PLANT == T438V.WERKS` `C_PRODUCTSUPPLYPLANNING.MANDT == T438V.MANDT` `C_PRODUCTSUPPLYPLANNING.PERDPRFLFORSFTYTME == T438V.SHPRO`
Planning Cycle Planning Cycle Client ?	`C_PRODUCTSUPPLYPLANNING.PLANANDORDERDAYDETERMINATION == T439G.MRPPP` `C_PRODUCTSUPPLYPLANNING.MANDT == T439G.MANDT` `C_PRODUCTSUPPLYPLANNING.[column in domain "WERKS_D"] == T439G.WERKS`
Action Control: Planned Order Processing ? ? Client Action Control: Planned Order Processing	`C_PRODUCTSUPPLYPLANNING.[column in domain "MDACN"] == T46AC.ACCTO` `C_PRODUCTSUPPLYPLANNING.[column in domain "MDACC"] == T46AC.ACCFM` `C_PRODUCTSUPPLYPLANNING.MANDT == T46AC.MANDT` `C_PRODUCTSUPPLYPLANNING.PLANNEDORDERACTIONCONTROL == T46AC.MDACH`
Planning Strategy Group Client Planning Strategy Group	`C_PRODUCTSUPPLYPLANNING.MANDT == T461P.MANDT` `C_PRODUCTSUPPLYPLANNING.PLANNINGSTRATEGYGROUP == T461P.STRGR`
Plant Plant Plant Client	`C_PRODUCTSUPPLYPLANNING.PLANTFOREDIT == T001W.WERKS` `C_PRODUCTSUPPLYPLANNING.PLANT == T001W.WERKS` `C_PRODUCTSUPPLYPLANNING.MANDT == T001W.MANDT`
Plant Plant Plant Client	`C_PRODUCTSUPPLYPLANNING.PLANTFOREDIT == T001W.WERKS` `C_PRODUCTSUPPLYPLANNING.PLANT == T001W.WERKS` `C_PRODUCTSUPPLYPLANNING.MANDT == T001W.MANDT`
Special procurement key Plant Plant Client Special procurement type	`C_PRODUCTSUPPLYPLANNING.PLANTFOREDIT == T460A.WERKS` `C_PRODUCTSUPPLYPLANNING.PLANT == T460A.WERKS` `C_PRODUCTSUPPLYPLANNING.MANDT == T460A.MANDT` `C_PRODUCTSUPPLYPLANNING.PROCUREMENTSUBTYPE == T460A.SOBSL`
Product Number Client Product Number	`C_PRODUCTSUPPLYPLANNING.MANDT == MARA.MANDT` `C_PRODUCTSUPPLYPLANNING.PRODUCT == MARA.MATNR`
Production Storage Location Plant Plant Client Issue Storage Location	`C_PRODUCTSUPPLYPLANNING.PLANTFOREDIT == T001L.WERKS` `C_PRODUCTSUPPLYPLANNING.PLANT == T001L.WERKS` `C_PRODUCTSUPPLYPLANNING.MANDT == T001L.MANDT` `C_PRODUCTSUPPLYPLANNING.PRODUCTIONINVTRYMANAGEDLOC == T001L.LGORT`
Plant range of coverage profile Plant Plant Client Range of coverage profile	`C_PRODUCTSUPPLYPLANNING.PLANTFOREDIT == T438R.WERKS` `C_PRODUCTSUPPLYPLANNING.PLANT == T438R.WERKS` `C_PRODUCTSUPPLYPLANNING.MANDT == T438R.MANDT` `C_PRODUCTSUPPLYPLANNING.RANGEOFCVRGPRFLCODE == T438R.RWPRO`
Repetitive Manufacturing Profile Client Repetitive Manufacturing Profile	`C_PRODUCTSUPPLYPLANNING.MANDT == T437S.MANDT` `C_PRODUCTSUPPLYPLANNING.REPETITIVEMANUFACTURINGPROFILE == T437S.SFPRO`