I_PRATstEntldSecdryCompare

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_PRATstEntldSecdryCompare.
-- 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: IPRATENSTASPC

CREATE VIEW I_PRATstEntldSecdryCompare AS
SELECT
  baseline.DeliveryNetwork AS DeliveryNetwork,
  baseline.Material AS Material,
  baseline.Well AS Well,
  baseline.WellCompletion AS WellCompletion,
  baseline.SalesDate AS SalesDate,
  baseline.VolumeType AS VolumeType,
  baseline.PRAOwner AS PRAOwner,
  baseline.OwnerInterestType AS OwnerInterestType,
  baseline.OwnerInterestSequence AS OwnerInterestSequence,
  matnr.MajorProduct AS MajorProduct,
  current.VolumeUnit AS VolumeUnit,
  baseline.EntitledVolume AS BaselineEntitledVolume,
  current.EntitledVolume AS EntitledVolume,
  abs(cast(baseline.EntitledVolume as abap.dec( 13, 3 )) - cast(current.EntitledVolume as abap.dec( 13,3) ) ) AS EntitledVolumeDiffVal,
  current.EnergyUnit AS EnergyUnit,
  baseline.EntitledEnergy AS BaselineEntitledEnergy,
  current.EntitledEnergy AS EntitledEnergy,
  abs(cast(baseline.EntitledEnergy as abap.dec( 13, 3 )) - cast(current.EntitledEnergy as abap.dec( 13,3) ) ) AS EntitledEnergyDiffVal,
  cast( '001' as abap.numc(3) ) AS SequenceNumber,
  tol.EntitledVolumeTolVal AS EntitledVolumeTolVal,
  tol.EntitledEnergyTolVal AS EntitledEnergyTolVal
FROM I_PRATstContrAllocScen AS scen
INNER JOIN I_PRAMatlMjrProdMappg AS matnr ON /* join condition not captured in parsed metadata */
INNER JOIN I_PRATstBslnEntldSecdryProd AS baseline ON /* join condition not captured in parsed metadata */
INNER JOIN I_PRATstEntldSecdryProd AS current ON /* join condition not captured in parsed metadata */
INNER JOIN I_PRATstContrAllocTol AS tol ON /* join condition not captured in parsed metadata */
;