I_PRATstCombinedMktCompare

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_PRATstCombinedMktCompare.
-- 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: IPRATVCOMMKTC

CREATE VIEW I_PRATstCombinedMktCompare 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.MarketingType AS MarketingType,
  current.ActualInternalMarketingAmt AS ActualInternalMarketingAmt,
  baseline.ActualInternalMarketingAmt AS BslnActlInternalMktgAmt,
  abs(cast(baseline.ActualInternalMarketingAmt as abap.dec( 13, 3 )) - cast(current.ActualInternalMarketingAmt as abap.dec( 13,3) ) ) AS ActlInternalMktgDiffVal,
  current.ActualExternalMarketingAmt AS ActualExternalMarketingAmt,
  baseline.ActualExternalMarketingAmt AS BslnActlExtMktgAmt,
  abs(cast(baseline.ActualExternalMarketingAmt as abap.dec( 13, 3 )) - cast(current.ActualExternalMarketingAmt as abap.dec( 13,3) ) ) AS ActlExternalMktgDiffVal,
  current.EntldInternalMarketingAmt AS EntldInternalMarketingAmt,
  baseline.EntldInternalMarketingAmt AS BslnEntldInternalMktgAmt,
  abs(cast(baseline.EntldInternalMarketingAmt as abap.dec( 13, 3 )) - cast(current.EntldInternalMarketingAmt as abap.dec( 13,3) ) ) AS EntldInternalMktgDiffVal,
  current.EntldExternalMarketingAmt AS EntldExternalMarketingAmt,
  baseline.EntldExternalMarketingAmt AS BslnEntldExternalMktgAmt,
  abs(cast(baseline.EntldExternalMarketingAmt as abap.dec( 13, 3 )) - cast(current.EntldExternalMarketingAmt as abap.dec( 13,3) ) ) AS EntldExtMktgDiffVal,
  current.ActlMktgReimbmtAmt AS ActlMktgReimbmtAmt,
  baseline.ActlMktgReimbmtAmt AS BslnActlMktgReimbmtAmt,
  abs(cast(baseline.ActlMktgReimbmtAmt as abap.dec( 13, 3 )) - cast(current.ActlMktgReimbmtAmt as abap.dec( 13,3) ) ) AS ActlMktgReimbmtDiffVal,
  current.EntldMktgReimbmtAmt AS EntldMktgReimbmtAmt,
  baseline.EntldMktgReimbmtAmt AS BslnEntldMktgReimbmtAmt,
  abs(cast(baseline.EntldMktgReimbmtAmt as abap.dec( 13, 3 )) - cast(current.EntldMktgReimbmtAmt as abap.dec( 13,3) ) ) AS EntldMktgReimbmtDiffVal,
  current.CompanyCodeCurrency AS CompanyCodeCurrency,
  current.VolumeUnit AS VolumeUnit,
  current.EnergyUnit AS EnergyUnit,
  tol.SequenceNumber AS SequenceNumber,
  tol.ActlInternalMktgTolVal AS ActlInternalMktgTolVal,
  tol.ActlExternalMktgTolVal AS ActlExternalMktgTolVal,
  tol.EntldInternalMktgTolVal AS EntldInternalMktgTolVal,
  tol.EntldExtMktgTolVal AS EntldExtMktgTolVal,
  tol.ActlMktgReimbmtTolVal AS ActlMktgReimbmtTolVal,
  tol.EntldMktgReimbmtTolVal AS EntldMktgReimbmtTolVal
FROM I_PRATstCombinedMktg AS current
INNER JOIN I_PRATstBslnCombinedMktg AS baseline ON /* join condition not captured in parsed metadata */
INNER JOIN I_PRATstValnTol AS tol ON /* join condition not captured in parsed metadata */
;