Arun_Stock_Sel

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_Sel.
-- 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_STOCK_SEL

CREATE VIEW Arun_Stock_Sel AS
SELECT
  s.Material AS Material,
  s.Plant AS Plant,
  s.CompanyCode AS CompanyCode,
  s.StorageLocation AS StorageLocation,
  s.Batch AS Batch,
  s.Supplier AS Supplier,
  s.ShelfExpDate AS ShelfExpDate,
  s.MfgDate AS MfgDate,
  s.BatchCreationDate AS BatchCreationDate,
  s.LastGRDate AS LastGRDate,
  s.StockSegment AS StockSegment,
  s.SeasonYear AS SeasonYear,
  s.Season AS Season,
  s.SCollection AS SCollection,
  s.Theme AS Theme,
  s.StockQty AS StockQty,
  case when s.Batch = '' then 'S' else 'C' end AS StockSource,
  case when b.AllocQty is not null then case when v.deliveryQuantity is not null then s.StockQty - b.AllocQty - v.deliveryQuantity else s.StockQty - b.AllocQty end else case when v.deliveryQuantity is not null then s.StockQty - v.deliveryQuantity else s.StockQty end end as OpenStockQty AS StockQtyendendasOpenStockQty,
  s.MaterialBaseUnit AS MaterialBaseUnit,
  s.ArunFixBatch AS ArunFixBatch,
  s.SegmentStrategy AS SegmentStrategy
FROM Arun_Stock_Lines AS s
LEFT OUTER JOIN Arun_Stock_Bdbs AS b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Arun_Open_Delivery AS v ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mara AS m ON /* join condition not captured in parsed metadata */
;