pph_e_Mdub_2

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_Mdub_2.
-- 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_MDUB_2

CREATE VIEW pph_e_Mdub_2 AS
SELECT
  m.matnr AS matnr,
  m.werks AS werks,
  m.meins AS meins,
  m.dat00 AS dat00,
  m.sort1 AS sort1,
  m.sort2 AS sort2,
  m.delkz AS delkz,
  m.vrfkz AS vrfkz,
  m.plumi AS plumi,
  m.umren AS umren,
  m.umrez AS umrez,
  m.dat00 AS dat01,
  m.wrk02 AS wrk02,
  m.lgort AS lgort,
  m.charg AS charg,
  m.delnr AS delnr,
  m.delps AS delps,
  m.delet AS delet,
  m.sernr AS sernr,
  m.revlv AS revlv,
  m.plifz AS plifz,
  m.reslo AS reslo,
  m.mdub_umsok AS mdub_umsok,
  m.mdub_bstyp AS mdub_bstyp,
  m.mdub_retpo AS mdub_retpo,
  m.mdub_lblkz AS mdub_lblkz,
  m.mdub_emlif AS mdub_emlif,
  m.mdub_insmk AS mdub_insmk,
  m.mdub_loekz AS mdub_loekz,
  m.mdub_aktnr AS mdub_aktnr,
  m.MDUB_FLS_RSTO AS MDUB_FLS_RSTO,
  m.mdub_x_plifz AS mdub_x_plifz,
  m.SGT_SCAT AS SGT_SCAT,
  m.SGT_RCAT AS SGT_RCAT,
  m.knttp_db AS knttp_db,
  m.kzvbr_db AS kzvbr_db,
  m.kzbws_db AS kzbws_db
FROM PPH_E_MDUB_01 AS m
;