PPH_E_MAT_CTRL_1
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| pph_e_mat_ctrl | view | from | Read Material Data for MRP |
Fields (108)
| Key | Field | CDS Fields | Used 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
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA