arun_i_plaf

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_i_plaf.
-- 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_PLAF

CREATE VIEW arun_i_plaf AS
SELECT
  p.plnum AS planord_num,
  p.matnr AS material,
  p.plwrk AS plant,
  p.gsmng - p.avmng - p.wemng AS total_stock,
  p.pedtr AS delv_date,
  p.sgt_scat AS stocksegment,
  p.paart AS paart,
  p.flief AS supplier,
  p.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.satnr AS satnr,
  m.attyp AS attyp,
  m.matkl AS matkl
FROM plaf AS p
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 */
;