I_ProductUnitsOfMeasureWD

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 I_ProductUnitsOfMeasureWD.
-- 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: IPRDUOMWD

CREATE VIEW I_ProductUnitsOfMeasureWD AS
SELECT
  UnitsOfMeasure.Product AS Product,
  UnitsOfMeasure.AlternativeUnit AS AlternativeUnit,
  UnitsOfMeasure.Product AS ProductForEdit,
  UnitsOfMeasure.AlternativeUnit AS AlternativeUnitForEdit,
  UnitsOfMeasure.QuantityNumerator AS QuantityNumerator,
  UnitsOfMeasure.QuantityDenominator AS QuantityDenominator,
  UnitsOfMeasure.MaterialVolume AS MaterialVolume,
  UnitsOfMeasure.VolumeUnit AS VolumeUnit,
  UnitsOfMeasure.GrossWeight AS GrossWeight,
  UnitsOfMeasure.GlobalTradeItemNumber AS GlobalTradeItemNumber,
  UnitsOfMeasure.GlobalTradeItemNumberCategory AS GlobalTradeItemNumberCategory,
  UnitsOfMeasure.UnitSpecificProductHeight AS UnitSpecificProductHeight,
  UnitsOfMeasure.UnitSpecificProductLength AS UnitSpecificProductLength,
  UnitsOfMeasure.UnitSpecificProductWidth AS UnitSpecificProductWidth,
  UnitsOfMeasure.ProductMeasurementUnit AS ProductMeasurementUnit,
  UnitsOfMeasure.LowerLevelPackagingUnit AS LowerLevelPackagingUnit,
  UnitsOfMeasure.RemainingVolumeAfterNesting AS RemainingVolumeAfterNesting,
  UnitsOfMeasure.MaximumStackingFactor AS MaximumStackingFactor,
  UnitsOfMeasure.CapacityUsage AS CapacityUsage,
  UnitsOfMeasure.WeightUnit AS WeightUnit
FROM I_ProductUnitsOfMeasure AS UnitsOfMeasure
LEFT OUTER JOIN E_Productunitsofmeasure AS _ActiveExtension ON Product = _ActiveExtension.Product AND AlternativeUnit = _ActiveExtension.AlternativeUnit  -- association [0..1]
LEFT OUTER JOIN E_Productunitsofmeasure AS _DraftExtension ON Product = _DraftExtension.Product AND AlternativeUnit = _DraftExtension.AlternativeUnit  -- association [0..1]
LEFT OUTER JOIN I_ProductWD AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Productunitomeasureeanwd AS _InternationalArticleNumber ON Product = _InternationalArticleNumber.Product AND AlternativeUnit = _InternationalArticleNumber.AlternativeUnit  -- association [0..*]
LEFT OUTER JOIN I_Productunitofmeasuretextwd AS _UnitOfMeasureText ON Product = _UnitOfMeasureText.Product AND AlternativeUnit = _UnitOfMeasureText.ProductUnit  -- association [0..*]
LEFT OUTER JOIN I_Productsuppliereanwd AS _SupplierGTIN ON Product = _SupplierGTIN.Product AND AlternativeUnit = _SupplierGTIN.AlternativeUnit  -- association [0..*]
;