ARUN_I_PR

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_PR.
-- 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_PR

CREATE VIEW ARUN_I_PR AS
SELECT
  p.banfn AS purchreq_num,
  '0001' AS purchreq_sch,
  p.matnr AS material,
  p.werks AS plant,
  total_stock,
  p.lfdat AS delv_date,
  'A' AS stock_source,
  p.sgt_scat AS stocksegment,
  '' AS SeasonYear,
  '' AS Season,
  '' AS sCollection,
  '' AS theme,
  fsh_mg_at1,
  fsh_mg_at2,
  fsh_mg_at3,
  color,
  size1,
  size2,
  color_atinn,
  size1_atinn,
  size2_atinn,
  'Purchase Requisition' AS stknam,
  p.company_code AS company_code,
  p.satnr AS satnr,
  bdbs_prv.alloc_qty AS alloc_qty,
  attyp,
  p.lifnr AS supplier,
  p.bsart AS pr_doc_typ,
  p.matkl AS matkl,
  p.webaz AS webaz
FROM ARUNI_EBAN_SEL AS p
LEFT OUTER JOIN Arun_Purchreq_Bdbs AS bdbs_prv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ARUN_I_STAT_PR AS bdbs_prv_info ON /* join condition not captured in parsed metadata */
;