I_PMRPSimlnOutpQtyByTopLvlDmnd

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_PMRPSimlnOutpQtyByTopLvlDmnd.
-- 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: IPMRPOUTPTLD

CREATE VIEW I_PMRPSimlnOutpQtyByTopLvlDmnd AS
SELECT
  PMRPSimulation,
  TopLevelDemandInternalID,
  Product,
  Plant,
  MRPArea,
  PMRPSourceOfSupplyInternalID,
  PMRPSupplyGroup,
  PMRPSupplyGroupCategory,
  BucketInternalID,
  UnitOfMeasure,
  round(PMRPReceiptBucketQuantity,_TopLevelDemand._UnitOfMeasure.UnitOfMeasureNumberOfDecimals ) AS PMRPReceiptBucketQuantity,
  PMRPReferencePlan,
  _TopLevelDemand.TopLevelProduct AS TopLevelProduct,
  _TopLevelDemand.TopLevelPlant AS TopLevelPlant,
  _TopLevelDemand.TopLevelMRPArea AS TopLevelMRPArea
FROM P_PMRPSimlnOutpQtyByTopLvlDmn1
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON _Product.Product = Product  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant  -- association [1..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON _MRPArea.MRPArea = MRPArea  -- association [1..1]
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_PMRPProduct AS _PMRPProduct ON _PMRPProduct.PMRPReferencePlan = PMRPReferencePlan AND _PMRPProduct.Product = Product AND _PMRPProduct.MRPArea = MRPArea AND _PMRPProduct.Plant = Plant  -- association [1..1]
LEFT OUTER JOIN I_PMRPSourceOfSupply AS _SourceOfSupply ON _SourceOfSupply.PMRPReferencePlan = PMRPReferencePlan AND _SourceOfSupply.PMRPSourceOfSupplyInternalID = PMRPSourceOfSupplyInternalID  -- 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_PMRPSimlnTopLevelDemand AS _TopLevelDemand ON _TopLevelDemand.PMRPSimulation = PMRPSimulation AND _TopLevelDemand.TopLevelDemandInternalID = TopLevelDemandInternalID  -- association [1..1]
;