I_PRATstCombinedHdrCompare

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_PRATstCombinedHdrCompare.
-- 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: IPRATVCOMHDRC

CREATE VIEW I_PRATstCombinedHdrCompare AS
SELECT
  current.CurrentValnDocument AS CurrentValnDocument,
  current.CurrentValnDocumentYear AS CurrentValnDocumentYear,
  current.DeliveryNetwork AS DeliveryNetwork,
  current.SalesDate AS SalesDate,
  current.PRAJointVenture AS PRAJointVenture,
  current.DivisionOfInterest AS DivisionOfInterest,
  current.PRAContract AS PRAContract,
  current.Well AS Well,
  current.WellCompletion AS WellCompletion,
  current.OriginatingMeasurementPt AS OriginatingMeasurementPt,
  current.PRAProduct AS PRAProduct,
  current.BookingReversalType AS BookingReversalType,
  current.VolumeType AS VolumeType,
  current.CombinedHdrSqncNumber AS CombinedHdrSqncNumber,
  current.Material AS Material,
  baseline.CombinedHdrSqncNumber AS BslnHdrSequenceNumber,
  current.Country AS Country,
  current.PrimaryGeogrlLocation AS PrimaryGeogrlLocation,
  current.Remitter AS Remitter,
  current.RefValnDoc AS RefValnDoc,
  current.RefValnDocYear AS RefValnDocYear,
  current.ActualGrossVolume AS ActualGrossVolume,
  baseline.ActualGrossVolume AS BaselineActualGrossVolume,
  abs(cast(baseline.ActualGrossVolume as abap.dec( 13, 3 )) - cast(current.ActualGrossVolume as abap.dec( 13,3) ) ) AS ActualGrossVolumeDiffVal,
  current.ActualGrossValue AS ActualGrossValue,
  baseline.ActualGrossValue AS BaselineActualGrossValue,
  abs(cast(baseline.ActualGrossValue as abap.dec( 13, 3 )) - cast(current.ActualGrossValue as abap.dec( 13,3) ) ) AS ActualGrossValueDiffVal,
  current.EntldGrossVolume AS EntldGrossVolume,
  baseline.EntldGrossVolume AS BaselineEntldGrossVolume,
  abs(cast(baseline.EntldGrossVolume as abap.dec( 13, 3 )) - cast(current.EntldGrossVolume as abap.dec( 13,3) ) ) AS EntldGrossVolumeDiffVal,
  current.EntldGrossValue AS EntldGrossValue,
  baseline.EntldGrossValue AS BaselineEntldGrossValue,
  abs(cast(baseline.EntldGrossValue as abap.dec( 13, 3 )) - cast(current.EntldGrossValue as abap.dec( 13,3) ) ) AS EntldGrossValueDiffVal,
  current.ActualVolReducn AS ActualVolReducn,
  baseline.ActualVolReducn AS BaselineActualVolReducn,
  abs(cast(baseline.ActualVolReducn as abap.dec( 13, 3 )) - cast(current.ActualVolReducn as abap.dec( 13,3) ) ) AS ActualVolReducnDiffVal,
  current.EntitledVolReducn AS EntitledVolReducn,
  baseline.EntitledVolReducn AS BaselineEntitledVolReducn,
  abs(cast(baseline.EntitledVolReducn as abap.dec( 13, 3 )) - cast(current.EntitledVolReducn as abap.dec( 13,3) ) ) AS EntitledVolReducnDiffVal,
  current.ActualEnergy AS ActualEnergy,
  baseline.ActualEnergy AS BaselineActualEnergy,
  abs(cast(baseline.ActualEnergy as abap.dec( 13, 3 )) - cast(current.ActualEnergy as abap.dec( 13,3) ) ) AS ActualEnergyDiffVal,
  current.EntitledEnergy AS EntitledEnergy,
  baseline.EntitledEnergy AS BaselineEntitledEnergy,
  abs(cast(baseline.EntitledEnergy as abap.dec( 13, 3 )) - cast(current.EntitledEnergy as abap.dec( 13,3) ) ) AS EntitledEnergyDiffVal,
  current.SalesPriceAmount AS SalesPriceAmount,
  baseline.SalesPriceAmount AS BaselineSalesPriceAmount,
  abs(cast(baseline.SalesPriceAmount as abap.dec( 13, 3 )) - cast(current.SalesPriceAmount as abap.dec( 13,3) ) ) AS PRATstSalesPriceDiffVal,
  current.ActualEnergyReducn AS ActualEnergyReducn,
  baseline.ActualEnergyReducn AS BaselineActualEngyReducn,
  abs(cast(baseline.ActualEnergyReducn as abap.dec( 13, 3 )) - cast(current.ActualEnergyReducn as abap.dec( 13,3) ) ) AS ActualEngyReducnDiffVal,
  current.EntitledEngyReducn AS EntitledEngyReducn,
  baseline.EntitledEngyReducn AS BaselineEntldEngyReducn,
  abs(cast(baseline.EntitledEngyReducn as abap.dec( 13, 3 )) - cast(current.EntitledEngyReducn as abap.dec( 13,3) ) ) AS EntldEngyReducnDiffVal,
  current.VolumeUnit AS VolumeUnit,
  current.EnergyUnit AS EnergyUnit,
  current.CompanyCodeCurrency AS CompanyCodeCurrency,
  current.CreatedByUser AS CreatedByUser,
  current.CreationDateTime AS CreationDateTime,
  cast('001' as abap.numc(3)) AS SequenceNumber,
  tol.ActualGrssVolumeTolVal AS ActualGrssVolumeTolVal,
  tol.ActualGrssValueTolVal AS ActualGrssValueTolVal,
  tol.EntldGrossVolumeTolVal AS EntldGrossVolumeTolVal,
  tol.EntldGrossValueTolVal AS EntldGrossValueTolVal,
  tol.ActualVolReducnTolVal AS ActualVolReducnTolVal,
  tol.EntitledVolReducnTolVal AS EntitledVolReducnTolVal,
  tol.EntitledEnergyTolVal AS EntitledEnergyTolVal,
  tol.ActualPriceTolVal AS ActualPriceTolVal,
  tol.ActualEngyReducnTolVal AS ActualEngyReducnTolVal,
  tol.EntldEngyReducnTolVal AS EntldEngyReducnTolVal
FROM I_PRATstCombinedHeader AS current
INNER JOIN I_PRATstBslnCombinedHdr AS baseline ON /* join condition not captured in parsed metadata */
INNER JOIN I_PRATstValnTol AS tol ON /* join condition not captured in parsed metadata */
;