NSDM_E_MAWEV

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 NSDM_E_MAWEV.
-- 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: NSDM_V_MAWEV

CREATE VIEW NSDM_E_MAWEV AS
SELECT
  a.mandt AS mandt,
  a.matnr AS matnr,
  b.werks AS werks,
  c.aland AS aland,
  a.tragr AS tragr,
  b.dismm AS dismm,
  b.atpkz AS atpkz,
  b.ladgr AS ladgr,
  b.vbamg AS vbamg,
  b.vbeaz AS vbeaz,
  b.vrvez AS vrvez,
  b.xchar AS xchar,
  b.xchpf AS xchpf,
  b.apokz AS apokz,
  b.mtvfp AS mtvfp,
  b.beskz AS beskz,
  b.eisbe AS eisbe,
  b.umlmc AS umlmc,
  b.plifz AS plifz,
  b.webaz AS webaz,
  b.wzeit AS wzeit,
  b.dzeit AS dzeit,
  b.bearz AS bearz,
  b.ruezt AS ruezt,
  b.tranz AS tranz,
  b.bwtty AS bwtty,
  b.lvorm AS lvorm,
  b.minbe AS minbe,
  b.stawn AS stawn,
  b.herkl AS herkl,
  b.herkr AS herkr,
  b.mtver AS mtver,
  b.prctr AS prctr,
  b.miskz AS miskz,
  b.vrmod AS vrmod,
  b.vint1 AS vint1,
  b.vint2 AS vint2,
  b.sobsl AS sobsl,
  b.disgr AS disgr,
  b.diber AS diber,
  b.strgr AS strgr,
  b.sbdkz AS sbdkz,
  c.taxm1 AS taxm1,
  c.taxm2 AS taxm2,
  c.taxm3 AS taxm3,
  c.taxm4 AS taxm4,
  c.taxm5 AS taxm5,
  c.taxm6 AS taxm6,
  c.taxm7 AS taxm7,
  c.taxm8 AS taxm8,
  c.taxm9 AS taxm9,
  b.sernp AS sernp,
  b.stdpd AS stdpd,
  b.cuobj AS cuobj,
  a.vhart AS vhart,
  a.fuelg AS fuelg,
  a.stfak AS stfak,
  a.magrv AS magrv,
  a.kzumw AS kzumw,
  b.qmatv AS qmatv,
  b.mfrgr AS mfrgr,
  b.basmg AS basmg,
  a.serlv AS serlv,
  a.kzwsm AS kzwsm,
  b.eprio AS eprio,
  a.kzeff AS kzeff,
  a.meins AS meins,
  b.uchkz AS uchkz,
  a.sgt_rel AS sgt_rel,
  b.sgt_covs AS sgt_covs,
  b.sgt_statc AS sgt_statc,
  b.sgt_scope AS sgt_scope,
  b.sgt_stk_prt AS sgt_stk_prt,
  b.sgt_mrpsi AS sgt_mrpsi,
  b.ppskz AS ppskz,
  b.fsh_seaim AS fsh_seaim,
  b.fprfm AS fprfm,
  a.satnr AS satnr
FROM mara AS a
INNER JOIN nsdm_e_marc AS b ON /* join condition not captured in parsed metadata */
INNER JOIN mlan AS c ON /* join condition not captured in parsed metadata */
;