C_Productstoresupplyplanning

Consumption Store Supply Plan | view: CPRDSTRSUPPLANG | Extraction: Not supported | Component: Material Master

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

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities (8)
📅 Dates
☰ Categorical (3)
Other (10)
🔗 Relations (23)

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

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
GoodIssueProcessingDays	Goods Issue Processing Time in Days	DEC3
GoodsReceiptDuration	Goods receipt processing time in days	DEC3
RqmtQtyRcptTaktTmeInWrkgDays	Takt time	DEC3
SrvcLvl	Service level	DEC2_1
InHouseProductionTime	In-house production time	DEC3

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

Other Relations \| to Master Data Relations ↑	Join Conditions
Units of measure group Client Unit of Measure Group ?	`C_PRODUCTSTORESUPPLYPLANNING.MANDT == TWMEG.MANDT` `C_PRODUCTSTORESUPPLYPLANNING.PRODUCTUNITGROUP == TWMEG.MEGRU` `C_PRODUCTSTORESUPPLYPLANNING.[column in domain "LRMEI"] == TWMEG.MEINS`