ARUN_I_STOCK_LINES

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 ARUN_I_STOCK_LINES.
-- 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: ARUNI_V_STK_LINE

CREATE VIEW ARUN_I_STOCK_LINES AS
SELECT
  ms.Material AS Material,
  ms.Plant AS Plant,
  ms.CompanyCode AS CompanyCode,
  ms.StorageLocation AS StorageLocation,
  ms.Batch AS Batch,
  ms.InventorySpecialStockType AS InventorySpecialStockType,
  ms.Supplier AS Supplier,
  a.vfdat AS ShelfExpDate,
  a.hsdat AS MfgDate,
  a.ersda AS BatchCreationDate,
  a.lwedt AS LastGRDate,
  a.sgt_scat AS StockSegment,
  a.fsh_season_year AS SeasonYear,
  a.fsh_season AS Season,
  a.fsh_collection AS SCollection,
  a.fsh_theme AS Theme,
  sum(ms.MatlWrhsStkQtyInMatlBaseUnit) AS StockQty,
  ms.MaterialBaseUnit AS MaterialBaseUnit,
  mc.arun_fix_batch AS ArunFixBatch
FROM I_MaterialStock AS ms
INNER JOIN marc AS mc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN arun_stock_segmt AS s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mcha AS a ON /* join condition not captured in parsed metadata */
;