UPO_INT_V_STD_VOL_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 UPO_INT_V_STD_VOL_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.

CREATE VIEW UPO_INT_V_STD_VOL_DIM AS
SELECT
  stdh.bus_key AS BusinessKey,
  case when uomruleitem.dimension = uom.dimid then uomruleitem.uom else stdi.std_uom end as Unit AS std_uomendasUnit,
  stdi.std_val AS StdVolume,
  uomruleitem.dimension AS dimension,
  uomrule.conv_grp AS ConversionGroup
FROM gho_imrg_std_h AS stdh
INNER JOIN mara AS material ON /* join condition not captured in parsed metadata */
INNER JOIN gho_imrg_ext AS imrge ON /* join condition not captured in parsed metadata */
INNER JOIN gho_uom_rule_h AS uomrule ON /* join condition not captured in parsed metadata */
INNER JOIN gho_uom_rule_i AS uomruleitem ON /* join condition not captured in parsed metadata */
INNER JOIN t006 AS uom ON /* join condition not captured in parsed metadata */
INNER JOIN gho_imrg_std_i AS stdi ON /* join condition not captured in parsed metadata */
;