ARUN_PROD_REQMT

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_PROD_REQMT.
-- 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: V_ARUN_PRD_REQMT

CREATE VIEW ARUN_PROD_REQMT AS
SELECT
  re.mandt AS mandt,
  re.rsnum AS rsnum,
  re.rspos AS rspos,
  re.aufnr AS aufnr,
  re.matnr AS matnr,
  re.werks AS werks,
  re.meins AS meins,
  re.enmng AS enmng,
  re.webaz AS webaz,
  re.sgt_scat AS sgt_scat,
  re.sgt_rcat AS sgt_rcat,
  case when ar.alloc_qty > 0 then ar.alloc_qty else 0 end AS alloc_qty,
  re.charg AS charg
FROM aufk AS au
INNER JOIN resb AS re ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Arun_Com_Ralloc AS ar ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN nsdm_e_marc AS mr ON /* join condition not captured in parsed metadata */
;