I_PRATstCombinedAcctCompare

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_PRATstCombinedAcctCompare.
-- 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: IPRATVCOMACTC

CREATE VIEW I_PRATstCombinedAcctCompare 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.Well AS Well,
  current.WellCompletion AS WellCompletion,
  current.PRAContract AS PRAContract,
  current.OriginatingMeasurementPt AS OriginatingMeasurementPt,
  current.Material AS Material,
  current.CombinedHdrSqncNumber AS CombinedHdrSqncNumber,
  current.ProcessingCompanyCode AS ProcessingCompanyCode,
  current.GLAccount AS GLAccount,
  current.AcctDeterminationCategory AS AcctDeterminationCategory,
  current.CostCenter AS CostCenter,
  current.AlternateProperty AS AlternateProperty,
  current.TotalCreditAmount AS TotalCreditAmount,
  baseline.TotalCreditAmount AS BaselineTotalCreditAmount,
  abs(cast(baseline.TotalCreditAmount as abap.dec( 13, 3 )) - cast(current.TotalCreditAmount as abap.dec( 13,3) ) ) AS TotalCreditAmountDiffVal,
  current.TotalDebitAmount AS TotalDebitAmount,
  baseline.TotalDebitAmount AS BaselineTotalDebitAmount,
  abs(cast(baseline.TotalDebitAmount as abap.dec( 13, 3 )) - cast(current.TotalDebitAmount as abap.dec( 13,3) ) ) AS TotalDebitAmountDiffVal,
  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. ActualEnergy AS ActualGrossEnergy,
  baseline. ActualEnergy AS BaselineActualGrossEnergy,
  abs(cast(baseline. ActualEnergy as abap.dec( 13, 3 )) - cast(current. ActualEnergy as abap.dec( 13,3) ) ) AS ActualEnergyDiffVal,
  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.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.CompanyCodeCurrency AS CompanyCodeCurrency,
  current.VolumeUnit AS VolumeUnit,
  current.EnergyUnit AS EnergyUnit,
  tol.SequenceNumber AS SequenceNumber,
  tol.TotalCreditAmountTolVal AS TotalCreditAmountTolVal,
  tol.TotalDebitAmountTolVal AS TotalDebitAmountTolVal,
  tol.GrossVolumeTolVal AS GrossVolumeTolVal,
  tol.GrossEnergyTolVal AS GrossEnergyTolVal,
  tol.GrossVolReducnTolVal AS GrossVolReducnTolVal,
  tol.GrossEngyReducnTolVal AS GrossEngyReducnTolVal
FROM I_PRATstCombinedAcctg AS current
INNER JOIN I_PRATstBslnCombinedAcctg AS baseline ON /* join condition not captured in parsed metadata */
INNER JOIN I_PRATstValnTol AS tol ON /* join condition not captured in parsed metadata */
;