Atpc_Cds_Mdur

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 Atpc_Cds_Mdur.
-- 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: ATPC_MDUR

CREATE VIEW Atpc_Cds_Mdur AS
SELECT
  reul.rsnum AS delnr,
  reul.rspos AS delps,
  'UL' AS atpcat,
  case resb.shkzg when 'H' then '1' else '2' end as sort1 AS shkzgwhenHthen1else2endassort1,
  '04' AS sort2,
  reul.mandt AS mandt,
  reul.matnr AS matnr,
  reul.umwrk AS werks,
  resb.umlgo AS lgort,
  reul.rspos AS rspos,
  reul.rsnum AS rsnum,
  reul.rsart AS rsart,
  resb.bdart AS bdart,
  '' AS sskey_ext,
  resb.bdter AS atpdate,
  resb.bdmng AS bdmng,
  resb.shkzg AS shkzg,
  resb.enmng AS enmng,
  resb.charg AS charg,
  resb.sgt_rcat AS sgt_rcat,
  resb.sgt_scat AS sgt_scat,
  resb.vmeng AS vmeng,
  resb.lifnr AS lifnr
FROM reul
INNER JOIN resb ON /* join condition not captured in parsed metadata */
;