I_PRATstEntldPrimProdCompare

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_PRATstEntldPrimProdCompare.
-- 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: IPRATENTWCC

CREATE VIEW I_PRATstEntldPrimProdCompare AS
SELECT
  baseline.DeliveryNetwork AS DeliveryNetwork,
  baseline.Material AS Material,
  baseline.Well AS Well,
  baseline.WellCompletion AS WellCompletion,
  baseline.ProcessingCompanyCode AS ProcessingCompanyCode,
  baseline.PRAJointVenture AS PRAJointVenture,
  baseline.DivisionOfInterest AS DivisionOfInterest,
  baseline.SalesDate AS SalesDate,
  baseline.AllocationFrequency AS AllocationFrequency,
  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,
  baseline.AdjustedEntitledVol AS BaselineAdjustedEntitledVol,
  current.AdjustedEntitledVol AS AdjustedEntitledVol,
  abs(cast(baseline.AdjustedEntitledVol as abap.dec( 13, 3 )) - cast(current.AdjustedEntitledVol as abap.dec( 13,3) ) ) AS AdjustedEntitledVolDiffVal,
  baseline.AdjustedEntitledEngy AS BaselineAdjustedEntitledEngy,
  current.AdjustedEntitledEngy AS AdjustedEntitledEngy,
  abs(cast(baseline.AdjustedEntitledEngy as abap.dec( 13, 3 )) - cast(current.AdjustedEntitledEngy as abap.dec( 13,3) ) ) AS AdjustedEntitledEngyDiffVal,
  cast( '001' as abap.numc(3) ) AS SequenceNumber,
  baseline.BaselineMarketingRep AS BaselineMarketingRep,
  current.MarketingRep AS MarketingRep,
  baseline.BslnMktRepIntrstSequNmbr AS BslnMktRepIntrstSequNmbr,
  current.MarketingRepIntrstSequNmbr AS MarketingRepIntrstSequNmbr,
  tol.EntitledVolumeTolVal AS EntitledVolumeTolVal,
  tol.AdjdEntitledVolTolVal AS AdjdEntitledVolTolVal,
  tol.EntitledEnergyTolVal AS EntitledEnergyTolVal,
  tol.AdjdEntitledEngyTolVal AS AdjdEntitledEngyTolVal
FROM I_PRATstContrAllocScen AS scen
INNER JOIN I_PRAMatlMjrProdMappg AS matnr ON /* join condition not captured in parsed metadata */
INNER JOIN I_PRATstBslnEntldPrimProd AS baseline ON /* join condition not captured in parsed metadata */
INNER JOIN I_PRATstEntldPrimProd AS current ON /* join condition not captured in parsed metadata */
INNER JOIN I_PRATstContrAllocTol AS tol ON /* join condition not captured in parsed metadata */
;