pph_e_mat_ctrl

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_mat_ctrl.
-- 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_MAT_CTRL

CREATE VIEW pph_e_mat_ctrl 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,
  t001w.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.kzkup AS kzkup,
  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,
  cast(matloc.andec as abap.dec(5,0)) AS andec,
  coalesce(t460a.beskz,matloc.beskz) AS beskz,
  coalesce(t460a.sobes,'') AS sobes,
  coalesce(t460a.wrk02,'') AS wrk02,
  coalesce(t460a.reslo,'') AS isloc,
  t460a.umldb AS umldb,
  t460a.skip_grpt AS skip_grpt,
  matloc.sbdkz AS sbdkz,
  matloc.kzaus AS kzaus,
  matloc.ausdt AS ausdt,
  matloc.mtart AS mtart,
  matloc.dispo AS dispo,
  matloc.miskz AS miskz,
  matloc.rwpro AS rwpro,
  matloc.fhori AS fhori,
  matloc.ahdis AS ahdis,
  case AS casevrmod,
  case AS casevint1,
  case AS casevint2,
  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.umlmc AS umlmc,
  matloc.usequ AS usequ,
  matloc.minbe AS minbe,
  matloc.eisbe AS eisbe,
  matloc.disls AS disls,
  matloc.bstmi AS bstmi,
  matloc.bstma AS bstma,
  matloc.bstfe AS bstfe,
  matloc.mabst AS mabst,
  matloc.losfx AS losfx,
  t001.waers AS waers,
  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.lfrhy AS lfrhy,
  matloc.sauft AS sauft,
  matloc.sfepr AS sfepr,
  cast(case when t438a_mat.fxart is not null and t438a_mat.fxart <> '' and t438a_mat.fxart <> '0' then case when matloc.fxhor = '' or matloc.fxhor = '000' then case when matloc.berty != '' and matloc.berty != '01' then case when t438m_mdma.fixhz is not null then t438m_mdma.fixhz else matloc.fxhor end else case when t438m_marc.fixhz is not null then t438m_marc.fixhz else matloc.fxhor end end else matloc.fxhor end else '000' end as abap.dec(3,0)) as fxhor AS dec30asfxhor,
  matloc.dismm AS dismm,
  matloc.perkz AS perkz,
  matloc.sobsl AS sobsl,
  matloc.fevor AS fevor,
  matloc.basmg AS basmg,
  matloc.lgpro AS lgpro,
  case when t438a_mat.dismm is not null then t438a_mat.disvf else 'N' end as disvf AS disvfelseNendasdisvf,
  t438a_mat.bbbed AS bbbed,
  t438a_mat.fxart AS fxart,
  t438a_mat.proos AS proos,
  t438a_mat.prred AS prred,
  t438a_mat.rybed AS rybed,
  t438a_mat.kzreg AS kzreg,
  t438a_mat.cbppt AS cbppt,
  t438a_mat.icbed AS icbed,
  t438a_mat.u1bed AS u1bed,
  t438a_mat.u2bed AS u2bed,
  t438a_mat.u4bed AS u4bed,
  t438a_mat.a1bed AS a1bed,
  t438a_mat.a2bed AS a2bed,
  t438a_mat.respl AS respl,
  t438a_mat.dd_u2bed AS dd_u2bed,
  t438a_mat.dd_u4bed AS dd_u4bed,
  t438a_mat.dd_bbbed AS dd_bbbed,
  t438a_mat.dd_sbbed AS dd_sbbed,
  '' AS scflg,
  t399d.psban AS psban,
  t399d.xfan1 AS xfan1,
  t399d.refwk AS refwk,
  t399d.nfvbc AS nfvbc,
  t399d.kntbu AS kntbu,
  t399d.ktdbu AS ktdbu,
  t399d.kzumb AS kzumb,
  cast(t399d.bztek as abap.dec(3,0)) AS bztek,
  cast(case when t438m_mdma.umthz <> '000' then t438m_mdma.umthz when t438m_marc.umthz <> '000' then t438m_marc.umthz else t399d.umthz end as abap.dec(3,0)) as umthz AS dec30asumthz,
  cast(case when t438m_mdma.vwvor <> '00' then t438m_mdma.vwvor else t399d.vwvor end as abap.dec(2,0)) as vwvor AS dec20asvwvor,
  cast(case when t438m_mdma.vwver <> '00' then t438m_mdma.vwver else t399d.vwvor end as abap.dec(2,0)) as vwver AS dec20asvwver,
  cast(case when t438m_mdma.plahz <> '000' then t438m_mdma.plahz else t399d.plahz end as abap.dec(3,0)) as plahz AS dec30asplahz,
  t399d.fixpa AS fixpa,
  t399d.fixfa AS fixfa,
  t399d.fixba AS fixba,
  t399d.fixbe AS fixbe,
  t399d.fixqm AS fixqm,
  t399d.fixla AS fixla,
  cast(t399d.mxbst as abap.dec(3,0)) AS mxbst,
  t399d.serep AS serep,
  t399d.psres AS psres,
  t399d.cslid AS cslid,
  t399d.kastl AS kastl,
  t001w.lifnr AS lifnr,
  t001w.fabkl AS fabkl,
  t001w.kkowk AS kkowk,
  t134m.mengu AS mengu,
  t134m.wertu AS wertu,
  coalesce(mdll.lbear,'') AS lbear,
  matloc.mfxdt AS mfxdt,
  case AS mfxdt00000000thenelseXendasmfhkz,
  matloc.disfg AS disfg,
  if not overruled by MRP group end as xfat1 AS ifnotoverruledbyMRPgroupendasxfat1,
  matloc.altsl AS altsl,
  matloc.picnum AS picnum,
  matloc.imatn AS imatn,
  matloc.gsaen AS gsaen,
  matloc.resal AS resal,
  matloc.resdt AS resdt,
  matloc.rhytd AS rhytd,
  matloc.nodisp AS nodisp,
  matloc.num_mdps AS num_mdps,
  matloc.num_rto_item AS num_rto_item,
  matloc.plan_in_abap AS plan_in_abap,
  matloc.adspc_spc AS adspc_spc,
  t439a.losvf AS losvf,
  t439a.loskz AS loskz,
  t439a.peraz AS peraz,
  t439a.terbv AS terbv,
  t439a.uelap AS uelap,
  t439a.kfpkz AS kfpkz,
  t439a.kfpaz AS kfpaz,
  t439a.lglvf AS lglvf,
  t439a.lglkz AS lglkz,
  t439a.lgpaz AS lgpaz,
  t439a.lgter AS lgter,
  t439a.lguel AS lguel,
  t439a.lgmin AS lgmin,
  t439a.lgmax AS lgmax,
  t439a.kzspl AS kzspl,
  t439a.lgspl AS lgspl,
  t439a.intka AS intka,
  t439a.lgint AS lgint,
  t439a.lgknd AS lgknd,
  t439a.kzhor AS kzhor,
  t439a.hbvar AS hbvar,
  t439a.lastl AS lastl,
  t439a.untkz AS untkz,
  t437s.agreq AS agreq,
  cast(t436a.erhor as abap.dec(3,0)) AS erhor,
  I_DDProdSpike.SpikeHorizonConstant AS spike_hrz_ls,
  I_DDProdSpike.SpikeHorizonMultiplier AS spike_hrz_lm,
  matloc.mdach AS mdach
FROM pph_e_mat_ctrl_1 AS matloc
LEFT OUTER JOIN pichd AS _PicSupersession ON _PicSupersession.picnum = picnum AND _PicSupersession.piccat = '01'  -- association [0..1]
LEFT OUTER JOIN pichd AS _PicFFF ON _PicFFF.picnum = imatn AND _PicFFF.piccat = '02'  -- association [0..1]
;