UPOV_PR_WC_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_WC_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_WC_UOM

CREATE VIEW UPOV_PR_WC_UOM AS
SELECT
  cast(WL_Label.converted_label as oiu_wl_no) AS WL_NO,
  cast(WCLabel.converted_label as oiu_wc_no) AS WC_NO,
  functionalloc.api_wc_no AS API_WC_NO,
  cast(_functionalloctext.pltxt as oiu_wc_nm_conv) AS NAME,
  cast(_functionalloctext.pltxu as oiu_shtxt) AS SHTXT,
  cast('NA1' as oiu_me_uomgr) AS UOM_GRP,
  cast(' ' as oiu_dev_pgm_no) AS DEV_PGM_NO,
  abs(cast(geolocation.latitude as oiu_lat_no)) AS LAT_NO,
  abs(cast(geolocation.longitude as oiu_lng_no)) AS LNG_NO,
  case when functionalloc.gho_pck_depth is not initial then functionalloc.gho_pck_dep_uom else functionalloc.gho_perf_uom end as ELEV_DPH_U AS gho_perf_uomendasELEV_DPH_U,
  cast(0 as oiu_plg_dpth) AS PLG_BCK_DPTH,
  cast(0 as oiu_datum_dpth) AS DATUM_DPTH,
  cast(0 as oiu_kb_elev) AS KB_ELEV,
  cast(' ' as oiu_base_bhp_u) AS BASE_BHP_U,
  cast(0 as oiu_base_bhp) AS BASE_BHP,
  addressdata.country AS CNTRY_CD,
  cast(primary_loc.pri_geo_loc as oiu_pri_geo_loc) AS PRI_GEO_LOC,
  functionalloc.sec_geo_loc AS SEC_GEO_LOC,
  cast(reservoir.converted_label as oiu_resrvid) AS RESRV,
  cast(' ' as oiu_resznid) AS RESZN,
  cast(field.converted_label as oiu_fieldid) AS FIELD,
  cast(platform.converted_label as oiu_pf_no) AS PF_NO,
  cast(' ' as oiu_wl_pur_cd) AS PUR_CD,
  cast(' ' as oiu_le_wl_fl) AS LSE_LE_WL_FL,
  cast(functionalloc.gho_perf_from as abap.quan( 17,3)) AS BEG_PRF_DPH,
  cast(functionalloc.gho_perf_to as abap.quan( 17,3)) AS END_PRF_DPH,
  cast(functionalloc.gho_wc_name_alt as oiu_alt_wc_key) AS ALT_WC_KEY,
  functionalloc.lcl_wl_no AS LCL_WL_NO,
  common_pra_param.hier_wc AS WC_SET,
  cast(' ' as oiupr_wc_docnr) AS DOCNR,
  cast(' ' as oiu_doc_year) AS DOCYR,
  functionalloc.or1_or_lvl_1_no AS OR1_OR_LVL_1_NO,
  functionalloc.or2_or_lvl_2_no AS OR2_OR_LVL_2_NO,
  functionalloc.or3_or_lvl_3_no AS OR3_OR_LVL_3_NO,
  functionalloc.or4_or_lvl_4_no AS OR4_OR_LVL_4_NO,
  _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,
  cast(functionalloc.gho_pck_depth as oiu_pack_dpth) AS PCK_DPTH,
  functionalloc.api_sidt AS API_SIDT,
  cast(' ' as /pra/cbm_indicator) as CBM_INDICATOR AS converted_labelasoiu_wl_noasWL_NO,
  cast(' ' as oiu_lat_dir_cd) AS LAT_DIR_CD,
  cast(' ' as oiu_lng_dir_cd) AS LNG_DIR_CD,
  cast(' ' as /pra/cbm_indicator) AS CBM_INDICATOR
FROM gho_iflot_ext AS functionalloc
INNER JOIN upot_int_nobj AS WCLabel ON /* join condition not captured in parsed metadata */
INNER JOIN upot_int_nobj AS WL_Label 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 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrc AS addressdata ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upoc_udm_region AS primary_loc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upot_int_entity AS field ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upot_int_entity AS reservoir ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upot_int_entity AS platform ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN oiu_cm_param AS common_pra_param ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN UPOV_NETOBJ_WITH_PN AS dn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gho_uom_rule_h AS dn_rule ON /* join condition not captured in parsed metadata */
INNER JOIN gho_iflot_ext AS functionalloc ON /* join condition not captured in parsed metadata */
INNER JOIN upot_int_v_get_org_level_data AS org_data ON /* join condition not captured in parsed metadata */
;