PPH_ENT_MAT_CTRL_DD

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_ENT_MAT_CTRL_DD.
-- 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.
-- Parameters: planning_date : datum

CREATE VIEW PPH_ENT_MAT_CTRL_DD AS
SELECT
  matloc.matnr AS matnr,
  matloc.werks AS werks,
  matloc.berid AS berid,
  matloc.sgt_csgr AS sgt_csgr,
  matloc.sgt_covsa AS sgt_covsa,
  matloc.sgt_stat AS sgt_stat,
  matloc.sgt_rel AS sgt_rel,
  matloc.sgt_covs AS sgt_covs,
  matloc.sgt_statc AS sgt_statc,
  matloc.sgt_scope AS sgt_scope,
  matloc.sgt_mrpsi AS sgt_mrpsi,
  matloc.sgt_prcm AS sgt_prcm,
  matloc.sgt_chint AS sgt_chint,
  matloc.fsh_group_pr AS fsh_group_pr,
  matloc.berty AS berty,
  matloc.matkl AS matkl,
  matloc.lvorm_mara AS lvorm_mara,
  matloc.lvorm_marc AS lvorm_marc,
  matloc.satnr AS satnr,
  matloc.mstae AS mstae,
  matloc.attyp AS attyp,
  matloc.meins AS meins,
  matloc.disst AS disst,
  matloc.kzkfg AS kzkfg,
  matloc.kzeff AS kzeff,
  matloc.cuobf AS cuobf,
  matloc.mprof AS mprof,
  matloc.mfrpn AS mfrpn,
  matloc.mfrnr AS mfrnr,
  matloc.apokz AS apokz,
  matloc.mmsta AS mmsta,
  matloc.mmstd AS mmstd,
  matloc.mstde AS mstde,
  matloc.maabc AS maabc,
  matloc.ekgrp AS ekgrp,
  matloc.andec AS andec,
  matloc.beskz AS beskz,
  matloc.sobes AS sobes,
  matloc.wrk02 AS wrk02,
  matloc.isloc AS isloc,
  matloc.umldb AS umldb,
  matloc.skip_grpt AS skip_grpt,
  matloc.lbear AS lbear,
  matloc.sbdkz AS sbdkz,
  matloc.kzaus AS kzaus,
  matloc.ausdt AS ausdt,
  matloc.mtart AS mtart,
  matloc.disgr AS disgr,
  matloc.dispo AS dispo,
  matloc.miskz AS miskz,
  matloc.rwpro AS rwpro,
  matloc.fhori AS fhori,
  matloc.ahdis AS ahdis,
  matloc.vrmod AS vrmod,
  matloc.vint1 AS vint1,
  matloc.vint2 AS vint2,
  matloc.stdpd AS stdpd,
  matloc.cuobv AS cuobv,
  matloc.bearz AS bearz,
  matloc.ruezt AS ruezt,
  matloc.tranz AS tranz,
  matloc.webaz AS webaz,
  matloc.plifz AS plifz,
  matloc.dzeit AS dzeit,
  matloc.wzeit AS wzeit,
  matloc.shflg AS shflg,
  matloc.shzet AS shzet,
  matloc.shpro AS shpro,
  matloc.qmatv AS qmatv,
  matloc.cuobj AS cuobj,
  matloc.resvp AS resvp,
  matloc.umlmc AS umlmc,
  matloc.usequ AS usequ,
  matloc.disls AS disls,
  matloc.bstmi AS bstmi,
  matloc.bstma AS bstma,
  matloc.bstfe AS bstfe,
  matloc.waers AS waers,
  matloc.losfx AS losfx,
  matloc.lagpr AS lagpr,
  matloc.ausss AS ausss,
  matloc.takzt AS takzt,
  matloc.bstrf AS bstrf,
  matloc.rdprf AS rdprf,
  matloc.strgr AS strgr,
  matloc.lgfsb AS lgfsb,
  matloc.periv AS periv,
  matloc.mrppp AS mrppp,
  matloc.lfrhy AS lfrhy,
  matloc.sauft AS sauft,
  matloc.sfepr AS sfepr,
  matloc.fxhor AS fxhor,
  matloc.dismm AS dismm,
  matloc.perkz AS perkz,
  matloc.sobsl AS sobsl,
  matloc.fevor AS fevor,
  matloc.basmg AS basmg,
  matloc.lgpro AS lgpro,
  matloc.disvf AS disvf,
  matloc.bbbed AS bbbed,
  matloc.fxart AS fxart,
  matloc.proos AS proos,
  matloc.prred AS prred,
  matloc.rybed AS rybed,
  matloc.kzreg AS kzreg,
  matloc.cbppt AS cbppt,
  matloc.icbed AS icbed,
  matloc.u1bed AS u1bed,
  matloc.u2bed AS u2bed,
  matloc.u4bed AS u4bed,
  matloc.a1bed AS a1bed,
  matloc.a2bed AS a2bed,
  matloc.respl AS respl,
  matloc.reshz AS reshz,
  matloc.grrel AS grrel,
  matloc.rvpkz AS rvpkz,
  matloc.andis AS andis,
  matloc.bsart AS bsart,
  matloc.bartl AS bartl,
  matloc.bartu AS bartu,
  matloc.sbdis AS sbdis,
  matloc.scflg AS scflg,
  matloc.psban AS psban,
  matloc.xfan1 AS xfan1,
  matloc.gterm AS gterm,
  matloc.refwk AS refwk,
  matloc.vertr AS vertr,
  matloc.nfvbc AS nfvbc,
  matloc.kntbu AS kntbu,
  matloc.ktdbu AS ktdbu,
  matloc.kzumb AS kzumb,
  matloc.bztek AS bztek,
  matloc.umthz AS umthz,
  matloc.vwvor AS vwvor,
  matloc.vwver AS vwver,
  matloc.plahz AS plahz,
  matloc.kzdrb AS kzdrb,
  matloc.fixpa AS fixpa,
  matloc.fixfa AS fixfa,
  matloc.fixba AS fixba,
  matloc.fixbe AS fixbe,
  matloc.fixqm AS fixqm,
  matloc.fixla AS fixla,
  matloc.mxbst AS mxbst,
  matloc.besal AS besal,
  matloc.psres AS psres,
  matloc.cslid AS cslid,
  matloc.kastl AS kastl,
  matloc.exsgt AS exsgt,
  matloc.lifnr AS lifnr,
  matloc.fabkl AS fabkl,
  matloc.kkowk AS kkowk,
  matloc.mengu AS mengu,
  matloc.wertu AS wertu,
  matloc.mfxdt AS mfxdt,
  matloc.mfhkz AS mfhkz,
  matloc.disfg AS disfg,
  matloc.xfat1 AS xfat1,
  matloc.altsl AS altsl,
  matloc.picnum AS picnum,
  matloc.imatn AS imatn,
  matloc.losvf AS losvf,
  matloc.loskz AS loskz,
  matloc.peraz AS peraz,
  matloc.terbv AS terbv,
  matloc.uelap AS uelap,
  matloc.kfpkz AS kfpkz,
  matloc.kfpaz AS kfpaz,
  matloc.lglvf AS lglvf,
  matloc.lglkz AS lglkz,
  matloc.lgpaz AS lgpaz,
  matloc.lgter AS lgter,
  matloc.lguel AS lguel,
  matloc.lgmin AS lgmin,
  matloc.lgmax AS lgmax,
  matloc.kzspl AS kzspl,
  matloc.lgspl AS lgspl,
  matloc.intka AS intka,
  matloc.lgint AS lgint,
  matloc.lgknd AS lgknd,
  matloc.kzhor AS kzhor,
  matloc.hbvar AS hbvar,
  matloc.lastl AS lastl,
  matloc.untkz AS untkz,
  matloc.agreq AS agreq,
  matloc.erhor AS erhor,
  matloc.plan_in_abap AS plan_in_abap,
  matloc.resdt AS resdt,
  matloc.resal AS resal,
  matloc.mtwzt AS mtwzt,
  taken from PPH_DD_PRODUCT if found matloc.adspc_spc AS adspc_spc,
  matloc.dd_u2bed AS dd_u2bed,
  matloc.dd_u4bed AS dd_u4bed,
  matloc.dd_bbbed AS dd_bbbed,
  matloc.dd_sbbed AS dd_sbbed,
  matloc.serep AS serep,
  matloc.spike_hrz_ls AS spike_hrz_ls,
  matloc.spike_hrz_lm AS spike_hrz_lm,
  matloc.mdach AS mdach
FROM pph_e_mat_ctrl AS matloc
;