Mbv_Mbew

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 Mbv_Mbew.
-- 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: MBVMBEW

CREATE VIEW Mbv_Mbew AS
SELECT
  b.mandt AS mandt,
  b.matnr AS matnr,
  b.bwkey AS bwkey,
  b.bwtar AS bwtar,
  b.lvorm AS lvorm,
  b.vprsv AS vprsv,
  b.verpr AS verpr,
  b.stprs AS stprs,
  b.peinh AS peinh,
  b.bklas AS bklas,
  cast(COALESCE(b.salkv, 0) as salkv) AS salkv,
  b.vmkum AS vmkum,
  b.vmsal AS vmsal,
  b.vmvpr AS vmvpr,
  b.vmver AS vmver,
  b.vmstp AS vmstp,
  b.vmpei AS vmpei,
  b.vmbkl AS vmbkl,
  b.vmsav AS vmsav,
  b.vjkum AS vjkum,
  b.vjsal AS vjsal,
  b.vjvpr AS vjvpr,
  b.vjver AS vjver,
  b.vjstp AS vjstp,
  b.vjpei AS vjpei,
  b.vjbkl AS vjbkl,
  b.vjsav AS vjsav,
  b.lfgja AS lfgja,
  b.lfmon AS lfmon,
  b.bwtty AS bwtty,
  b.stprv AS stprv,
  b.laepr AS laepr,
  b.zkprs AS zkprs,
  b.zkdat AS zkdat,
  b.timestamp AS timestamp,
  b.bwprs AS bwprs,
  b.bwprh AS bwprh,
  b.vjbws AS vjbws,
  b.vjbwh AS vjbwh,
  b.vvjsl AS vvjsl,
  b.vvjlb AS vvjlb,
  b.vvmlb AS vvmlb,
  b.vvsal AS vvsal,
  b.zplpr AS zplpr,
  b.zplp1 AS zplp1,
  b.zplp2 AS zplp2,
  b.zplp3 AS zplp3,
  b.zpld1 AS zpld1,
  b.zpld2 AS zpld2,
  b.zpld3 AS zpld3,
  b.pperz AS pperz,
  b.pperl AS pperl,
  b.pperv AS pperv,
  b.kalkz AS kalkz,
  b.kalkl AS kalkl,
  b.kalkv AS kalkv,
  b.kalsc AS kalsc,
  b.xlifo AS xlifo,
  b.mypol AS mypol,
  b.bwph1 AS bwph1,
  b.bwps1 AS bwps1,
  b.abwkz AS abwkz,
  b.pstat AS pstat,
  b.kaln1 AS kaln1,
  b.kalnr AS kalnr,
  b.bwva1 AS bwva1,
  b.bwva2 AS bwva2,
  b.bwva3 AS bwva3,
  b.vers1 AS vers1,
  b.vers2 AS vers2,
  b.vers3 AS vers3,
  b.hrkft AS hrkft,
  b.kosgr AS kosgr,
  b.pprdz AS pprdz,
  b.pprdl AS pprdl,
  b.pprdv AS pprdv,
  b.pdatz AS pdatz,
  b.pdatl AS pdatl,
  b.pdatv AS pdatv,
  b.ekalr AS ekalr,
  b.vplpr AS vplpr,
  b.mlmaa AS mlmaa,
  b.mlast AS mlast,
  b.lplpr AS lplpr,
  b.hkmat AS hkmat,
  b.sperw AS sperw,
  b.kziwl AS kziwl,
  b.wlinl AS wlinl,
  b.abciw AS abciw,
  b.bwspa AS bwspa,
  b.lplpx AS lplpx,
  b.vplpx AS vplpx,
  b.fplpx AS fplpx,
  b.lbwst AS lbwst,
  b.vbwst AS vbwst,
  b.fbwst AS fbwst,
  b.eklas AS eklas,
  b.qklas AS qklas,
  b.mtuse AS mtuse,
  b.mtorg AS mtorg,
  b.ownpr AS ownpr,
  b.xbewm AS xbewm,
  b.bwpei AS bwpei,
  b.mbrue AS mbrue,
  b.oklas AS oklas,
  mbew.oippinv AS oippinv
FROM mbew
LEFT OUTER JOIN E_Productvaluation AS _ActiveExtension ON matnr = _ActiveExtension.Product AND bwkey = _ActiveExtension.ValuationArea AND bwtar = _ActiveExtension.ValuationType  -- association [0..1]
;