/merp/mm_Material_Plant

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 /merp/mm_Material_Plant.
-- 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: /MERP/MM_MAPLANT
-- Parameters: p_langu : spras

CREATE VIEW /merp/mm_Material_Plant AS
SELECT
  mara.matnr AS matnr,
  marc.werks AS werks,
  mara.mtart AS mtart,
  mara.mbrsh AS mbrsh,
  mara.matkl AS matkl,
  mara.meins AS meins,
  mara.xchpf AS xchpf,
  mara.ean11 AS ean11,
  mara.mfrpn AS mfrpn,
  mara.mfrnr AS mfrnr,
  mara.prdha AS prdha,
  mara.serial AS serial,
  makt.maktx AS maktx,
  marc.pstat AS pstat,
  marc.lvorm AS lvorm,
  marc.bwtty AS bwtty,
  marc.xchar AS xchar,
  marc.mmsta AS mmsta,
  marc.mmstd AS mmstd,
  marc.maabc AS maabc,
  marc.kzkri AS kzkri,
  marc.ekgrp AS ekgrp,
  marc.ausme AS ausme,
  marc.dispr AS dispr,
  marc.dismm AS dismm,
  marc.dispo AS dispo,
  marc.kzdie AS kzdie,
  marc.plifz AS plifz,
  marc.webaz AS webaz,
  marc.perkz AS perkz,
  marc.ausss AS ausss,
  marc.disls AS disls,
  marc.beskz AS beskz,
  marc.sobsl AS sobsl,
  marc.minbe AS minbe,
  marc.eisbe AS eisbe,
  marc.bstmi AS bstmi,
  marc.bstma AS bstma,
  marc.bstfe AS bstfe,
  marc.bstrf AS bstrf,
  marc.mabst AS mabst,
  marc.losfx AS losfx,
  marc.sbdkz AS sbdkz,
  marc.lagpr AS lagpr,
  marc.altsl AS altsl,
  marc.kzaus AS kzaus,
  marc.ausdt AS ausdt,
  marc.nfmat AS nfmat,
  marc.kzbed AS kzbed,
  marc.miskz AS miskz,
  marc.fhori AS fhori,
  marc.pfrei AS pfrei,
  marc.ffrei AS ffrei,
  marc.rgekz AS rgekz,
  marc.fevor AS fevor,
  marc.bearz AS bearz,
  marc.ruezt AS ruezt,
  marc.tranz AS tranz,
  marc.basmg AS basmg,
  marc.dzeit AS dzeit,
  marc.maxlz AS maxlz,
  marc.lzeih AS lzeih,
  marc.kzpro AS kzpro,
  marc.gpmkz AS gpmkz,
  marc.ueeto AS ueeto,
  marc.ueetk AS ueetk,
  marc.uneto AS uneto,
  marc.wzeit AS wzeit,
  marc.atpkz AS atpkz,
  marc.vzusl AS vzusl,
  marc.herbl AS herbl,
  marc.insmk AS insmk,
  marc.sproz AS sproz,
  marc.quazt AS quazt,
  marc.ssqss AS ssqss,
  marc.mpdau AS mpdau,
  marc.kzppv AS kzppv,
  marc.kzdkz AS kzdkz,
  marc.wstgh AS wstgh,
  marc.prfrq AS prfrq,
  marc.nkmpr AS nkmpr,
  marc.ladgr AS ladgr,
  marc.usequ AS usequ,
  marc.lgrad AS lgrad,
  marc.auftl AS auftl,
  marc.plvar AS plvar,
  marc.otype AS otype,
  marc.objid AS objid,
  marc.mtvfp AS mtvfp,
  marc.periv AS periv,
  marc.kzkfk AS kzkfk,
  marc.vrvez AS vrvez,
  marc.vbamg AS vbamg,
  marc.vbeaz AS vbeaz,
  marc.lizyk AS lizyk,
  marc.bwscl AS bwscl,
  marc.kautb AS kautb,
  marc.kordb AS kordb,
  marc.stawn AS stawn,
  marc.herkl AS herkl,
  marc.herkr AS herkr,
  marc.expme AS expme,
  marc.mtver AS mtver,
  marc.prctr AS prctr,
  marc.mrppp AS mrppp,
  marc.sauft AS sauft,
  marc.fxhor AS fxhor,
  marc.vrmod AS vrmod,
  marc.vint1 AS vint1,
  marc.vint2 AS vint2,
  marc.verkz AS verkz,
  marc.stlal AS stlal,
  marc.stlan AS stlan,
  marc.plnnr AS plnnr,
  marc.aplal AS aplal,
  marc.losgr AS losgr,
  marc.sobsk AS sobsk,
  marc.frtme AS frtme,
  marc.lgpro AS lgpro,
  marc.disgr AS disgr,
  marc.kausf AS kausf,
  marc.qzgtp AS qzgtp,
  marc.qmatv AS qmatv,
  marc.takzt AS takzt,
  marc.rwpro AS rwpro,
  marc.copam AS copam,
  marc.abcin AS abcin,
  marc.awsls AS awsls,
  marc.sernp AS sernp,
  marc.cuobj AS cuobj,
  marc.stdpd AS stdpd,
  marc.sfepr AS sfepr,
  marc.xmcng AS xmcng,
  marc.qssys AS qssys,
  marc.lfrhy AS lfrhy,
  marc.rdprf AS rdprf,
  marc.vrbmt AS vrbmt,
  marc.vrbwk AS vrbwk,
  marc.vrbdt AS vrbdt,
  marc.vrbfk AS vrbfk,
  marc.autru AS autru,
  marc.prefe AS prefe,
  marc.prenc AS prenc,
  marc.preno AS preno,
  marc.prend AS prend,
  marc.prene AS prene,
  marc.preng AS preng,
  marc.itark AS itark,
  marc.servg AS servg,
  marc.kzkup AS kzkup,
  marc.strgr AS strgr,
  marc.cuobv AS cuobv,
  marc.lgfsb AS lgfsb,
  marc.schgt AS schgt,
  marc.ccfix AS ccfix,
  marc.eprio AS eprio,
  marc.qmata AS qmata,
  marc.resvp AS resvp,
  marc.plnty AS plnty,
  marc.uomgr AS uomgr,
  marc.umrsl AS umrsl,
  marc.abfac AS abfac,
  marc.sfcpf AS sfcpf,
  marc.shflg AS shflg,
  marc.shzet AS shzet,
  marc.mdach AS mdach,
  marc.kzech AS kzech,
  marc.megru AS megru,
  marc.mfrgr AS mfrgr,
  marc.kzagl AS kzagl,
  marc.fvidk AS fvidk,
  marc.fxpru AS fxpru,
  marc.loggr AS loggr,
  marc.fprfm AS fprfm,
  marc.indus AS indus,
  marc.mownr AS mownr,
  marc.mogru AS mogru,
  marc.casnr AS casnr,
  marc.gpnum AS gpnum,
  marc.steuc AS steuc,
  marc.fabkz AS fabkz,
  marc.matgr AS matgr,
  marc.vspvb AS vspvb,
  marc.dplfs AS dplfs,
  marc.dplpu AS dplpu,
  marc.dplho AS dplho,
  marc.minls AS minls,
  marc.maxls AS maxls,
  marc.fixls AS fixls,
  marc.ltinc AS ltinc,
  marc.compl AS compl,
  marc.convt AS convt,
  marc.shpro AS shpro,
  marc.ahdis AS ahdis,
  marc.diber AS diber,
  marc.kzpsp AS kzpsp,
  marc.ocmpf AS ocmpf,
  marc.apokz AS apokz,
  marc.mcrue AS mcrue,
  marc.lfmon AS lfmon,
  marc.lfgja AS lfgja,
  marc.eislo AS eislo,
  marc.ncost AS ncost,
  marc.uchkz AS uchkz,
  marc.ucmat AS ucmat,
  marc.sgt_covs AS sgt_covs,
  marc.sgt_statc AS sgt_statc,
  marc.sgt_scope AS sgt_scope,
  marc.sgt_mrpsi AS sgt_mrpsi,
  marc.sgt_prcm AS sgt_prcm,
  marc.sgt_chint AS sgt_chint,
  marc.sgt_stk_prt AS sgt_stk_prt,
  marc.fsh_seaim AS fsh_seaim,
  marc.cons_procg AS cons_procg,
  marc.gi_pr_time AS gi_pr_time,
  marc.ref_schema AS ref_schema,
  marc.min_troc AS min_troc,
  marc.max_troc AS max_troc,
  marc.target_stock AS target_stock,
  marc./vso/r_pkgrp AS vsor_pkgrp,
  marc.iuid_type AS iuid_type,
  marc.uid_iea AS uid_iea
FROM mara
INNER JOIN nsdm_e_marc AS marc ON /* join condition not captured in parsed metadata */
INNER JOIN t006 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN makt ON /* join condition not captured in parsed metadata */
;