UPOV_SUMMARY_AT_WC_VT99_DIM

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_SUMMARY_AT_WC_VT99_DIM.
-- 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_SUMM_VT99D

CREATE VIEW UPOV_SUMMARY_AT_WC_VT99_DIM AS
SELECT
  alloc_res.alloc_run_id AS alloc_run_id,
  alloc_res.dest_node_id AS dest_node_id,
  alloc_res.medium AS medium,
  alloc_res.dimension AS dimension,
  alloc_res.unit AS unit,
  alloc_res.material AS material,
  alloc_res.matnr AS matnr,
  cast('99' as oiu_vt_cd) AS vt_cd
FROM UPOV_ALLOC_RESULTS_DIM AS alloc_res
LEFT OUTER JOIN upoc_udm_vtqt_mp AS vtqt_L1 ON /* join condition not captured in parsed metadata */
;