I_MFGQUALIFNCERTWRKCTRASSGMTTP

CDS View

Mfg Qualifn Cert Work Centre Assignment

I_MFGQUALIFNCERTWRKCTRASSGMTTP is a CDS View in S/4HANA. Mfg Qualifn Cert Work Centre Assignment. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MfgQualifnCertWrkCtrAssgmt view from CONSUMPTION Certificate Work Centre Assignment

Fields (8)

KeyField CDS FieldsUsed in Views
KEY MfgQualifnCertificate MfgQualifnCertificate 1
KEY WorkCenterInternalID WorkCenterInternalID 1
KEY WorkCenterTypeCode WorkCenterTypeCode 1
MfgQualifnRequiredSkillLevel MfgQualifnRequiredSkillLevel 1
Plant Plant 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 1
WorkCenter WorkCenter 1

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.

-- Mfg Qualifn Cert Work Centre Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGQUALIFNCERTWRKCTRASSGMTTP (
    MFGQUALIFNCERTIFICATE,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    MFGQUALIFNREQUIREDSKILLLEVEL,
    PLANT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    WORKCENTER,
    PRIMARY KEY (MFGQUALIFNCERTIFICATE, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);