ARUNI_EBAN_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 ARUNI_EBAN_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: ARUNI_V_EBAN_SEL

CREATE VIEW ARUNI_EBAN_SEL AS
SELECT
  pr.banfn AS banfn,
  pr.bnfpo AS bnfpo,
  pr.matnr AS matnr,
  pr.werks AS werks,
  pr.menge - pr.bsmng AS total_stock,
  pr.lfdat AS lfdat,
  pr.meins AS meins,
  pr.sgt_scat AS sgt_scat,
  pr.lgort AS lgort,
  pr.extcompanycodeforpurg AS company_code,
  pr.satnr AS satnr,
  pr.bsart AS bsart,
  pr.lifnr AS lifnr,
  pr.webaz AS webaz,
  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.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.attyp AS attyp,
  m.matkl AS matkl
FROM eban AS pr
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 */
;