C_ProductPlantMRP

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ProductPlantMRP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CPRODPLNTMRP

CREATE VIEW C_ProductPlantMRP AS
SELECT
  MRPAreaData.Product AS Product,
  MRPAreaData.Plant AS Plant,
  MRPAreaData.MRPArea AS MRPArea,
  MRPAreaData.PlantForEdit AS PlantForEdit,
  MRPAreaData.ProductForEdit AS ProductForEdit,
  MRPAreaData.MRPAreaForEdit AS MRPAreaForEdit,
  MRPAreaData.MRPType AS MRPType,
  MRPAreaData.MRPResponsible AS MRPResponsible,
  MRPAreaData.MRPGroup AS MRPGroup,
  MRPAreaData.ReorderThresholdQuantity AS ReorderThresholdQuantity,
  MRPAreaData.PlanAndOrderDayDetermination AS PlanAndOrderDayDetermination,
  MRPAreaData.PlanningTimeFence AS PlanningTimeFence,
  MRPAreaData.LotSizingProcedure AS LotSizingProcedure,
  MRPAreaData.LotSizeRoundingQuantity AS LotSizeRoundingQuantity,
  MRPAreaData.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  MRPAreaData.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  MRPAreaData.MaximumStockQuantity AS MaximumStockQuantity,
  MRPAreaData.AssemblyScrapPercent AS AssemblyScrapPercent,
  MRPAreaData.ProcurementSubType AS ProcurementSubType,
  MRPAreaData.StorageLocation AS StorageLocation,
  MRPAreaData.DfltStorageLocationExtProcmt AS DfltStorageLocationExtProcmt,
  MRPAreaData.MRPPlanningCalendar AS MRPPlanningCalendar,
  MRPAreaData.SafetyStockQuantity AS SafetyStockQuantity,
  MRPAreaData.RangeOfCvrgPrflCode AS RangeOfCvrgPrflCode,
  MRPAreaData.SafetyDuration AS SafetyDuration,
  MRPAreaData.FixedLotSizeQuantity AS FixedLotSizeQuantity,
  MRPAreaData.LotSizeIndependentCosts AS LotSizeIndependentCosts,
  MRPAreaData.StorageCostsPercentageCode AS StorageCostsPercentageCode,
  MRPAreaData.RqmtQtyRcptTaktTmeInWrkgDays AS RqmtQtyRcptTaktTmeInWrkgDays,
  MRPAreaData.SrvcLvl AS SrvcLvl,
  MRPAreaData.IsMarkedForDeletion AS IsMarkedForDeletion,
  MRPAreaData.PerdPrflForSftyTme AS PerdPrflForSftyTme,
  MRPAreaData.DependentRqmtMRPRelevance AS DependentRqmtMRPRelevance,
  MRPAreaData.MaintenanceStatusName AS MaintenanceStatusName,
  MRPAreaData.ProductSafetyTimeMRPRelevance AS ProductSafetyTimeMRPRelevance,
  MRPAreaData.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  IsPlannedDeliveryTime,
  MRPAreaData.PPPlanningProcedure AS PPPlanningProcedure,
  MRPAreaData.ProdnPlngHeuristic AS ProdnPlngHeuristic,
  MRPAreaData.ProductPlanningGroup AS ProductPlanningGroup,
  MRPAreaData.ProductPlanningPackage AS ProductPlanningPackage,
  MRPAreaData.AdvncdPlngPPDSHorizonInDays AS AdvncdPlngPPDSHorizonInDays,
  MRPAreaData.MaxDaysOfSupplyPenaltyAmount AS MaxDaysOfSupplyPenaltyAmount,
  MRPAreaData.MaxDaysOfSupplyIsActive AS MaxDaysOfSupplyIsActive,
  MRPAreaData.AdvncdPlngSftyStkMeth AS AdvncdPlngSftyStkMeth,
  MRPAreaData.AdvncdPlngTgtStkLvlMeth AS AdvncdPlngTgtStkLvlMeth,
  MRPAreaData.SftyStkMethIsAutomlyDtmnd AS SftyStkMethIsAutomlyDtmnd,
  MRPAreaData.PeriodFactorIsUsed AS PeriodFactorIsUsed,
  MRPAreaData.AdvncdPlngPeriodFactorValue AS AdvncdPlngPeriodFactorValue,
  MRPAreaData.TimeDepdntStkLvlPerdFactorVal AS TimeDepdntStkLvlPerdFactorVal,
  MRPAreaData.LotSizeUnit AS LotSizeUnit,
  MRPAreaData.ReorderDaysSupplyInWorkDays AS ReorderDaysSupplyInWorkDays,
  MRPAreaData.ReorderDaysSupplyInWorkDayCalc AS ReorderDaysSupplyInWorkDayCalc,
  MRPAreaData.TargetDaysSupplyInWorkDays AS TargetDaysSupplyInWorkDays,
  MRPAreaData.TargetDaysSupplyInWorkDaysCalc AS TargetDaysSupplyInWorkDaysCalc,
  MRPAreaData.PlngCalendarPerdcLotSizing AS PlngCalendarPerdcLotSizing,
  MRPAreaData.LocProdGoodsReceiptProcHours AS LocProdGoodsReceiptProcHours,
  MRPAreaData.LocProdGoodsRcptProcHoursCalc AS LocProdGoodsRcptProcHoursCalc,
  MRPAreaData.LocProdGoodsIssueProcHours AS LocProdGoodsIssueProcHours,
  MRPAreaData.LocProdGoodsIssueProcHoursCalc AS LocProdGoodsIssueProcHoursCalc,
  MRPAreaData.GRHandlingCapacityQuantity AS GRHandlingCapacityQuantity,
  MRPAreaData.GRHandlingCapacityUnit AS GRHandlingCapacityUnit,
  MRPAreaData.GIHandlingCapacityQuantity AS GIHandlingCapacityQuantity,
  MRPAreaData.GIHandlingCapacityUnit AS GIHandlingCapacityUnit,
  MRPAreaData.MRPSafetyStockMethod AS MRPSafetyStockMethod,
  MRPAreaData.BaseUnit AS BaseUnit,
  MRPAreaData.Currency AS Currency,
  cast( '' as assemblyscrapunit ) AS AssemblyScrapUnit,
  cast( '' as safetydurationunit ) AS SafetyDurationUnit,
  cast( '' as goodsreceiptdurationunit ) AS GoodsReceiptDurationUnit,
  cast( '' as goodsissueprocgdurationunit ) AS GoodsIssueProcgDurationUnit,
  cast( '' as targetdayssupplydurationunit ) AS TargetDaysSupplyDurationUnit,
  cast( '' as reorderdayssupplydurationunit ) AS ReorderDaysSupplyDurationUnit,
  cast( '' as servicelevelunit ) AS ServiceLevelUnit,
  cast( '' as planneddeliverydurationunit ) AS PlannedDeliveryDurationUnit,
  cast( '' as planningtimefenceunit ) AS PlanningTimeFenceUnit,
  MRPAreaData.SrvcPartsThroughputTimeDurn AS SrvcPartsThroughputTimeDurn,
  MRPAreaData.SrvcPartsThroughputTmeDurnCalc AS SrvcPartsThroughputTmeDurnCalc,
  MRPAreaData.ParLocSafetyStockQuantity AS ParLocSafetyStockQuantity,
  MRPAreaData.VCLSafetyStockQuantity AS VCLSafetyStockQuantity,
  MRPAreaData.VCLParLocSafetyStockQuantity AS VCLParLocSafetyStockQuantity,
  MRPAreaData.VCLReorderPointQuantity AS VCLReorderPointQuantity,
  MRPAreaData.VCLMaximumStockQuantity AS VCLMaximumStockQuantity,
  MRPAreaData.CostFactorForStockHoldingVal AS CostFactorForStockHoldingVal,
  MRPAreaData.ProductProcurementCostsVal AS ProductProcurementCostsVal,
  MRPAreaData.GoodsReceiptHandlingCost AS GoodsReceiptHandlingCost,
  MRPAreaData.GoodsIssueHandlingCost AS GoodsIssueHandlingCost,
  MRPAreaData.ConsumptionOfStorageCapUnit AS ConsumptionOfStorageCapUnit,
  MRPAreaData.ConsumptionOfStorageCapacity AS ConsumptionOfStorageCapacity,
  MRPAreaData.LocProdStorageCostValue AS LocProdStorageCostValue,
  MRPAreaData.SftyStkVioltnPnltyCostValue AS SftyStkVioltnPnltyCostValue,
  cast ('' as msehi ) AS SrvcPartsThroughputTmeDurnUnit,
  cast( '' as msehi ) AS SftyStkVioltnPnltyCostValUnit,
  cast( '' as msehi ) AS LocProdStorageCostValueUnit
FROM I_ProductPlantMRPTP AS MRPAreaData
LEFT OUTER JOIN C_AdvncdPlngProdMRPDmndPnlty AS _DemandPenalty ON Product = _DemandPenalty.Product AND Plant = _DemandPenalty.Plant AND MRPArea = _DemandPenalty.MRPArea  -- association [0..*]
LEFT OUTER JOIN C_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN C_Productplant AS _Plant ON Product = _Plant.Product AND Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN C_ProdSftyTimeIndTextTemp AS _IsSafetyTimeText ON ProductSafetyTimeMRPRelevance = _IsSafetyTimeText.IsSafetyTime  -- association [0..*]
LEFT OUTER JOIN C_ProdMRPDepdntTextTemp AS _IsMRPDependentRqmtText ON DependentRqmtMRPRelevance = _IsMRPDependentRqmtText.IsMRPDependentRqmt  -- association [0..*]
LEFT OUTER JOIN C_ProductMRPAreaVH AS _MRPArea ON MRPAreaForEdit = _MRPArea.MRPArea AND PlantForEdit = _MRPArea.MRPAreaPlant  -- association [0..1]
LEFT OUTER JOIN C_ProdStorageLocationVH AS _StorageLocation ON StorageLocation = _StorageLocation.StorageLocation AND PlantForEdit = _StorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProdStorageLocationVH AS _ProductionInvtryManagedLoc ON DfltStorageLocationExtProcmt = _ProductionInvtryManagedLoc.StorageLocation AND PlantForEdit = _ProductionInvtryManagedLoc.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProdSrvcPartsLocProductMRP AS _ProdSrvcPartsLocProductMRP ON Product = _ProdSrvcPartsLocProductMRP.Product AND Plant = _ProdSrvcPartsLocProductMRP.Plant AND MRPArea = _ProdSrvcPartsLocProductMRP.MRPArea  -- association [1..1]
;