I_MFGWORKINSTRUCTION

CDS View
9 Fields 4 CDS Views

Work Instruction Basic View

I_MFGWORKINSTRUCTION is a CDS View in S/4HANA. Work Instruction Basic View. It contains 9 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_OpActyInstcPlndWrkInstrnVers view_entity inner CONSUMPTION WI for Plan Data application
C_SFOOpActyWorkInstructionVers view_entity inner CONSUMPTION WI for Order Genealogy
I_MfgWorkInstructionTP view from TRANSACTIONAL Work Instruction Transactional View
I_OpActyWorkInstructionTP view from TRANSACTIONAL Embedded WI: Root

Fields (9)

KeyField CDS FieldsUsed in Views
KEY MfgWorkInstruction MfgWorkInstruction 2
KEY MfgWorkInstructionVersCounter MfgWorkInstructionVersCounter 2
CreationTime CreationTime 1
CreationUserName CreationUserName 2
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
MfgWorkInstructionForEdit MfgWorkInstructionForEdit 1
MfgWorkInstructionRelease MfgWorkInstructionRelease 1
MfgWorkInstructionStatus MfgWorkInstructionStatus 2

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 Instruction Basic View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGWORKINSTRUCTION (
    MFGWORKINSTRUCTION,
    MFGWORKINSTRUCTIONVERSCOUNTER,
    CREATIONTIME,
    CREATIONUSERNAME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MFGWORKINSTRUCTIONFOREDIT,
    MFGWORKINSTRUCTIONRELEASE,
    MFGWORKINSTRUCTIONSTATUS,
    PRIMARY KEY (MFGWORKINSTRUCTION, MFGWORKINSTRUCTIONVERSCOUNTER)
);

Learn More