ARUN_I_SO_REQMT_PREV

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_SO_REQMT_PREV.
-- 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_SO_REQ_P
-- Parameters: p_langu : abap.lang

CREATE VIEW ARUN_I_SO_REQMT_PREV AS
SELECT
  h.vbeln AS vbeln,
  i.posnr AS posnr,
  h.vbeln AS aufnr,
  h.erdat AS erdat,
  h.audat AS audat,
  h.vbtyp AS vbtyp,
  h.augru AS augru,
  h.auart AS auart,
  h.vkorg AS vkorg,
  h.vtweg AS vtweg,
  h.vdatu AS vdatu,
  h.bstdk AS bstdk,
  cast('00000000' as eindt) AS eindt,
  h.bstnk AS bstnk,
  h.fsh_rereg AS fsh_rereg,
  h.cmgst AS cmgst,
  h.kunnr AS kunnr,
  h.fsh_cq_check AS fsh_cq_check,
  h.vkgrp AS vkgrp,
  h.vkbur AS vkbur,
  h.ernam AS ernam,
  h.lifsk AS lifsk,
  h.lfstk AS lfstk,
  i.grkor AS grkor,
  i.matnr AS material,
  i.matkl AS matkl,
  i.mvgr1 AS mvgr1,
  i.werks AS plant,
  i.fsh_candate AS fsh_candate,
  h.fsh_candate AS hfsh_candate,
  i.sgt_rcat AS req_segment,
  case when h.vbtyp = 'I' then 'VI' when h.vbtyp = 'G' then 'VG' else 'VC' end as req_ind AS vbtypGthenVGelseVCendasreq_ind,
  i.fsh_season AS fsh_season,
  i.fsh_theme AS fsh_theme,
  i.lprio AS lprio,
  i.sobkz AS sobkz,
  i.kowrr AS kowrr,
  i.sposn AS sposn,
  i.bedae AS bedae,
  i.pstyv AS pstyv,
  i.fsh_vas_rel AS fsh_vas_rel,
  i.fsh_item AS fsh_item,
  i.lfsta AS lfsta,
  i.vstel AS vstel,
  i.attyp AS attyp,
  i.maktg AS maktg,
  i.netpr AS netpr,
  i.netwr AS netwr,
  i.waerk AS waerk,
  i.mtvfp AS mtvfp,
  i.berid AS berid,
  i.route AS route,
  i.dismm AS dismm,
  i.stlnr AS stlnr,
  i.stdat AS stdat,
  i.fixmg AS fixmg,
  sl.lmeng AS req_conf_qty,
  case when h.vbtyp = 'I' then 'VI' when h.vbtyp = 'G' then 'VG' else 'VC' end as bdart AS vbtypGthenVGelseVCendasbdart,
  sl.req_dlvdate AS req_dlvdate,
  sl.edatu AS cnf_dlvdate,
  i.satnr AS satnr,
  i.xchpf AS xchpf,
  i.sgt_stk_prt AS sgt_stk_prt,
  c.kdgrp AS kdgrp,
  c.fsh_grreg AS fsh_grreg,
  i.sgt_covs AS sgt_covs,
  i.spart AS spart,
  h.spart AS hspart,
  i.color_atinn AS color_atinn,
  i.size1_atinn AS size1_atinn,
  i.size2_atinn AS size2_atinn,
  i.color AS color,
  i.size1 AS size1,
  i.size2 AS size2,
  i.uepos AS uepos,
  c.kvgr1 AS kvgr1,
  c.kvgr2 AS kvgr2,
  c.kvgr3 AS kvgr3,
  c.kvgr4 AS kvgr4,
  c.kvgr5 AS kvgr5,
  i.kwmeng AS kwmeng,
  arunid,
  arun_status,
  purchdoc_num,
  reserv_num,
  reserv_item,
  stock_source,
  purchord_num,
  prodord_num,
  prodord_item,
  purchord_sch,
  prev.alloc_qty AS alloc_qty,
  arun_mode,
  changed_by,
  ilfgsa,
  iuvall,
  iuvvlk,
  iuvfak,
  h.lfgsk AS lfgsk,
  h.abstk AS abstk,
  h.spstg AS spstg,
  h.uvall AS uvall,
  h.uvvlk AS uvvlk,
  h.uvfak AS uvfak,
  h.uvals AS uvals,
  h.uvvls AS uvvls,
  h.uvfas AS uvfas,
  h.faksk AS faksk,
  bukrs_vf AS bukrs,
  vbkd.zterm AS zterm,
  vbkd.inco1 AS inco1,
  vbkd.delco AS delco,
  case when arun_status = 'F' then prev.alloc_qty else 0 end AS pfmenge,
  case when arun_status = 'H' then prev.alloc_qty else 0 end AS phmenge,
  case when arun_status = 'R' then prev.alloc_qty else 0 end AS prmenge,
  case when arun_status = 'O' then prev.alloc_qty else 0 end AS pomenge,
  prev.stk_segment AS stk_segment,
  ekko.lifnr AS lifnr,
  vbkd.bstkd AS bstkd,
  'A' AS prreg,
  case when WE1.kunnr is not null then WE1.kunnr else WE2.kunnr end AS shipto,
  case when AG1.kunnr is not null then AG1.kunnr else AG2.kunnr end AS soldto,
  case when RG1.kunnr is not null then RG1.kunnr else RG2.kunnr end AS payer,
  case when RE1.kunnr is not null then RE1.kunnr else RE2.kunnr end AS billto,
  case when AG1.land1 is not null then AG1.land1 else AG2.land1 end AS land1,
  i.sgt_scope AS sgt_scope,
  i.charg AS batch_req,
  i.lgort AS sloc_req,
  ekes.vbeln AS ibd_num,
  ekes.vbelp AS ibd_itm,
  prev.plnum AS plnum,
  dlvqty_bu AS dmenge,
  i.klmeng AS klmeng
FROM vbak AS h
INNER JOIN tvak AS tv ON /* join condition not captured in parsed metadata */
INNER JOIN kna1 ON /* join condition not captured in parsed metadata */
INNER JOIN Arun_I_So_1 ON /* join condition not captured in parsed metadata */
INNER JOIN ARUN_I_SO_VBEP_FIELD AS sl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN arun_preview AS prev ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbpa AS WE1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbpa AS WE2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbpa AS AG1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbpa AS AG2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbpa AS RG1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbpa AS RG2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbpa AS RE1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbpa AS RE2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN knvv AS c ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbkd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ekko ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN lfa1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ekes ON /* join condition not captured in parsed metadata */
;