I_PRATstCombinedHeader

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_PRATstCombinedHeader.
-- 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: IPRATVCOMBINEHDR

CREATE VIEW I_PRATstCombinedHeader AS
SELECT
  header.doc_no AS CurrentValnDocument,
  header.doc_year AS CurrentValnDocumentYear,
  header.dn_no AS DeliveryNetwork,
  header.sale_dt AS SalesDate,
  header.vname AS PRAJointVenture,
  header.doi_no AS DivisionOfInterest,
  header.vbeln AS PRAContract,
  header.wl_no AS Well,
  header.wc_no AS WellCompletion,
  header.mp_no AS OriginatingMeasurementPt,
  header.pd_cd AS PRAProduct,
  header.crh_cr_type_cd AS BookingReversalType,
  header.vl_type_cd AS VolumeType,
  header.header_no AS CombinedHdrSqncNumber,
  header.matnr AS Material,
  header.counc AS Country,
  header.pri_geo_loc AS PrimaryGeogrlLocation,
  header.remt_no AS Remitter,
  header.ref_doc_no AS RefValnDoc,
  header.ref_doc_year AS RefValnDocYear,
  header.actl_gr_vl AS ActualGrossVolume,
  header.vol_uom AS VolumeUnit,
  header.actl_gr_val_am AS ActualGrossValue,
  header.entl_gr_vl AS EntldGrossVolume,
  header.entl_gr_val_am AS EntldGrossValue,
  header.waers AS CompanyCodeCurrency,
  header.actl_wlr_vl_am AS ActualVolReducn,
  header.entl_wlr_vl_am AS EntitledVolReducn,
  header.actl_energy AS ActualEnergy,
  header.energy_uom AS EnergyUnit,
  header.entl_energy AS EntitledEnergy,
  header.actl_avg_price AS SalesPriceAmount,
  header.actl_ptr_vl_am AS ActualEnergyReducn,
  header.entl_ptr_vl_am AS EntitledEngyReducn,
  header.oiu_cruser AS CreatedByUser,
  header.oiu_timestamp AS CreationDateTime,
  cast('001' as abap.numc(3)) AS SequenceNumber
FROM /pra/rd_crh AS header
;