ARUNI_STO_LINE_STK

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_LINE_STK.
-- 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_STO_STK

CREATE VIEW ARUNI_STO_LINE_STK AS
SELECT
  hdr.ebeln AS purchord_num,
  hdr.bukrs AS company_code,
  sch.etenr AS purchord_sch,
  sch.eindt AS delv_date,
  item.sgt_scat AS sgt_scat,
  item.matnr AS material,
  item.werks AS plant,
  hdr.bsart AS PurchDocType,
  hdr.bedat AS PurchDocDate,
  hdr.lifnr AS Supplier,
  item.lgort AS StorageLocation,
  item.sgt_scat AS StockSegment,
  item.fsh_season_year AS SeasonYear,
  item.fsh_season AS Season,
  item.fsh_collection AS SCollection,
  item.fsh_theme AS theme,
  item.webaz AS webaz,
  m.color AS color,
  m.size1 AS size1,
  m.size2 AS size2,
  m.color_atinn AS color_atinn,
  m.size1_atinn AS size1_atinn,
  m.size2_atinn AS size2_atinn,
  m.fsh_mg_at1 AS fsh_mg_at1,
  m.fsh_mg_at2 AS fsh_mg_at2,
  m.fsh_mg_at3 AS fsh_mg_at3,
  m.matkl AS matkl,
  m.satnr AS satnr,
  m.attyp AS attyp,
  hdr.reswk AS reswk,
  item.reslo AS reslo
FROM ekko AS hdr
INNER JOIN ekpo AS item ON /* join condition not captured in parsed metadata */
INNER JOIN eket AS sch ON /* join condition not captured in parsed metadata */
INNER JOIN mara AS m ON /* join condition not captured in parsed metadata */
INNER JOIN marc AS mc ON /* join condition not captured in parsed metadata */
INNER JOIN lfa1 ON /* join condition not captured in parsed metadata */
INNER JOIN Atpc_Cds_Ekub_2 AS ekub ON /* join condition not captured in parsed metadata */
;