MPEV_CER_E_MAT

12 Fields 1 CDS Views

Generated Table for View

MPEV_CER_E_MAT is an SAP database table in S/4HANA. Generated Table for View. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MfgQualifnCertMatlAssgmtTP view from TRANSACTIONAL Certificate Material Asgn

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY mfgqualifncertificate MPE_CER_CERID Certification
KEY material MATNR Material
materialtype MTART Material Type
validityenddate MPE_CER_VALID_TO ValidTo
validitystartdate MPE_CER_VALID_FRM ValidFrom
mfgqualifnrequiredskilllevel MPE_CER_SL SkillLevel
plant WERKS_D Plant
creationdate TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangedate TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPEV_CER_E_MAT (
    CLIENT,                        -- Client [MANDT]
    MFGQUALIFNCERTIFICATE,         -- Certification [MPE_CER_CERID]
    MATERIAL,                      -- Material [MATNR]
    MATERIALTYPE,                  -- Material Type [MTART]
    VALIDITYENDDATE,               -- ValidTo [MPE_CER_VALID_TO]
    VALIDITYSTARTDATE,             -- ValidFrom [MPE_CER_VALID_FRM]
    MFGQUALIFNREQUIREDSKILLLEVEL,  -- SkillLevel [MPE_CER_SL]
    PLANT,                         -- Plant [WERKS_D]
    CREATIONDATE,                  -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                 -- User Name [UNAME]
    LASTCHANGEDATE,                -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,             -- User Name [UNAME]
    PRIMARY KEY (CLIENT, MFGQUALIFNCERTIFICATE, MATERIAL)
);

Learn More