MPEV_USR_PROFILE

8 Fields 1 CDS Views

Generated Table for View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_MfgBusinessPartner view from BASIC

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY mfgbusinesspartner MPE_USER_ID Bus Part
workcenter MPE_WORK_CENTER Def Work Center
plant MPE_PLANT Default Plant
createdbyuser MPE_CREATE_USER Created By
creationdatetime MPE_CREATE_TIMESTAMP Created On
lastchangedbyuser MPE_LCHANGE_USER Changed By
lastchangedatetime MPE_LCHANGE_TIMESTAMP Changed On

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_USR_PROFILE (
    MANDT,               -- Client [MANDT]
    MFGBUSINESSPARTNER,  -- Bus Part [MPE_USER_ID]
    WORKCENTER,          -- Def Work Center [MPE_WORK_CENTER]
    PLANT,               -- Default Plant [MPE_PLANT]
    CREATEDBYUSER,       -- Created By [MPE_CREATE_USER]
    CREATIONDATETIME,    -- Created On [MPE_CREATE_TIMESTAMP]
    LASTCHANGEDBYUSER,   -- Changed By [MPE_LCHANGE_USER]
    LASTCHANGEDATETIME,  -- Changed On [MPE_LCHANGE_TIMESTAMP]
    PRIMARY KEY (MANDT, MFGBUSINESSPARTNER)
);

Learn More