A_ProductSupplyPlanning

Supply Planning Data | view: APRODSUPPLYPLNG | TRAN | Extraction: Not supported | Component: Material Master

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

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities (8)
📅 Dates (1)
☰ Categorical (12)
Other (12)
🔗 Relations (25)

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
EffectiveOutDate	Effective-Out Date

Column Name	Description
ProcurementType	Procurement Type	Show values
ProdRqmtsConsumptionMode	Consumption mode	Show values
IsSafetyTime	Safety time indicator (with or without safety time)	Show values
IsMRPDependentRqmt	MRP relevancy for dependent requirements	Show values
ProductIsForCrossProject	Indicator for cross-project material	Show values
MRPAvailabilityType	Mixed MRP indicator	Show values
RepetitiveManufacturingIsAllwd	Repetitive Manufacturing Enabled	Show values
DependentRequirementsType	Dependent requirements ind. for individual and coll. reqmts	Show values
IsBulkMaterialComponent	Indicator: bulk material	Show values
ProductIsToBeDiscontinued	Discontinuation indicator	Show values
ProdRqmtsAreConsolidated	Indicator for Requirements Grouping	Show values
MatlCompIsMarkedForBackflush	Indicator: Backflush	Show values

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

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

Other Relations \| to Master Data Relations ↑	Join Conditions
Splitting indicator Splitting Indicator Client ? Plant	`A_PRODUCTSUPPLYPLANNING.FORECASTREQUIREMENTSARESPLIT == T439P.AUFTL` `A_PRODUCTSUPPLYPLANNING.MANDT == T439P.MANDT` `A_PRODUCTSUPPLYPLANNING.[column in domain "PERKZ"] == T439P.PERKZ` `A_PRODUCTSUPPLYPLANNING.PLANT == T439P.WERKS`