PPH_E_MAT_CTRL_1

CDS View

View for reading master data

PPH_E_MAT_CTRL_1 is a CDS View in S/4HANA. View for reading master data. It contains 108 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
pph_e_mat_ctrl view from Read Material Data for MRP

Fields (108)

KeyField CDS FieldsUsed in Views
adspc_spc adspc_spc 1
ahdis ahdis 1
altsl altsl 1
apokz apokz 1
arun_fix_batch arun_fix_batch 1
attyp attyp 1
ausdt ausdt 1
ausss ausss 1
basmg basmg 1
bearz bearz 1
berid berid 1
berty berty 1
bstfe bstfe 1
bstma bstma 1
bstmi bstmi 1
bstrf bstrf 1
cuobf cuobf 1
cuobj cuobj 1
cuobv cuobv 1
disfg disfg 1
disls disls 1
dismm dismm 1
dispo dispo 1
disst disst 1
dzeit dzeit 1
eisbe eisbe 1
fevor fevor 1
fhori fhori 1
fsh_calendar_group fsh_calendar_group 1
fsh_mg_arun_req fsh_mg_arun_req 1
fsh_var_group fsh_var_group 1
gsaen gsaen 1
imatn imatn 1
kzaus kzaus 1
kzeff kzeff 1
kzkfg kzkfg 1
kzkup kzkup 1
lagpr lagpr 1
lfrhy lfrhy 1
lgfsb lgfsb 1
lgpro lgpro 1
losfx losfx 1
lvorm_mara lvorm_mara 1
lvorm_marc lvorm_marc 1
maabc maabc 1
mabst mabst 1
matkl matkl 1
matnr matnr 1
mdach mdach 1
meins meins 1
mfrnr mfrnr 1
mfrpn mfrpn 1
mfxdt mfxdt 1
minbe minbe 1
miskz miskz 1
mmsta mmsta 1
mmstd mmstd 1
mprof mprof 1
mstae mstae 1
mstde mstde 1
mtart mtart 1
nodisp nodisp 1
num_mdps num_mdps 1
num_rto_header num_rto_header 1
num_rto_item num_rto_item 1
periv periv 1
perkz perkz 1
picnum picnum 1
plan_in_abap plan_in_abap 1
plifz plifz 1
qmatv qmatv 1
rdprf rdprf 1
resal resal 1
resdt resdt 1
rhytd rhytd 1
ruezt ruezt 1
rwpro rwpro 1
satnr satnr 1
sauft sauft 1
sbdkz sbdkz 1
scm_matid_guid16 scm_matid_guid16 1
scm_matid_guid22 scm_matid_guid22 1
scm_matlocid_guid16 scm_matlocid_guid16 1
sfepr sfepr 1
sfty_stk_meth sfty_stk_meth 1
sgt_chint sgt_chint 1
sgt_covs sgt_covs 1
sgt_covsa sgt_covsa 1
sgt_csgr sgt_csgr 1
sgt_mrpsi sgt_mrpsi 1
sgt_prcm sgt_prcm 1
sgt_rel sgt_rel 1
sgt_scope sgt_scope 1
sgt_stat sgt_stat 1
sgt_statc sgt_statc 1
shflg shflg 1
shpro shpro 1
shzet shzet 1
sobsl sobsl 1
stdpd stdpd 1
strgr strgr 1
takzt takzt 1
tranz tranz 1
umlmc umlmc 1
usequ usequ 1
webaz webaz 1
werks werks 1
wzeit wzeit 1

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.

-- View for reading master data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPH_E_MAT_CTRL_1 (
    ADSPC_SPC,
    AHDIS,
    ALTSL,
    APOKZ,
    ARUN_FIX_BATCH,
    ATTYP,
    AUSDT,
    AUSSS,
    BASMG,
    BEARZ,
    BERID,
    BERTY,
    BSTFE,
    BSTMA,
    BSTMI,
    BSTRF,
    CUOBF,
    CUOBJ,
    CUOBV,
    DISFG,
    DISLS,
    DISMM,
    DISPO,
    DISST,
    DZEIT,
    EISBE,
    FEVOR,
    FHORI,
    FSH_CALENDAR_GROUP,
    FSH_MG_ARUN_REQ,
    FSH_VAR_GROUP,
    GSAEN,
    IMATN,
    KZAUS,
    KZEFF,
    KZKFG,
    KZKUP,
    LAGPR,
    LFRHY,
    LGFSB,
    LGPRO,
    LOSFX,
    LVORM_MARA,
    LVORM_MARC,
    MAABC,
    MABST,
    MATKL,
    MATNR,
    MDACH,
    MEINS,
    MFRNR,
    MFRPN,
    MFXDT,
    MINBE,
    MISKZ,
    MMSTA,
    MMSTD,
    MPROF,
    MSTAE,
    MSTDE,
    MTART,
    NODISP,
    NUM_MDPS,
    NUM_RTO_HEADER,
    NUM_RTO_ITEM,
    PERIV,
    PERKZ,
    PICNUM,
    PLAN_IN_ABAP,
    PLIFZ,
    QMATV,
    RDPRF,
    RESAL,
    RESDT,
    RHYTD,
    RUEZT,
    RWPRO,
    SATNR,
    SAUFT,
    SBDKZ,
    SCM_MATID_GUID16,
    SCM_MATID_GUID22,
    SCM_MATLOCID_GUID16,
    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,
    SOBSL,
    STDPD,
    STRGR,
    TAKZT,
    TRANZ,
    UMLMC,
    USEQU,
    WEBAZ,
    WERKS,
    WZEIT
);