I_PRAWellTestHdr

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_PRAWellTestHdr.
-- 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.

CREATE VIEW I_PRAWellTestHdr AS
SELECT
  wctst_no AS PRAWellTestNumber,
  doc_year AS PRAWellTestDocYear,
  wl_no AS Well,
  wc_no AS WellCompletion,
  test_dt AS PRAWellTestDateTime,
  strm_type_cd AS PRAStreamTypeCode,
  tst_type_cd AS PRATestTypeCode,
  al_fl AS PRAIsAllocated,
  oc_u AS PRAOilCondensateUnit,
  oc AS PRAOilCondensateQuantity,
  water_u AS PRAWaterUnit,
  water AS PRAWaterQuantity,
  dur_hrs AS PRADurationHours,
  dur_min AS PRADurationMinutes,
  heat_val_u AS HeatingValUnit,
  heat_val AS HeatingValue,
  glg_u AS PRAGasLiftGasUnit,
  glg AS PRAGasLiftGasQuantity,
  gas_u AS PRAGasUnit,
  gas AS PRAGasQuantity,
  net_gas_u AS PRANetGasUnit,
  net_gas AS PRANetGasQuantity,
  n2_pc AS PRANitrogenGasPercent,
  co2_pc AS PRACarbon2OxidePct,
  _UnitOfMeasure.UnitOfMeasure AS PRAPercentUnit,
  cho_sz AS PRAChokeSize,
  cho_sz_u AS PRAChokeSizeUnit,
  flo_ps_u AS PRAFlowPressureUnit,
  flo_ps AS PRAFlowPressure,
  tmp_u AS PRATemperatureUnit,
  tmp AS PRAWellTestTemperature,
  base_density_u AS PRADensityAtStdBaseCndnUnit,
  base_density AS PRADensityAtStdBaseCndnQty,
  dentyp AS PRADensityType,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS PRACreationDateTime,
  cast ( 'O3U_WLTS3' as fqm_origin_trans_id ) AS OriginTransaction
FROM oiu_pr_wctst
;