I_ProductSupplyPlanning

Product SupPlanning active core entity | view: IPRDSUPPLYPLAN | Extraction: Full or Incremental | Component: Material Master
Tables used: MARA, MARA, T001, T001K, T001W, MARC
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
IsActiveEntity Draft - Indicator - Is active document Show values
IsSafetyTime Safety time indicator (with or without safety time) Show values
IsMRPDependentRqmt MRP relevancy for dependent requirements Show values
MRPAvailabilityType Mixed MRP indicator Show values
ProductIsForCrossProject Indicator for cross-project material 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
ProdRqmtsConsumptionMode Consumption mode Show values
ProductIsToBeDiscontinued Discontinuation indicator Show values
ProdRqmtsAreConsolidated Indicator for Requirements Grouping Show values
MatlCompIsMarkedForBackflush Indicator: Backflush Show values
MRPSafetyStockMethod MRP Safety Stock Method 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
GoodIssueProcessingDays Goods Issue 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
ComponentScrapInPercent Component Scrap in Percent DEC3_2
Master Data Relations | to Other Relations ↓ Join Conditions
Value Table for ABC Indicator
  • ABC Indicator
  • Client
  • I_PRODUCTSUPPLYPLANNING.ABCINDICATOR == TMABC.MAABC
  • I_PRODUCTSUPPLYPLANNING.MANDT == TMABC.MANDT
Checking Group for Availability Check
  • Checking Group for Availability Check
  • Client
  • I_PRODUCTSUPPLYPLANNING.AVAILABILITYCHECKTYPE == TMVF.MTVFP
  • I_PRODUCTSUPPLYPLANNING.MANDT == TMVF.MANDT
Unit of Measure
  • Base Unit of Measure
  • Client
  • I_PRODUCTSUPPLYPLANNING.BASEUNIT == T006.MSEHI
  • I_PRODUCTSUPPLYPLANNING.MANDT == T006.MANDT
Consignment Control
  • Consignment Control
  • Client
Currency Key
  • Client
  • Currency Key
  • I_PRODUCTSUPPLYPLANNING.MANDT == TCURC.MANDT
  • I_PRODUCTSUPPLYPLANNING.CURRENCY == TCURC.WAERS
Default storage location for external procurement
  • Default storage location for external procurement
  • Plant
  • Client
  • I_PRODUCTSUPPLYPLANNING.DFLTSTORAGELOCATIONEXTPROCMT == T001L.LGORT
  • I_PRODUCTSUPPLYPLANNING.PLANT == T001L.WERKS
  • I_PRODUCTSUPPLYPLANNING.MANDT == T001L.MANDT
Follow-Up Material
  • Follow-Up Material
  • Client
  • I_PRODUCTSUPPLYPLANNING.FOLLOWUPPRODUCT == MARA.MATNR
  • I_PRODUCTSUPPLYPLANNING.MANDT == MARA.MANDT
Storage costs percentage
  • Plant
  • Storage Costs Percentage Code
  • Storage Costs Percentage Code
  • Client
  • I_PRODUCTSUPPLYPLANNING.PLANT == T439L.WERKS
  • I_PRODUCTSUPPLYPLANNING.ISSTORAGECOSTS == T439L.LAGPR
  • I_PRODUCTSUPPLYPLANNING.STORAGECOSTSPERCENTAGECODE == T439L.LAGPR
  • I_PRODUCTSUPPLYPLANNING.MANDT == T439L.MANDT
Lot size
  • Lot Sizing Procedure within Materials Planning
  • Client
  • I_PRODUCTSUPPLYPLANNING.LOTSIZINGPROCEDURE == T439A.DISLS
  • I_PRODUCTSUPPLYPLANNING.MANDT == T439A.MANDT
Material Requirements Planning (MRP) Group
  • Plant
  • MRP Group
  • Client
  • I_PRODUCTSUPPLYPLANNING.PLANT == T438M.WERKS
  • I_PRODUCTSUPPLYPLANNING.MRPGROUP == T438M.MTART
  • I_PRODUCTSUPPLYPLANNING.MANDT == T438M.MANDT
Key for time-phased materials planning
  • Plant
  • Client
  • PPC Planning Calendar
  • PPC Planning Calendar
  • I_PRODUCTSUPPLYPLANNING.PLANT == T439G.WERKS
  • I_PRODUCTSUPPLYPLANNING.MANDT == T439G.MANDT
  • I_PRODUCTSUPPLYPLANNING.MRPPLANNINGCALENDAR == T439G.MRPPP
  • I_PRODUCTSUPPLYPLANNING.PRODNPLNGANDCONTROLCALENDAR == T439G.MRPPP
MRP profile
  • Material: MRP profile
  • Client
  • I_PRODUCTSUPPLYPLANNING.MRPPROFILE == MDIP.DISPR
  • I_PRODUCTSUPPLYPLANNING.MANDT == MDIP.MANDT
MRP controller
  • Plant
  • MRP Controller
  • Client
  • I_PRODUCTSUPPLYPLANNING.PLANT == T024D.WERKS
  • I_PRODUCTSUPPLYPLANNING.MRPRESPONSIBLE == T024D.DISPO
  • I_PRODUCTSUPPLYPLANNING.MANDT == T024D.MANDT
MRP type
  • MRP Type
  • Client
  • I_PRODUCTSUPPLYPLANNING.MRPTYPE == T438A.DISMM
  • I_PRODUCTSUPPLYPLANNING.MANDT == T438A.MANDT
Period Profile for Safety Time
  • Plant
  • Client
  • Period Profile for Safety Time
  • I_PRODUCTSUPPLYPLANNING.PLANT == T438V.WERKS
  • I_PRODUCTSUPPLYPLANNING.MANDT == T438V.MANDT
  • I_PRODUCTSUPPLYPLANNING.PERDPRFLFORSFTYTME == T438V.SHPRO
Planning Cycle
  • Planning Cycle
  • ?
  • Client
  • I_PRODUCTSUPPLYPLANNING.PLANANDORDERDAYDETERMINATION == T439G.MRPPP
  • I_PRODUCTSUPPLYPLANNING.[column in domain "WERKS_D"] == T439G.WERKS
  • I_PRODUCTSUPPLYPLANNING.MANDT == T439G.MANDT
Action Control: Planned Order Processing
  • ?
  • ?
  • Action Control: Planned Order Processing
  • Client
  • I_PRODUCTSUPPLYPLANNING.[column in domain "MDACN"] == T46AC.ACCTO
  • I_PRODUCTSUPPLYPLANNING.[column in domain "MDACC"] == T46AC.ACCFM
  • I_PRODUCTSUPPLYPLANNING.PLANNEDORDERACTIONCONTROL == T46AC.MDACH
  • I_PRODUCTSUPPLYPLANNING.MANDT == T46AC.MANDT
Planning Strategy Group
  • Client
  • Planning Strategy Group
  • I_PRODUCTSUPPLYPLANNING.MANDT == T461P.MANDT
  • I_PRODUCTSUPPLYPLANNING.PLANNINGSTRATEGYGROUP == T461P.STRGR
Plant
  • Plant
  • Client
  • I_PRODUCTSUPPLYPLANNING.PLANT == T001W.WERKS
  • I_PRODUCTSUPPLYPLANNING.MANDT == T001W.MANDT
Special procurement key
  • Plant
  • Client
  • Special procurement type
  • I_PRODUCTSUPPLYPLANNING.PLANT == T460A.WERKS
  • I_PRODUCTSUPPLYPLANNING.MANDT == T460A.MANDT
  • I_PRODUCTSUPPLYPLANNING.PROCUREMENTSUBTYPE == T460A.SOBSL
Key for time-phased materials planning
  • Plant
  • Client
  • PPC Planning Calendar
  • PPC Planning Calendar
  • I_PRODUCTSUPPLYPLANNING.PLANT == T439G.WERKS
  • I_PRODUCTSUPPLYPLANNING.MANDT == T439G.MANDT
  • I_PRODUCTSUPPLYPLANNING.MRPPLANNINGCALENDAR == T439G.MRPPP
  • I_PRODUCTSUPPLYPLANNING.PRODNPLNGANDCONTROLCALENDAR == T439G.MRPPP
Product Number
  • Client
  • Product Number
  • I_PRODUCTSUPPLYPLANNING.MANDT == MARA.MANDT
  • I_PRODUCTSUPPLYPLANNING.PRODUCT == MARA.MATNR
Production Storage Location
  • Issue Storage Location
  • Plant
  • Client
  • I_PRODUCTSUPPLYPLANNING.PRODUCTIONINVTRYMANAGEDLOC == T001L.LGORT
  • I_PRODUCTSUPPLYPLANNING.PLANT == T001L.WERKS
  • I_PRODUCTSUPPLYPLANNING.MANDT == T001L.MANDT
Proposed Supply Area in Material Master Record
  • Plant
  • Client
  • Proposed Supply Area in Material Master Record
  • I_PRODUCTSUPPLYPLANNING.PLANT == PVBE.WERKS
  • I_PRODUCTSUPPLYPLANNING.MANDT == PVBE.MANDT
  • I_PRODUCTSUPPLYPLANNING.PROPOSEDPRODUCTSUPPLYAREA == PVBE.PRVBE
Plant range of coverage profile
  • Range of coverage profile
  • Plant
  • Client
  • I_PRODUCTSUPPLYPLANNING.RANGEOFCVRGPRFLCODE == T438R.RWPRO
  • I_PRODUCTSUPPLYPLANNING.PLANT == T438R.WERKS
  • I_PRODUCTSUPPLYPLANNING.MANDT == T438R.MANDT
Repetitive Manufacturing Profile
  • Client
  • Repetitive Manufacturing Profile
  • I_PRODUCTSUPPLYPLANNING.MANDT == T437S.MANDT
  • I_PRODUCTSUPPLYPLANNING.REPETITIVEMANUFACTURINGPROFILE == T437S.SFPRO
Rounding Profile
  • ?
  • ?
  • Rounding Profile
  • Client
  • I_PRODUCTSUPPLYPLANNING.[column in domain "RDZAE"] == RDPR.RDZAE
  • I_PRODUCTSUPPLYPLANNING.[column in domain "WERKS_D"] == RDPR.WERKS
  • I_PRODUCTSUPPLYPLANNING.ROUNDINGPROFILE == RDPR.RDPRF
  • I_PRODUCTSUPPLYPLANNING.MANDT == RDPR.MANDT
Scheduling margin key
  • Scheduling Margin Key for Floats
  • Plant
  • Client
  • I_PRODUCTSUPPLYPLANNING.SCHEDULINGMARGINKEY == T436A.FHORI
  • I_PRODUCTSUPPLYPLANNING.PLANT == T436A.WERKS
  • I_PRODUCTSUPPLYPLANNING.MANDT == T436A.MANDT
Storage costs percentage
  • Plant
  • Storage Costs Percentage Code
  • Storage Costs Percentage Code
  • Client
  • I_PRODUCTSUPPLYPLANNING.PLANT == T439L.WERKS
  • I_PRODUCTSUPPLYPLANNING.ISSTORAGECOSTS == T439L.LAGPR
  • I_PRODUCTSUPPLYPLANNING.STORAGECOSTSPERCENTAGECODE == T439L.LAGPR
  • I_PRODUCTSUPPLYPLANNING.MANDT == T439L.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Splitting indicator
  • ?
  • Plant
  • Splitting Indicator
  • Client
  • I_PRODUCTSUPPLYPLANNING.[column in domain "PERKZ"] == T439P.PERKZ
  • I_PRODUCTSUPPLYPLANNING.PLANT == T439P.WERKS
  • I_PRODUCTSUPPLYPLANNING.FORECASTREQUIREMENTSARESPLIT == T439P.AUFTL
  • I_PRODUCTSUPPLYPLANNING.MANDT == T439P.MANDT
Units of measure group
  • ?
  • Unit of Measure Group
  • Client
  • I_PRODUCTSUPPLYPLANNING.[column in domain "LRMEI"] == TWMEG.MEINS
  • I_PRODUCTSUPPLYPLANNING.PRODUCTUNITGROUP == TWMEG.MEGRU
  • I_PRODUCTSUPPLYPLANNING.MANDT == TWMEG.MANDT