ARUN_PR_ALLOC_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 ARUN_PR_ALLOC_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: ARUN_V_PR_SEL

CREATE VIEW ARUN_PR_ALLOC_SEL AS
SELECT
  purchreq_num,
  purchreq_sch,
  material,
  plant,
  total_stock,
  sopen_pre,
  delv_date,
  stock_source,
  stocksegment,
  SeasonYear,
  Season,
  sCollection,
  theme,
  fsh_mg_at1,
  fsh_mg_at2,
  fsh_mg_at3,
  color,
  size1,
  size2,
  color_atinn,
  size1_atinn,
  size2_atinn,
  stknam,
  company_code,
  sum(pfmenge) AS pfmenge,
  sum(phmenge) AS phmenge,
  sum(prmenge) AS prmenge,
  sum(pomenge) AS pomenge,
  satnr,
  alloc_qty,
  attyp,
  supplier,
  pr_doc_typ,
  matkl,
  webaz
FROM ARUN_I_PR
;