Atpc_Cds_Eban

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_Eban.
-- 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_EBAN

CREATE VIEW Atpc_Cds_Eban AS
SELECT
  eban.banfn AS delnr,
  eban.bnfpo AS delps,
  eban.mandt AS mandt,
  eban.matnr AS matnr,
  eban.werks AS werks,
  eban.lgort AS lgort,
  eban.charg AS charg,
  eban.sgt_rcat AS sgt_rcat,
  eban.sgt_scat AS sgt_scat,
  eban.lblkz AS lblkz,
  eban.emlif AS emlif,
  ebkn.vbeln AS vbeln,
  ebkn.vbelp AS vbelp,
  ebkn.ps_psp_pnr AS ps_psp_pnr,
  eban.lfdat AS lfdat,
  eban.eldat AS eldat,
  eban.statu AS statu,
  eban.menge AS menge,
  eban.bsmng AS bsmng,
  eban.bwtar AS bwtar,
  eban.knttp AS knttp,
  eban.reswk AS reswk,
  eban.reslo AS reslo,
  eban.webaz AS webaz,
  eban.estkz AS estkz
FROM eban
LEFT OUTER JOIN Atpc_Cds_Ebkn AS ebkn ON /* join condition not captured in parsed metadata */
;