PPH_E_MDBS_SL

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 PPH_E_MDBS_SL.
-- 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: V_PPH_MDBS_SL

CREATE VIEW PPH_E_MDBS_SL AS
SELECT
  matnr,
  werks,
  eindt AS dat00,
  '' AS sort1,
  ' ' AS sort2,
  'LE' AS delkz,
  '' AS vrfkz,
  '' AS plumi,
  eket.menge AS mng01,
  0 AS mng02,
  eindt AS dat01,
  0 AS webaz,
  '' AS fix01,
  '' AS fix02,
  '' AS beskz,
  '' AS sobes,
  '' AS wrk02,
  '' AS lgort,
  '' AS charg,
  ekpo.ebeln AS delnr,
  ekpo.ebelp AS delps,
  eket.etenr AS delet,
  ' ' AS rsnum,
  '' AS sernr,
  '' AS revlv,
  '' AS verid,
  '' AS knttp,
  '' AS kzvbr,
  '' AS sobkz,
  '' AS kdauf,
  ' ' AS kdpos,
  ' ' AS pspel,
  '' AS qunum,
  ' ' AS qupos,
  '' AS lifnr,
  eket.bedat AS bedat,
  eket.menge AS etmen,
  glmng,
  0 AS auftm,
  '0000000000' AS arsnr,
  ' ' AS arsps,
  '' AS kzbws,
  0 AS mdmng,
  0 AS tpmng,
  '' AS dbskz,
  '' AS reslo,
  ' ' AS prio_urg,
  ' ' AS prio_req,
  '' AS sgt_scat,
  '' AS sgt_rcat,
  '' AS mdbs_retpo,
  '' AS mdbs_loekz,
  '' AS mdbs_aktnr,
  '' AS mdbs_insmk,
  '' AS mdbs_itcons,
  '' AS mdbs_statu,
  ekpo.meins AS mdbs_bstme,
  '' AS mdbs_no_disp,
  '' AS mdbs_wepos,
  ekpo.emlif AS mdbs_emlif,
  ameng AS mdbs_ameng,
  '' AS mdbs_fixmg,
  '' AS mdbs_eglkz,
  '' AS mdbs_kzfix,
  0 AS mdbs_etfz1,
  0 AS mdbs_etfz2,
  0 AS mdbs_amng01,
  '' AS mdbs_etdrk,
  knttp AS knttp_db,
  kzvbr AS kzvbr_db,
  kzbws AS kzbws_db,
  cuobj,
  ekpo.pstyp AS pstyp,
  '00000000' AS eldat
FROM ekpo
INNER JOIN eket ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ekko ON /* join condition not captured in parsed metadata */
;