PPH_E_MAT_CTRL

CDS View
206 Fields 4 CDS Views

PPH_E_MAT_CTRL is a CDS View in S/4HANA. It contains 206 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
PPH_DDL_MDUB_P view inner
pph_e_mat_ctrl_dd view from Material Data for DDMRP
PPH_ENT_MAT_CTRL_DD view_entity from Material Data for DDMRP
Pph_MatlocForPlanFileEntry view_entity from ProductSettings for Plan File Entries

Fields (206)

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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPH_E_MAT_CTRL (
    BERID,
    MATNR,
    WERKS,
    A1BED,
    A2BED,
    AGREQ,
    AHDIS,
    ALTSL,
    ANDEC,
    ANDIS,
    APOKZ,
    ARUN_FIX_BATCH,
    ATTYP,
    AUSDT,
    AUSSS,
    BARTL,
    BARTU,
    BASMG,
    BBBED,
    BEARZ,
    BERTY,
    BESAL,
    BESKZ,
    BSART,
    BSTFE,
    BSTMA,
    BSTMI,
    BSTRF,
    BZTEK,
    CBPPT,
    CSLID,
    CUOBF,
    CUOBJ,
    CUOBV,
    DD_BBBED,
    DD_SBBED,
    DD_U2BED,
    DD_U4BED,
    DISFG,
    DISGR,
    DISLS,
    DISMM,
    DISPO,
    DISST,
    DISVF,
    DZEIT,
    EKGRP,
    ERHOR,
    EXSGT,
    FABKL,
    FEVOR,
    FHORI,
    FIXBA,
    FIXBE,
    FIXFA,
    FIXLA,
    FIXPA,
    FIXQM,
    FSH_CALENDAR_GROUP,
    FSH_GROUP_PR,
    FSH_MG_ARUN_REQ,
    FSH_VAR_GROUP,
    FXART,
    FXHOR,
    GRREL,
    GTERM,
    HBVAR,
    HORIZ_DAYS_MINUS,
    HORIZ_DAYS_PLUS,
    ICBED,
    IMATN,
    INTKA,
    KASTL,
    KFPAZ,
    KFPKZ,
    KKOWK,
    KNTBU,
    KTDBU,
    KZAUS,
    KZDRB,
    KZEFF,
    KZHOR,
    KZKFG,
    KZREG,
    KZSPL,
    KZUMB,
    LAGPR,
    LASTL,
    LBEAR,
    LFRHY,
    LGFSB,
    LGINT,
    LGKND,
    LGLKZ,
    LGLVF,
    LGMAX,
    LGMIN,
    LGPAZ,
    LGPRO,
    LGSPL,
    LGTER,
    LGUEL,
    LIFNR,
    LOSFX,
    LOSKZ,
    LOSVF,
    LVORM_MARA,
    LVORM_MARC,
    MAABC,
    MATKL,
    MDACH,
    MEINS,
    MENGU,
    MFHKZ,
    MFRNR,
    MFRPN,
    MFXDT,
    MISKZ,
    MMSTA,
    MMSTD,
    MPROF,
    MRPPP,
    MSTAE,
    MSTDE,
    MTART,
    MTWZT,
    MXBST,
    NFVBC,
    ON_HAND_ALRT_THLD_FCTR,
    PERAZ,
    PERIV,
    PERKZ,
    PICNUM,
    PLAHZ,
    PLAN_IN_ABAP,
    PLIFZ,
    PROOS,
    PRRED,
    PSBAN,
    PSRES,
    QMATV,
    RDPRF,
    REFWK,
    RESAL,
    RESDT,
    RESHZ,
    RESPL,
    RESVP,
    RUEZT,
    RVPKZ,
    RWPRO,
    RYBED,
    SATNR,
    SAUFT,
    SBDIS,
    SBDKZ,
    SCFLG,
    SEREP,
    SFEPR,
    SFTY_STK_METH,
    SGT_CHINT,
    SGT_COVS,
    SGT_COVSA,
    SGT_CSGR,
    SGT_MRPSI,
    SGT_PRCM,
    SGT_REL,
    SGT_SCOPE,
    SGT_STAT,
    SGT_STATC,
    SHFLG,
    SHPRO,
    SHZET,
    SKIP_GRPT,
    SOBES,
    SOBSL,
    SPIKE_HRZ_LM,
    SPIKE_HRZ_LS,
    SPIKE_THLD_FCTR,
    STDPD,
    STRGR,
    TAKZT,
    TERBV,
    TRANZ,
    U1BED,
    U2BED,
    U4BED,
    UELAP,
    UMLDB,
    UMLMC,
    UMTHZ,
    UNTKZ,
    USEQU,
    VERTR,
    VINT1,
    VINT2,
    VRMOD,
    VWVER,
    VWVOR,
    WAERS,
    WEBAZ,
    WERTU,
    WRK02,
    WZEIT,
    XFAN1,
    XFAT1,
    PRIMARY KEY (BERID, MATNR, WERKS)
);

Learn More