Atpc_Cds_Ekes

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_Ekes.
-- 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_EKES

CREATE VIEW Atpc_Cds_Ekes AS
SELECT
  ekes.ebeln AS delnr,
  ekes.ebelp AS delps,
  ekes.etens AS delet,
  ekes.mandt AS mandt,
  ekes.matnr AS matnr,
  ekes.werks AS werks,
  ekes.lgort AS lgort,
  ekes.charg AS charg,
  ekes.sgt_scat AS sgt_scat,
  ekes.lblkz AS lblkz,
  ekes.emlif AS emlif,
  ekkn.vbeln AS vbeln,
  ekkn.vbelp AS vbelp,
  ekkn.ps_psp_pnr AS ps_psp_pnr,
  ekes.eindt AS eindt,
  ekes.menge AS menge,
  ekes.dabmg AS dabmg,
  ekes.bwtar AS bwtar,
  ekes.webaz AS webaz,
  ekes.meins AS meins,
  ekes.umrez AS umrez,
  ekes.umren AS umren,
  ekes.knttp AS knttp,
  ekko.reswk AS reswk,
  ekes.uzeit AS uzeit
FROM atp_ekes AS ekes
LEFT OUTER JOIN Atpc_Cds_Ekkn AS ekkn ON /* join condition not captured in parsed metadata */
;