MPE_QUAL_E_MAT

Transparent Table Application Table
8 Fields 2 CDS Views

Material Assignment

MPE_QUAL_E_MAT is an SAP database table in S/4HANA. Material Assignment. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MfgQualifnMaterialAssgmt view from BASIC Material Assignment
I_MfgQualifnMaterialAssgmtBsc view from BASIC Qualification Material Assignment

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY mfghumanresourcequalification hrobjid Object ID
KEY material matnr Material
plant werks_d Plant
materialtype mtart Material Type
enddate enddatum End Date
creationdate begdatum Start date
mfgqualifnrequiredskilllevel rating Proficiency

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.

-- Material Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_QUAL_E_MAT (
    CLIENT,                         -- Client [mandt]
    MFGHUMANRESOURCEQUALIFICATION,  -- Object ID [hrobjid]
    MATERIAL,                       -- Material [matnr]
    PLANT,                          -- Plant [werks_d]
    MATERIALTYPE,                   -- Material Type [mtart]
    ENDDATE,                        -- End Date [enddatum]
    CREATIONDATE,                   -- Start date [begdatum]
    MFGQUALIFNREQUIREDSKILLLEVEL,   -- Proficiency [rating]
    PRIMARY KEY (CLIENT, MFGHUMANRESOURCEQUALIFICATION, MATERIAL)
);

Learn More