I_PRATstProdnCompare

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_PRATstProdnCompare.
-- 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: IPRATPC

CREATE VIEW I_PRATstProdnCompare AS
SELECT
  baseline.PRATstAllocVersion AS PRATstAllocVersion,
  baseline.WellCompltnVolDoc AS WellCompltnVolDoc,
  baseline.WellCompltnVolDocYr AS WellCompltnVolDocYr,
  baseline.DeliveryNetwork AS DeliveryNetwork,
  baseline.AllocationFrequency AS AllocationFrequency,
  baseline.ProductionDate AS ProductionDate,
  scen.MajorProduct AS MajorProduct,
  baseline.Well AS Well,
  baseline.WellCompletion AS WellCompletion,
  baseline.VolumeType AS VolumeType,
  baseline.InventoryDate AS InventoryDate,
  baseline.OriginatingMeasurementPt AS OriginatingMeasurementPt,
  baseline.BaselineStandardVolume AS BaselineStandardVolume,
  current.StandardVolume AS StandardVolume,
  current.StandardVolUnit AS StandardVolUnit,
  baseline.BaselineEnergy AS BaselineEnergy,
  current.Energy AS Energy,
  current.EnergyUnit AS EnergyUnit,
  case when current.Energy <> 0 then abs((cast(baseline.BaselineEnergy as abap.fltp) - cast(current.Energy as abap.fltp)) / cast(current.Energy as abap.fltp)) * 100.0 when current.Energy = 0 then case when baseline.BaselineEnergy = 0 then 0 else cast(9999999 as abap.dec(13,3)) end end as EnergyDiffPct AS dec133endendasEnergyDiffPct,
  case when current.StandardDensity > 0 then abs((cast(baseline.BaselineStandardDensity as abap.fltp) - cast(current.StandardDensity as abap.fltp)) / cast(current.StandardDensity as abap.fltp)) * 100.0 when current.StandardDensity = 0 then case when baseline.BaselineStandardDensity = 0 then 0 else cast(9999999 as abap.dec(13,3)) end end as StandardDensityDiffPct AS dec133endendasStandardDensityDiffPct,
  case when current.StandardVolume <> 0 then abs((cast(baseline.BaselineStandardVolume as abap.fltp) - cast(current.StandardVolume as abap.fltp)) / cast(current.StandardVolume as abap.fltp)) * 100.0 when current.StandardVolume = 0 then case when baseline.BaselineStandardVolume = 0 then 0 else cast(9999999 as abap.dec(13,3)) end end as StandardVolumeDiffPct AS dec133endendasStandardVolumeDiffPct,
  baseline.BaselineHeatingValue AS BaselineHeatingValue,
  current.HeatingValue AS HeatingValue,
  current.HeatingValUnit AS HeatingValUnit,
  baseline.BaselineMaterial AS BaselineMaterial,
  current.Material AS Material,
  baseline.BaselineStandardDensity AS BaselineStandardDensity,
  current.StandardDensity AS StandardDensity,
  current.StandardDensityUnit AS StandardDensityUnit,
  baseline.BslnNmbrOfDaysProduced AS BslnNmbrOfDaysProduced,
  current.NmbrOfDaysProduced AS NmbrOfDaysProduced,
  tol.StandardVolumeTolPct AS StandardVolumeTolPct,
  tol.EnergyTolVal AS EnergyTolVal,
  tol.StandardDensityTolInPct AS StandardDensityTolInPct,
  current.TicketNumber AS TicketNumber,
  current.Transporter AS Transporter,
  current.EffectiveValidityStartDate AS EffectiveValidityStartDate
FROM I_PRATstProdnScen AS scen
INNER JOIN I_PRAMatlMjrProdMappg AS matnr ON /* join condition not captured in parsed metadata */
INNER JOIN I_PRATstBslnProdnRslts AS baseline ON /* join condition not captured in parsed metadata */
INNER JOIN I_WellCompltnDisposnVol AS current ON /* join condition not captured in parsed metadata */
INNER JOIN I_PRATstProdnTol AS tol ON /* join condition not captured in parsed metadata */
;