I_MFGQUALIFNWRKCTRASSGMTTP

CDS View
10 Fields 1 CDS Views

Transactional View for Work Center Assignment

I_MFGQUALIFNWRKCTRASSGMTTP is a CDS View in S/4HANA. Transactional View for Work Center Assignment. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MfgQualifnWrkCtrAssgmtTP view from CONSUMPTION Consumption View for Work Center Assignment

Fields (10)

KeyField CDS FieldsUsed in Views
KEY MfgHumanResourceQualification MfgHumanResourceQualification 1
KEY WorkCenterInternalID WorkCenterInternalID 1
KEY WorkCenterTypeCode WorkCenterTypeCode 1
CreationDate CreationDate 1
EndDate EndDate 1
MfgHumanRsceQualifnGroupOrCtlg MfgHumanRsceQualifnGroupOrCtlg 1
MfgQualifnRequiredSkillLevel MfgQualifnRequiredSkillLevel 1
MfgQualifnRqdSkillLevelDesc MfgQualifnRqdSkillLevelDesc 1
Plant Plant 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.

-- Transactional View for Work Center Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGQUALIFNWRKCTRASSGMTTP (
    MFGHUMANRESOURCEQUALIFICATION,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    CREATIONDATE,
    ENDDATE,
    MFGHUMANRSCEQUALIFNGROUPORCTLG,
    MFGQUALIFNREQUIREDSKILLLEVEL,
    MFGQUALIFNRQDSKILLLEVELDESC,
    PLANT,
    WORKCENTER,
    PRIMARY KEY (MFGHUMANRESOURCEQUALIFICATION, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More