Crms4v_ProductUnit

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 Crms4v_ProductUnit.
-- 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: CRMS4VPRODUNIT
-- Parameters: P_Language : spras

CREATE VIEW Crms4v_ProductUnit AS
SELECT
  I_Product.ProductUUID AS ProductUUID,
  I_ProductUnitsOfMeasure.AlternativeUnit AS AlternativeUnit,
  I_Product.Product AS Product,
  I_ProductUnitsOfMeasure.QuantityNumerator AS QuantityNumerator,
  I_ProductUnitsOfMeasure.QuantityDenominator AS QuantityDenominator,
  cast(0 as comt_exponent10 ) AS Exponent10,
  I_ProductUnitsOfMeasure.GrossWeight AS GrossWeight,
  I_ProductUnitsOfMeasure.WeightUnit AS WeightUnit,
  I_ProductUnitsOfMeasure.MaterialVolume AS MaterialVolume,
  I_ProductUnitsOfMeasure.VolumeUnit AS VolumeUnit,
  I_ProductUnitsOfMeasure.UnitSpecificProductLength AS UnitSpecificProductLength,
  I_ProductUnitsOfMeasure.UnitSpecificProductWidth AS UnitSpecificProductWidth,
  I_ProductUnitsOfMeasure.UnitSpecificProductHeight AS UnitSpecificProductHeight,
  I_ProductUnitsOfMeasure.ProductMeasurementUnit AS ProductMeasurementUnit,
  $parameters.P_Language AS Language
FROM I_Product
INNER JOIN I_ProductUnitsOfMeasure ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitText ON _UnitText.UnitOfMeasure = AlternativeUnit AND _UnitText.Language = $parameters.P_Language  -- association [0..1]
;