Atpc_Cds_Eket_1

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_Eket_1.
-- 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_EKET_1

CREATE VIEW Atpc_Cds_Eket_1 AS
SELECT
  eket.ebeln AS ebeln,
  eket.ebelp AS ebelp,
  eket.etenr AS etenr,
  eket.mandt AS mandt,
  ekpo.matnr AS matnr,
  ekpo.werks AS werks,
  ekpo.lgort AS lgort,
  eket.charg AS charg,
  ekpo.sgt_rcat AS sgt_rcat,
  ekpo.sgt_scat AS sgt_scat,
  ekpo.lblkz AS lblkz,
  ekpo.emlif AS emlif,
  ekkn.vbeln AS vbeln,
  ekkn.vbelp AS vbelp,
  ekkn.ps_psp_pnr AS ps_psp_pnr,
  eket.eindt AS eindt,
  eket.eldat AS eldat,
  eket.glmng AS glmng,
  eket.wemng AS wemng,
  eket.dabmg AS dabmg,
  eket.wamng AS wamng,
  eket.dat01 AS dat01,
  eket.uzeit AS uzeit,
  case when ekpo.bstyp = 'L' then 'LE' else case when ekpo.retpo = '' then 'BE' else 'RP' end end as atpcat AS retpothenBEelseRPendendasatpcat,
  ekpo.retpo AS retpo,
  ekpo.bstyp AS bstyp,
  ekpo.insmk AS insmk,
  ekpo.meins AS meins,
  ekpo.umrez AS umrez,
  ekpo.umren AS umren,
  ekpo.webaz AS webaz,
  ekpo.bwtar AS bwtar,
  ekpo.knttp AS knttp,
  ekko.reswk AS reswk,
  ekpo.reslo AS reslo,
  ekpo.fixmg AS fixmg
FROM eket
LEFT OUTER JOIN ekpo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Atpc_Cds_Ekkn AS ekkn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ekko ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATPC_CDS_EKES_MAX AS ekes ON /* join condition not captured in parsed metadata */
;