I_PMRPSimlnOutpQtyBySupply

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_PMRPSimlnOutpQtyBySupply.
-- 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: IPMRPOUTPSUPP

CREATE VIEW I_PMRPSimlnOutpQtyBySupply AS
SELECT
  PMRPSimulation,
  PMRPSupplyGroup,
  PMRPSupplyGroupCategory,
  Product,
  Plant,
  MRPArea,
  BucketInternalID,
  UnitOfMeasure,
  PMRPFlexibleConstraint,
  PMRPConstraintBaseUnit,
  PMRPConstraintQtyInBaseUnit,
  PMRPConstraintDeltaQuantity,
  PMRPConstraintTolerancePercent,
  PMRPReferencePlan,
  PMRPParentSupplyGroup,
  PMRPParentSupplyGroupCategory,
  ParentProduct,
  ParentPlant,
  ParentMRPArea,
  PMRPSourceOfSupplyInternalID,
  _SourceOfSupply.Supplier AS Supplier,
  _SourceOfSupply.ProductionLine AS ProductionLine,
  _SourceOfSupply.SupplyingPlant AS SupplyingPlant,
  _SourceOfSupply.ReceivingPlant AS ReceivingPlant,
  _SourceOfSupply._SupplyingPlant AS _SupplyingPlant,
  _SourceOfSupply._Supplier AS _Supplier,
  _SourceOfSupply._ProductionLine AS _WorkCenter
FROM P_PMRPSimlnOutpQtyBySupply1
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_PMRPFlexibleConstraint AS _Constraint ON _Constraint.PMRPSimulation = PMRPSimulation AND _Constraint.PMRPFlexibleConstraint = PMRPFlexibleConstraint  -- association [0..1]
LEFT OUTER JOIN I_PMRPSimlnOutpQtyByTopLvlDmnd AS _PMRPSimlnOutpQtyByTopLvlDmnd ON _PMRPSimlnOutpQtyByTopLvlDmnd.PMRPSimulation = PMRPSimulation AND _PMRPSimlnOutpQtyByTopLvlDmnd.Product = Product AND _PMRPSimlnOutpQtyByTopLvlDmnd.MRPArea = MRPArea AND _PMRPSimlnOutpQtyByTopLvlDmnd.Plant = Plant AND _PMRPSimlnOutpQtyByTopLvlDmnd.BucketInternalID = BucketInternalID AND _PMRPSimlnOutpQtyByTopLvlDmnd.PMRPSupplyGroup = PMRPSupplyGroup AND _PMRPSimlnOutpQtyByTopLvlDmnd.PMRPSupplyGroupCategory = PMRPSupplyGroupCategory  -- association [0..*]
LEFT OUTER JOIN I_PMRPSimlnOutpQtyBySupply AS _ParentOutpQtyBySupplyGroup ON _ParentOutpQtyBySupplyGroup.PMRPSimulation = PMRPSimulation AND _ParentOutpQtyBySupplyGroup.Product = ParentProduct AND _ParentOutpQtyBySupplyGroup.Plant = ParentPlant AND _ParentOutpQtyBySupplyGroup.MRPArea = ParentMRPArea AND _ParentOutpQtyBySupplyGroup.PMRPSupplyGroup = PMRPParentSupplyGroup AND _ParentOutpQtyBySupplyGroup.PMRPSupplyGroupCategory = PMRPParentSupplyGroupCategory AND _ParentOutpQtyBySupplyGroup.BucketInternalID = BucketInternalID  -- association [0..1]
;