UPOV_COMMINGLED_WC

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_COMMINGLED_WC.
-- 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_CMNGLD_WC

CREATE VIEW UPOV_COMMINGLED_WC AS
SELECT
  praCommingled.wl_no AS wl_no,
  praCommingled.wc_no AS wc_no,
  praCommingled.majpd_cd AS majpd_cd,
  praCommingled.eff_from_dt AS eff_from_dt,
  praCommingled.eff_to_dt AS converted_labelasoiu_wl_noasWL_NO,
  case when downhole_cm_well_cm.medium = 'OIL' then '1' when downhole_cm_well_cm.medium = 'GAS' then '2' when downhole_cm_well_cm.medium = 'WATER' then '5' else '' end as MAJPD_CD AS mediumWATERthen5elseendasMAJPD_CD,
  tstmp_to_dats(downhole_cm_well_cm.valid_from, 'UTC', $session.client,'NULL') as EFF_FROM_DT AS clientNULLasEFF_FROM_DT,
  tstmp_to_dats(downhole_cm_well_cm.valid_to, 'UTC', $session.client,'NULL') as EFF_TO_DT AS clientNULLasEFF_TO_DT
FROM UPOV_PR_WCDHH_PRA AS praCommingled
INNER JOIN upot_mig_comm_wc AS migCommingled ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN UPOV_MIGRATED_WELL AS migWL ON /* join condition not captured in parsed metadata */
INNER JOIN upot_int_nobj AS wl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upot_mig_comm_wc AS migCommingled ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): gho_com_wc_h
;