P_ProductSupplyPlanningWD

Union | view: PPRDSUPPLYPLANWD | Extraction: Not supported | Component: Material Master
Tables used: SDRAFT_ADMIN, MARA, USR21, T001, T001K, T001W, PRD_ROOT, MARC, PRD_PLANT, PRD_SUPPLY
Column Name Description
Draftkey UUID in X form (binary)
ActiveProduct FK Product Number
ActivePlant FK Plant
Column Name Description
Column Name Description
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
IsActiveEntity Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
HasActiveEntity Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
HasDraftEntity Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description Domain name
ParentDraftKey UUID in X form (binary) SYSUUID
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
RootDraftKey UUID in X form (binary) SYSUUID
DraftAdministrativeDataUUID UUID in X form (binary) SYSUUID
Master Data Relations Join Conditions
Value Table for ABC Indicator
  • ABC Indicator
  • Client
  • P_PRODUCTSUPPLYPLANNINGWD.ABCINDICATOR == TMABC.MAABC
  • P_PRODUCTSUPPLYPLANNINGWD.MANDT == TMABC.MANDT
Plant
  • Client
  • Plant
  • Plant
  • P_PRODUCTSUPPLYPLANNINGWD.MANDT == T001W.MANDT
  • P_PRODUCTSUPPLYPLANNINGWD.PLANT == T001W.WERKS
  • P_PRODUCTSUPPLYPLANNINGWD.ACTIVEPLANT == T001W.WERKS
Product Number
  • Client
  • Product Number
  • Product Number
  • P_PRODUCTSUPPLYPLANNINGWD.MANDT == MARA.MANDT
  • P_PRODUCTSUPPLYPLANNINGWD.ACTIVEPRODUCT == MARA.MATNR
  • P_PRODUCTSUPPLYPLANNINGWD.PRODUCT == MARA.MATNR
Default storage location for external procurement
  • Client
  • Plant
  • Plant
  • Default storage location for external procurement
  • P_PRODUCTSUPPLYPLANNINGWD.MANDT == T001L.MANDT
  • P_PRODUCTSUPPLYPLANNINGWD.PLANT == T001L.WERKS
  • P_PRODUCTSUPPLYPLANNINGWD.ACTIVEPLANT == T001L.WERKS
  • P_PRODUCTSUPPLYPLANNINGWD.DFLTSTORAGELOCATIONEXTPROCMT == T001L.LGORT
Lot size
  • Client
  • Lot Sizing Procedure within Materials Planning
  • P_PRODUCTSUPPLYPLANNINGWD.MANDT == T439A.MANDT
  • P_PRODUCTSUPPLYPLANNINGWD.LOTSIZINGPROCEDURE == T439A.DISLS
MRP controller
  • MRP Controller
  • Client
  • Plant
  • Plant
  • P_PRODUCTSUPPLYPLANNINGWD.MRPRESPONSIBLE == T024D.DISPO
  • P_PRODUCTSUPPLYPLANNINGWD.MANDT == T024D.MANDT
  • P_PRODUCTSUPPLYPLANNINGWD.PLANT == T024D.WERKS
  • P_PRODUCTSUPPLYPLANNINGWD.ACTIVEPLANT == T024D.WERKS
MRP type
  • MRP Type
  • Client
  • P_PRODUCTSUPPLYPLANNINGWD.MRPTYPE == T438A.DISMM
  • P_PRODUCTSUPPLYPLANNINGWD.MANDT == T438A.MANDT
Planning Cycle
  • Planning Cycle
  • Client
  • ?
  • P_PRODUCTSUPPLYPLANNINGWD.PLANANDORDERDAYDETERMINATION == T439G.MRPPP
  • P_PRODUCTSUPPLYPLANNINGWD.MANDT == T439G.MANDT
  • P_PRODUCTSUPPLYPLANNINGWD.[column in domain "WERKS_D"] == T439G.WERKS
Planning Strategy Group
  • Client
  • Planning Strategy Group
  • P_PRODUCTSUPPLYPLANNINGWD.MANDT == T461P.MANDT
  • P_PRODUCTSUPPLYPLANNINGWD.PLANNINGSTRATEGYGROUP == T461P.STRGR
Plant
  • Client
  • Plant
  • Plant
  • P_PRODUCTSUPPLYPLANNINGWD.MANDT == T001W.MANDT
  • P_PRODUCTSUPPLYPLANNINGWD.PLANT == T001W.WERKS
  • P_PRODUCTSUPPLYPLANNINGWD.ACTIVEPLANT == T001W.WERKS
Special procurement key
  • Client
  • Special procurement type
  • Plant
  • Plant
  • P_PRODUCTSUPPLYPLANNINGWD.MANDT == T460A.MANDT
  • P_PRODUCTSUPPLYPLANNINGWD.PROCUREMENTSUBTYPE == T460A.SOBSL
  • P_PRODUCTSUPPLYPLANNINGWD.PLANT == T460A.WERKS
  • P_PRODUCTSUPPLYPLANNINGWD.ACTIVEPLANT == T460A.WERKS
Product Number
  • Client
  • Product Number
  • Product Number
  • P_PRODUCTSUPPLYPLANNINGWD.MANDT == MARA.MANDT
  • P_PRODUCTSUPPLYPLANNINGWD.ACTIVEPRODUCT == MARA.MATNR
  • P_PRODUCTSUPPLYPLANNINGWD.PRODUCT == MARA.MATNR
Rounding Profile
  • ?
  • ?
  • Rounding Profile
  • Client
  • P_PRODUCTSUPPLYPLANNINGWD.[column in domain "RDZAE"] == RDPR.RDZAE
  • P_PRODUCTSUPPLYPLANNINGWD.[column in domain "WERKS_D"] == RDPR.WERKS
  • P_PRODUCTSUPPLYPLANNINGWD.ROUNDINGPROFILE == RDPR.RDPRF
  • P_PRODUCTSUPPLYPLANNINGWD.MANDT == RDPR.MANDT