I_PRATstBslnProdnRslts

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_PRATstBslnProdnRslts.
-- 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: IPRATBPR

CREATE VIEW I_PRATstBslnProdnRslts AS
SELECT
  pr_version_id AS PRATstAllocVersion,
  wcdvlh_no AS WellCompltnVolDoc,
  doc_year AS WellCompltnVolDocYr,
  wl_no AS Well,
  wc_no AS WellCompletion,
  dn_no AS DeliveryNetwork,
  eff_from_dt AS EffectiveValidityStartDate,
  eff_to_dt AS EffectiveValidityEndDate,
  prd_dt AS ProductionDate,
  prd_matnr AS ReclassifiedMaterial,
  matnr AS BaselineMaterial,
  freq_cd AS AllocationFrequency,
  tkbtry_mp_no AS TankBatteryMeasurementPt,
  vt_cd AS VolumeType,
  vc_cd AS VolumeClass,
  vs_cd AS VolumeSource,
  trnsp_no AS Transporter,
  trnsp_ref_no AS TransporterReference,
  cast( days_prod as oiu_vdm_int_days_of_prod ) AS BslnNmbrOfDaysProduced,
  tkt_no AS TicketNumber,
  tkt_timestamp AS TicketDateTime,
  orig_mp_no AS OriginatingMeasurementPt,
  theo_u AS ThrtclVolUnit,
  theo AS TheoreticalVolume,
  conv_grp AS ConversionGroup,
  std_vol_u AS StandardVolUnit,
  std_vol AS BaselineStandardVolume,
  energy_u AS EnergyUnit,
  energy AS BaselineEnergy,
  heat_val_u AS HeatingValUnit,
  heat_val AS BaselineHeatingValue,
  base_density AS BaselineStandardDensity,
  base_density_u AS StandardDensityUnit,
  dentyp AS DensityType,
  mol_volume AS GasMolarVolume,
  invt_dt AS InventoryDate,
  xref_wl_no AS CrossRefWell,
  xref_wc_no AS CrossRefWellCompletion,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime,
  cast( '001' as abap.numc(3) ) AS SequenceNumber
FROM oiutv_wcdvlh_b
;