Arun_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_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: ARUN_V_STK_LINES

CREATE VIEW Arun_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.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,
  mc.sgt_covs AS SegmentStrategy
FROM I_MaterialStock AS ms
INNER JOIN nsdm_e_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 */
;