A_ProductUnitOfMeasure_3

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 A_ProductUnitOfMeasure_3.
-- 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 A_ProductUnitOfMeasure_3 AS
SELECT
  Product,
  cast( AlternativeUnit as cmd_prod_meins preserving type ) AS AlternativeUnit,
  AlternativeSAPUnit,
  cast( _AlternativeUnit.UnitOfMeasureISOCode as meins_iso preserving type ) AS AlternativeISOUnit,
  QuantityNumerator,
  QuantityDenominator,
  ProductVolume,
  VolumeUnit,
  cast( _QuantityUnitValueHelp.UnitOfMeasureISOCode as voleh_iso preserving type ) AS VolumeISOUnit,
  GrossWeight,
  WeightUnit,
  cast( _WeightUnitValueHelp.UnitOfMeasureISOCode as gewei_iso preserving type ) AS WeightISOUnit,
  GlobalTradeItemNumber,
  GlobalTradeItemNumberCategory,
  UnitSpecificProductLength,
  UnitSpecificProductWidth,
  UnitSpecificProductHeight,
  ProductMeasurementUnit,
  cast( _ProductMeasurementUnit.UnitOfMeasureISOCode as meabm_iso preserving type ) AS ProductMeasurementISOUnit,
  cast( LowerLevelPackagingUnit as cmd_prod_meins preserving type ) AS LowerLevelPackagingUnit,
  cast( _LowerLevelPackagingUnit.UnitOfMeasureISOCode as mesub_iso preserving type ) AS LowerLevelPackagingISOUnit,
  MaximumStackingFactor,
  CapacityUsage,
  BaseUnit,
  cast( _Product._BaseUnitOfMeasure.UnitOfMeasureISOCode as meins_iso preserving type ) AS BaseISOUnit
FROM R_ProductUnitOfMeasureTP
;