UPOV_GLG_WC_VOLUMES

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_GLG_WC_VOLUMES.
-- 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_GLG_WC_VOL

CREATE VIEW UPOV_GLG_WC_VOLUMES AS
SELECT
  WC.RunID AS RunID,
  WC.WellCompletion AS WellCompletion,
  unit_dimension.dimid AS dimension,
  ReceivedWC.unit AS unit,
  ReceiptMeter.volume AS Injected_Volume,
  wcProduced.volume AS Produced_volume,
  ReceivedWC.material AS material,
  ReceivedWC.matnr AS matnr
FROM UPOV_GLG_WC AS WC
INNER JOIN gho_allocres_i AS ReceivedWC ON /* join condition not captured in parsed metadata */
INNER JOIN upoc_udm_vtqt_mp AS vtqt_received ON /* join condition not captured in parsed metadata */
INNER JOIN t006 AS unit_dimension ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gho_allocres_i AS ReceiptMeter ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gho_allocres_i AS wcProduced ON /* join condition not captured in parsed metadata */
;