ARUNI_STO_STKSEL

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 ARUNI_STO_STKSEL.
-- 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_STO

CREATE VIEW ARUNI_STO_STKSEL AS
SELECT
  p.purchord_num AS purchord_num,
  p.purchord_sch AS purchord_sch,
  p.company_code AS company_code,
  p.material AS material,
  p.plant AS plant,
  p.delv_date AS delv_date,
  p.sgt_scat AS sgt_scat,
  p.PurchDocDate AS PurchDocDate,
  p.PurchDocType AS PurchDocType,
  p.Supplier AS Supplier,
  p.StorageLocation AS StorageLocation,
  p.StockSegment AS StockSegment,
  p.SeasonYear AS SeasonYear,
  p.Season AS Season,
  p.SCollection AS SCollection,
  p.theme AS theme,
  p.webaz AS webaz,
  'B' AS stock_source,
  p.quantity AS StockQty,
  p.color AS color,
  p.size1 AS size1,
  p.size2 AS size2,
  p.color_atinn AS color_atinn,
  p.size1_atinn AS size1_atinn,
  p.size2_atinn AS size2_atinn,
  p.fsh_mg_at1 AS fsh_mg_at1,
  p.fsh_mg_at2 AS fsh_mg_at2,
  p.fsh_mg_at3 AS fsh_mg_at3,
  p.matkl AS matkl,
  p.satnr AS satnr,
  'Purchase Order' AS stknam,
  bdbs.alloc_qty AS alloc_qty,
  p.attyp AS attyp,
  p.reswk AS reswk,
  p.reslo AS reslo
FROM aruni_sto_line AS p
LEFT OUTER JOIN Arun_Purchord_Bdbs ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ARUN_I_STAT_FUTURE ON /* join condition not captured in parsed metadata */
;