C_ChemicalAmountsQuery

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 C_ChemicalAmountsQuery.
-- 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: CCHMAMTSQ
-- Parameters: P_StartDate : vdm_v_start_date, P_EndDate : vdm_v_end_date, P_TargetQuantityUnit : msehi

CREATE VIEW C_ChemicalAmountsQuery AS
SELECT
  ChemicalUUID,
  GHSHazardClassCategory,
  ListedSubstanceUUID,
  Material,
  MaterialBaseUnit,
  Plant,
  StorageLocation,
  EndDate,
  0 + MatlWrhsStkQtyInMatlBaseUnit AS MatlWrhsStkQtyInMatlBaseUnit,
  0 + MatlWrhsStockNetWeightCnvrtd AS AvgStockNetWeight,
  0 + MatlWrhsStockNetWeightCnvrtd AS MaxStockNetWeight,
  0 + MatlWrhsStockNetWeightCnvrtd AS MinStockNetWeight,
  cast( 1 as ehfnd_number_of_chemicals ) AS NumberOfChemicals,
  UnitOfMeasure,
  MaterialWeightTargetUnit
FROM I_ChemicalAmountsCube
LEFT OUTER JOIN C_UoMForRiskInventoryRptg AS _UnitOfMeasure ON UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;