Atpc_Cds_Ebub_D

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_Ebub_D.
-- 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_EBUB_D

CREATE VIEW Atpc_Cds_Ebub_D AS
SELECT
  ebub.banfn AS delnr,
  ebub.bnfpo AS delps,
  'U2' AS atpcat,
  '2' AS sort1,
  '05' AS sort2,
  ebub.mandt AS mandt,
  ebub.matnr AS matnr,
  ebub.reswk AS werks,
  ebub.reslo AS reslo,
  ebub.charg AS charg,
  ebub.sgt_rcat AS sgt_rcat,
  ebub.sgt_scat AS sgt_scat,
  ebub.umsok AS sobkz,
  ebub.lblkz AS lblkz,
  ebub.emlif AS emlif,
  ebkn.vbeln AS kdauf,
  ebkn.vbelp AS kdpos,
  ebkn.ps_psp_pnr AS pspel,
  ebub.frgdt AS frgdt,
  ebub.lfdat AS lfdat,
  ebub.menge AS menge,
  ebub.bsmng AS bsmng,
  ebub.mng02 AS cnfqty
FROM atp_ebub AS ebub
LEFT OUTER JOIN Atpc_Cds_Ebkn AS ebkn ON /* join condition not captured in parsed metadata */
;