pph_e_Mdua

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_Mdua.
-- 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_MDUA

CREATE VIEW pph_e_Mdua AS
SELECT
  eban.matnr AS matnr,
  ebub.reswk AS werks,
  lfdat AS dat00,
  '2' AS sort1,
  '05' AS sort2,
  'U2' AS delkz,
  '' AS vrfkz,
  '-' AS plumi,
  - (eban.menge - eban.bsmng) AS mng01,
  eban.menge - eban.bsmng AS mng03,
  eban.lfdat AS dat01,
  eban.werks AS wrk02,
  eban.reslo AS lgort,
  eban.charg AS charg,
  eban.banfn AS DELNR,
  eban.bnfpo AS delps,
  eban.sernr AS sernr,
  eban.revlv AS revlv,
  eban.flief AS lifnr,
  eban.ekorg AS ekorg,
  eban.plifz AS plifz,
  eban.lgort AS reslo,
  eban.sgt_scat AS SGT_SCAT,
  eban.sgt_rcat AS SGT_RCAT,
  eban.umsok AS mdua_umsok,
  eban.lblkz AS mdua_lblkz,
  eban.aktnr AS mdua_aktnr,
  eban.frgdt AS mdua_frgdt,
  eban.emlif AS mdua_emlif,
  eban.konnr AS mdua_konnr,
  eban.ktpnr AS mdua_ktpnr,
  eban.infnr AS mdua_infnr,
  eban.knttp AS knttp_db,
  eban.kzvbr AS kzvbr_db,
  eban.kzbws AS kzbws_db
FROM ebub
INNER JOIN eban ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_pph_ebkn AS ebkn_2 ON /* join condition not captured in parsed metadata */
;