I_PRAWell

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_PRAWell.
-- 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_PRAWell AS
SELECT
  wl_no AS Well,
  cast (wl_de as oiu_wl_de preserving type) AS WellName,
  cast (api_no as oiuya_co_wlapi preserving type) AS APIWellNumber,
  shtxt AS PRAWellDescription,
  dev_cd AS PRAWellDrilledFlag,
  gle_u AS PRAGroundLevelElevationUnit,
  gle AS PRAGroundLvlElevationInQty,
  slot_no AS PRASlotNumber,
  cast ( 'DEG' as oiu_uom ) AS LatitudeUnit,
  cast ( 'DEG' as oiu_uom ) AS LongitudeUnit,
  sur_lat_no AS PRAWellLatitudeInQuantity,
  sur_lat_d_cd AS WellLatitudeDirection,
  sur_lng_no AS PRAWellLongitudeInQuantity,
  sur_lng_d_cd AS WellLongitudeDirection,
  leg_de AS PRALegalDescription,
  do_dpth_u AS PRADrillOutDepthUnit,
  do_dpth AS PRADrillOutDepthInQuantity,
  qtr_1_no AS PRAQuarter1Number,
  qtr_2_no AS PRAQuarter2Number,
  section_no AS PRASectionNumber,
  twp_no AS PRATownshipNumber,
  twp_dir_cd AS PRATownshipDirection,
  rng_no AS PRARangeNumber,
  rng_dir_cd AS PRARangeDirection,
  targ_dpth_u AS PRATargetDepthUnit,
  targ_dpth AS PRATargetDepthInQuantity,
  mms_owner_cd AS ONRROwnership,
  wl_grp AS PRAWellNumberRangeGroup,
  docnr AS PRAWellDocumentNumber,
  docyr AS PRAWellDocumentYear,
  cast( oiu_cruser as fclm_bam_created_by ) AS CreatedByUser,
  cast( oiu_timestamp as oiu_vdm_created_on_ts ) AS CreationDateTime
FROM oiu_pr_well
LEFT OUTER JOIN I_UnitOfMeasure AS _DrillOutDepthUnit ON PRADrillOutDepthUnit = _DrillOutDepthUnit.UnitOfMeasure AND _DrillOutDepthUnit.UnitOfMeasureDimension = 'LENGTH'  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TargetDepthUnit ON PRATargetDepthUnit = _TargetDepthUnit.UnitOfMeasure AND _TargetDepthUnit.UnitOfMeasureDimension = 'LENGTH'  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _LatitudeUnit ON LatitudeUnit = _LatitudeUnit.UnitOfMeasure AND _LatitudeUnit.UnitOfMeasureDimension = 'AAAADL'  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _GroundLevelElevationUnit ON PRAGroundLevelElevationUnit = _GroundLevelElevationUnit.UnitOfMeasure AND _GroundLevelElevationUnit.UnitOfMeasureDimension = 'LENGTH'  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _LongitudeUnit ON LongitudeUnit = _LongitudeUnit.UnitOfMeasure AND _LongitudeUnit.UnitOfMeasureDimension = 'AAAADL'  -- association [0..1]
LEFT OUTER JOIN I_PRAWellNumberRangeGroup AS _PRAWellNumberRangeGroup ON PRAWellNumberRangeGroup = _PRAWellNumberRangeGroup.PRAWellNumberRangeGroup  -- association [0..1]
LEFT OUTER JOIN I_PRAWellDeviation AS _PRAWellDeviation ON PRAWellDrilledFlag = _PRAWellDeviation.PRAWellDrilledFlag  -- association [0..1]
LEFT OUTER JOIN I_PRAWellMsmtDocumentItem AS _PRAWellMsmtDocumentItem ON Well = _PRAWellMsmtDocumentItem.Well  -- association [1..*]
;