I_PMRPReceiptBasic

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_PMRPReceiptBasic.
-- 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.

CREATE VIEW I_PMRPReceiptBasic AS
SELECT
  simulation_id AS PMRPSimulation,
  tld_id AS TopLevelDemandInternalID,
  Product,
  Plant,
  MRPArea,
  receipt_category AS PMRPReceiptCategory,
  rec_start_date AS ReceiptStartDate,
  rec_end_date AS ReceiptEndDate,
  rec_supply_end_date AS PMRPReceiptSupplyEndDate,
  req_quantity AS RequiredQuantity,
  receipt_quantity AS PMRPReceiptQuantity,
  preprod_quan AS PullInQuantity,
  uom AS UnitOfMeasure,
  sos_id AS PMRPSourceOfSupplyInternalID,
  quot_factor AS QuotaArrangementPercent,
  pegged_rqmt_id AS PeggedRequirementInternalID,
  scale_factor_tld AS PMRPTopLvlDmndQuantityFactor
FROM pmrp_receipt AS receipt
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_PMRPSimlnTopLevelDemand AS _TopLevelDemand ON _TopLevelDemand.PMRPSimulation = PMRPSimulation AND _TopLevelDemand.TopLevelDemandInternalID = TopLevelDemandInternalID  -- association [1..1]
LEFT OUTER JOIN I_PMRPReceipt AS _AlternativePMRPReceipt ON _AlternativePMRPReceipt.PMRPSimulation = PMRPSimulation AND _AlternativePMRPReceipt.TopLevelDemandInternalID = TopLevelDemandInternalID AND _AlternativePMRPReceipt.PeggedRequirementInternalID = PeggedRequirementInternalID AND _AlternativePMRPReceipt.PMRPReceiptSupplyEndDate = PMRPReceiptSupplyEndDate  -- association [1..*]
;