I_PMRPSimlnTopLevelDemand

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 I_PMRPSimlnTopLevelDemand.
-- 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: IPMRPSIMTLD

CREATE VIEW I_PMRPSimlnTopLevelDemand AS
SELECT
  pmrp_sim_tld.simulation_id AS PMRPSimulation,
  pmrp_sim_tld.sim_tld_id AS TopLevelDemandInternalID,
  pmrp_sim_tld.bucket_id AS BucketInternalID,
  pmrp_rqmt.Plant AS TopLevelPlant,
  pmrp_rqmt.MRPArea AS TopLevelMRPArea,
  pmrp_rqmt.UnitOfMeasure AS UnitOfMeasure,
  pmrp_rqmt.RequiredQuantity AS SimulatedRequiredQuantity,
  pmrp_rqmt.CoveredByStockQuantity AS CoveredByStockQuantity,
  pmrp_rqmt.PMRPOpenQuantity AS PMRPOpenQuantity,
  pmrp_sim_tld.delivery_perf AS AcceptedRequestedRatioInPct,
  pmrp_rqmt.RequirementStartDate AS RequirementStartDate,
  _Simulation.PMRPReferencePlan AS PMRPReferencePlan
FROM pmrp_sim_tld
INNER JOIN I_PMRPRequirementBasic AS pmrp_rqmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PMRPSimulation AS _Simulation ON _Simulation.PMRPSimulation = PMRPSimulation  -- association [1..1]
LEFT OUTER JOIN I_PMRPReferencePlan AS _ReferencePlan ON _ReferencePlan.PMRPReferencePlan = PMRPReferencePlan  -- association [1..1]
LEFT OUTER JOIN I_PMRPBucket AS _Bucket ON _Bucket.PMRPReferencePlan = PMRPReferencePlan AND _Bucket.BucketInternalID = BucketInternalID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_PMRPProduct AS _PMRPProduct ON _PMRPProduct.PMRPReferencePlan = PMRPReferencePlan AND _PMRPProduct.Product = TopLevelProduct AND _PMRPProduct.MRPArea = TopLevelMRPArea AND _PMRPProduct.Plant = TopLevelPlant  -- association [1..1]
LEFT OUTER JOIN I_PMRPIssueCategory AS _UnderdeliveryIssue ON _UnderdeliveryIssue.PMRPIssueCategory = PMRPUnderdeliveryIssue  -- association [1..1]
LEFT OUTER JOIN I_PMRPReceipt AS _Receipt ON _Receipt.PMRPSimulation = PMRPSimulation AND _Receipt.PeggedRequirementInternalID = TopLevelDemandInternalID  -- association [0..*]
;