UPOV_GET_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_GET_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_GET_WC

CREATE VIEW UPOV_GET_WC AS
SELECT
  funcloclabel_well.tplnr AS wl_tplnr,
  funcloclabel_wc.tplnr AS wc_tplnr,
  cast(funcloclabel_well.strno as ilom_strno) AS wl_strno,
  cast(ltrim(replace(funcloclabel_wc.strno, concat(left(funcloclabel_well.strno,15),wc_sep.w_wc_separator ),''),'') as ilom_strno) AS wc_strno,
  funcloclabel_wc.strno AS strno
FROM gho_iflot_ext AS functionalloc
LEFT OUTER JOIN upoc_udm_alkey AS alkeyobj_wc ON /* join condition not captured in parsed metadata */
INNER JOIN iflos AS funcloclabel_wc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upoc_udm_alkey AS alkeyobj_well ON /* join condition not captured in parsed metadata */
INNER JOIN iflos AS funcloclabel_well ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upoc_udm_wc_sep AS wc_sep ON /* join condition not captured in parsed metadata */
;