MPE_USER_WC

Transparent Table Application Table
7 Fields 1 CDS Views

Work Centers assigned to a Manufacturing User

MPE_USER_WC is an SAP database table in S/4HANA. Work Centers assigned to a Manufacturing User. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MfgBPWorkCenterAssgmt view_entity from BASIC Work center assignment to mfg user

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY partner mpe_user_id Bus Part
KEY workcenter arbpl Work Center
KEY plant werks_d Plant
validitystartdate mpe_user_valid_from Valid From
validityenddate mpe_user_valid_to Valid To
isdefaultmfgwrkctr mpe_default_flag Default

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.

-- Work Centers assigned to a Manufacturing User
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_USER_WC (
    CLIENT,              -- Client [mandt]
    PARTNER,             -- Bus Part [mpe_user_id]
    WORKCENTER,          -- Work Center [arbpl]
    PLANT,               -- Plant [werks_d]
    VALIDITYSTARTDATE,   -- Valid From [mpe_user_valid_from]
    VALIDITYENDDATE,     -- Valid To [mpe_user_valid_to]
    ISDEFAULTMFGWRKCTR,  -- Default [mpe_default_flag]
    PRIMARY KEY (CLIENT, PARTNER, WORKCENTER, PLANT)
);

Learn More