I_PRATstCombinedTaxCompare

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_PRATstCombinedTaxCompare.
-- 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: IPRATVCOMTAXC

CREATE VIEW I_PRATstCombinedTaxCompare 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.Material AS Material,
  current.CombinedHdrSqncNumber AS CombinedHdrSqncNumber,
  current.SeveranceTaxType AS SeveranceTaxType,
  current.ActualStateTaxAmount AS ActualStateTaxAmount,
  baseline.ActualStateTaxAmount AS BaselineActualStateTaxAmt,
  abs(cast(baseline.ActualStateTaxAmount as abap.dec( 13, 3 )) - cast(current.ActualStateTaxAmount as abap.dec( 13,3) ) ) AS ActualStateTaxDiffVal,
  current.EntitledStateTaxAmount AS EntitledStateTaxAmount,
  baseline.EntitledStateTaxAmount AS BaselineEntitledStateTaxAmt,
  abs(cast(baseline.EntitledStateTaxAmount as abap.dec( 13, 3 )) - cast(current.EntitledStateTaxAmount as abap.dec( 13,3) ) ) AS EntitledStateTaxDiffVal,
  current.ActualStateTaxReimbmtAmt AS ActualStateTaxReimbmtAmt,
  baseline.ActualStateTaxReimbmtAmt AS BslnActlTaxReimbmtAmt,
  abs(cast(baseline.ActualStateTaxReimbmtAmt as abap.dec( 13, 3 )) - cast(current.ActualStateTaxReimbmtAmt as abap.dec( 13,3) ) ) AS ActlStateTaxReimbmtDiffVal,
  current.EntitledStateTaxReimbmtAmt AS EntitledStateTaxReimbmtAmt,
  baseline.EntitledStateTaxReimbmtAmt AS BslnEntitledTaxReimbmtAmt,
  abs(cast(baseline.EntitledStateTaxReimbmtAmt as abap.dec( 13, 3 )) - cast(current.EntitledStateTaxReimbmtAmt as abap.dec( 13,3) ) ) AS EntldTaxReimbmtDiffVal,
  current.ActualGrossStateTaxAmt AS ActualGrossStateTaxAmt,
  baseline.ActualGrossStateTaxAmt AS BaselineActlGrssStateTaxAmt,
  abs(cast(baseline.ActualGrossStateTaxAmt as abap.dec( 13, 3 )) - cast(current.ActualGrossStateTaxAmt as abap.dec( 13,3) ) ) AS ActlGrssStateTaxDiffVal,
  current.EntitledGrossStateTaxAmt AS EntitledGrossStateTaxAmt,
  baseline.EntitledGrossStateTaxAmt AS BaselineEntldGrssStateTaxAmt,
  abs(cast(baseline.EntitledGrossStateTaxAmt as abap.dec( 13, 3 )) - cast(current.EntitledGrossStateTaxAmt as abap.dec( 13,3) ) ) AS EntldGrssStateTaxDiffVal,
  current.CompanyCodeCurrency AS CompanyCodeCurrency,
  current.VolumeUnit AS VolumeUnit,
  current.EnergyUnit AS EnergyUnit,
  tol.SequenceNumber AS SequenceNumber,
  tol.ActualStateTaxTolVal AS ActualStateTaxTolVal,
  tol.EntitledStateTaxTolVal AS EntitledStateTaxTolVal,
  tol.ActlStateTaxReimbmtTolVal AS ActlStateTaxReimbmtTolVal,
  tol.EntitledStateTaxReimbmtTolVal AS EntitledStateTaxReimbmtTolVal,
  tol.ActlGrssStateTaxTolVal AS ActlGrssStateTaxTolVal,
  tol.EntldGrssStateTaxTolVal AS EntldGrssStateTaxTolVal
FROM I_PRATstCombinedTax AS current
INNER JOIN I_PRATstBslnCombinedTax AS baseline ON /* join condition not captured in parsed metadata */
INNER JOIN I_PRATstValnTol AS tol ON /* join condition not captured in parsed metadata */
;