UPOV_PR_WELL_UOM

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 UPOV_PR_WELL_UOM.
-- 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: UPOS_PR_WELL_UOM

CREATE VIEW UPOV_PR_WELL_UOM AS
SELECT
  cast(wlLabel.converted_label as oiu_wl_no) AS WL_NO,
  lpad( functionalloc.api_no,12 ,'0') AS API_NO,
  cast(_functionalloctext.pltxt as oiu_wl_de_conv) AS WL_DE,
  cast(_functionalloctext.pltxu as oiu_shtxt) AS SHTXT,
  cast('' as oiu_dev_cd) AS DEV_CD,
  functionalloc.gho_elev_uom AS GLE_U,
  functionalloc.slot_no AS SLOT_NO,
  abs(cast (geolocation_loa.latitude as oiu_sur_lat_no) ) AS SUR_LAT_NO,
  abs(cast(geolocation_loa.longitude as oiu_sur_lng_no) ) AS SUR_LNG_NO,
  cast(' ' as oiu_leg_de) AS LEG_DE,
  functionalloc.gho_depth_uom AS DO_DPTH_U,
  functionalloc.qtr_1_no AS QTR_1_NO,
  functionalloc.qtr_2_no AS QTR_2_NO,
  functionalloc.section_no AS SECTION_NO,
  functionalloc.twp_no AS TWP_NO,
  functionalloc.twp_dir_cd AS TWP_DIR_CD,
  functionalloc.rng_no AS RNG_NO,
  functionalloc.rng_dir_cd AS RNG_DIR_CD,
  functionalloc.gho_well_tvd_uom AS TARG_DPTH_U,
  cast(functionalloc.gho_well_tvd as abap.quan( 13, 3 )) AS TARG_DPTH,
  functionalloc.mms_owner_cd AS MMS_OWNER_CD,
  cast(' ' as oiu_wl_grp) AS WL_GRP,
  cast(' ' as oiupr_wl_docnr) AS DOCNR,
  cast (' ' as oiu_doc_year) AS DOCYR,
  funcloc.ernam AS OIU_CRUSER,
  dats_tims_to_tstmp(funcloc.erdat, cast('000000' as abap.tims), 'UTC', $session.client, 'NULL') as OIU_TIMESTAMP AS clientNULLasOIU_TIMESTAMP
FROM gho_iflot_ext AS functionalloc
INNER JOIN upot_int_nobj AS wlLabel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN iflot AS funcloc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN iflotx AS _functionalloctext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN iloa AS objloc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN geoloc AS geolocation_loa ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN geoloc AS geolocation ON /* join condition not captured in parsed metadata */
;