UPOV_PR_WCDT_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_WCDT_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_WCDT_UOM

CREATE VIEW UPOV_PR_WCDT_UOM AS
SELECT
  cast(wlLabel.converted_label as oiu_wl_no) AS WL_NO,
  cast(commingledWC.wc_no as oiu_wc_no) AS WC_NO,
  wc_def_events.STRT_PERIOD AS EFF_FROM_TS,
  cast(' ' as oiu_strm_type_cd) AS STRM_TYPE_CD,
  wc_def_events.END_PERIOD AS EFF_TO_TS,
  wc_def_events.EVENT_ID AS WCDT_NO,
  cast(DwnHrs.ConditionCode as oiu_cond_cd) AS COND_CD,
  cast('' as oiu_hour_fl) AS HOUR_FL,
  cast(DwnHrs.Hrs as oiu_hrs) AS HRS,
  wc_def_events.CREATED_BY AS OIU_CRUSER,
  wc_def_events.CREATED_TST as OIU_TIMESTAMP AS converted_labelasoiu_wl_noasWL_NO,
  wc_def_events.CREATED_TST AS OIU_TIMESTAMP
FROM UPOV_WCDTR_WC_DATA AS wc_def_events
INNER JOIN upot_int_nobj AS wlLabel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN UPOV_WCDWN_HOURS AS DwnHrs ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN UPOV_COMMINGLED_WC AS commingledWC ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upot_int_nobj AS wcLabel ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): UPOV_WCDTR_WC_DATA
;