C_PMRPSupplyChainSimulation

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_PMRPSupplyChainSimulation.
-- 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: CPMRPSC

CREATE VIEW C_PMRPSupplyChainSimulation AS
SELECT
  PMRPSimulation,
  TopLevelDemandInternalID,
  _TopLevelDemand.BucketInternalID AS BucketInternalID,
  _TopLevelDemand.TopLevelProduct AS Product,
  _TopLevelDemand.TopLevelPlant AS Plant,
  UnitOfMeasure,
  _Simulation.PMRPSimulationDescription AS PMRPSimulationDescription,
  _Simulation.PMRPReferencePlan AS PMRPReferencePlan,
  _Simulation.PMRPReferencePlanDescription AS PMRPReferencePlanDescription,
  _Simulation.PMRPSimulationStatusName AS PMRPSimulationStatusName,
  _Simulation.PMRPSimulationStatus AS PMRPSimulationStatus,
  _Simulation.SimulationStatusCriticality AS SimulationStatusCriticality,
  _Simulation.DeliveryPerformanceTrend AS DeliveryPerformanceTrend,
  _Simulation.PreviousNumberOfCapacityIssues AS PreviousNumberOfCapacityIssues,
  _Simulation.CapacityCriticality AS CapacityCriticality,
  _Simulation.CapacityIssueTrend AS CapacityIssueTrend,
  _Simulation.PreviousUndrdelivRatioInPct AS PreviousUndrdelivRatioInPct,
  _Simulation.DeliveryPerformanceCriticality AS DeliveryPerformanceCriticality,
  _Simulation.DeliveryPerformanceUnit AS DeliveryPerformanceUnit,
  _Simulation.PrevNmbrOfProdsWithMissingSOS AS PrevNmbrOfProdsWithMissingSOS,
  _Simulation.InvalidSrceOfSupCriticality AS InvalidSrceOfSupCriticality,
  _Simulation.InvalidSourceOfSupplyTrend AS InvalidSourceOfSupplyTrend,
  _Simulation.PMRPPrevNmbrOfConstraintIssues AS PMRPPrevNmbrOfConstraintIssues,
  _Simulation.ConstraintIssuesCriticality AS ConstraintIssuesCriticality,
  _Simulation.ConstraintIssuesTrend AS ConstraintIssuesTrend,
  _Simulation.PMRPNumberOfBuckets AS PMRPNumberOfBuckets,
  _Simulation.NumberOfCapacityIssues AS NumberOfCapacityIssues,
  _Simulation.TopLvlDmndUndrdelivRatioInPct AS TopLvlDmndUndrdelivRatioInPct,
  _Simulation.NumberOfProductsWithMissingSOS AS NumberOfProductsWithMissingSOS,
  _Simulation.PMRPNumberOfConstraintIssues AS PMRPNumberOfConstraintIssues
FROM I_PMRPSimlnTopLevelDemand AS _TopLevelDemand
LEFT OUTER JOIN C_PMRPSimulation AS _Simulation ON _Simulation.PMRPSimulation = PMRPSimulation  -- association [1..1]
LEFT OUTER JOIN C_PMRPSupplyChainBOM AS _PMRPSupplyChainBOM ON _PMRPSupplyChainBOM.PMRPSimulation = PMRPSimulation AND _PMRPSupplyChainBOM.TopLevelDemandInternalID = TopLevelDemandInternalID  -- association [1..*]
;