MPE_QUAL_E_WC

Transparent Table Application Table
7 Fields 1 CDS Views

Work Centre Assignment

MPE_QUAL_E_WC is an SAP database table in S/4HANA. Work Centre Assignment. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MfgQualifnWrkCtrAssgmtBasic view from BASIC Qualification Work Center Assignment

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY mfghumanresourcequalification hrobjid Object ID
KEY workcentertypecode cr_objty Object Type
KEY workcenterinternalid cr_objid Object ID
creationdate begdatum Start date
enddate enddatum End 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.

-- Work Centre Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_QUAL_E_WC (
    CLIENT,                         -- Client [mandt]
    MFGHUMANRESOURCEQUALIFICATION,  -- Object ID [hrobjid]
    WORKCENTERTYPECODE,             -- Object Type [cr_objty]
    WORKCENTERINTERNALID,           -- Object ID [cr_objid]
    CREATIONDATE,                   -- Start date [begdatum]
    ENDDATE,                        -- End Date [enddatum]
    MFGQUALIFNREQUIREDSKILLLEVEL,   -- Proficiency [rating]
    PRIMARY KEY (CLIENT, MFGHUMANRESOURCEQUALIFICATION, WORKCENTERTYPECODE, WORKCENTERINTERNALID)
);

Learn More