I_MatlStkDetCsgnmtQuantity

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_MatlStkDetCsgnmtQuantity.
-- 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 I_MatlStkDetCsgnmtQuantity AS
SELECT
  MaterialStockReportUUID,
  Product,
  StorageLocation,
  MaterialBaseUnit,
  sum( MatlStkIncrQtyInMatlBaseUnit ) AS MatlStkIncrQtyInMatlBaseUnit,
  sum( MatlStkDecrQtyInMatlBaseUnit ) AS MatlStkDecrQtyInMatlBaseUnit,
  _Quantity.MatlWrhsStkQtyInMatlBaseUnit AS MatlWrhsStkQtyInMatlBaseUnit
FROM R_MatlStkDetCsgnmtDocItem
INNER JOIN I_MatlStockWithNoDocumentItem AS no_matdoc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MatlStockReportConsignment AS _Report ON MaterialStockReportUUID = _Report.MaterialStockReportUUID  -- association [1..1]
LEFT OUTER JOIN I_MatlStockReportQuantitySet AS _Quantity ON MaterialStockReportUUID = _Quantity.MaterialStockReportUUID AND MaterialBaseUnit = _Quantity.MaterialBaseUnit AND Product = _Quantity.Material AND StorageLocation = _Quantity.StorageLocation  -- association [0..1]
-- UNION ALL with additional select branch(es): I_MatlStockReportQuantitySet
;