_WRKCTR

_WRKCTR is an SAP database table in S/4HANA. It contains 16 fields.

Fields (16)

KeyField CDS FieldsUsed in Views
KEY WorkCenterInternalID WorkCenterInternalID 3
KEY WorkCenterTypeCode WorkCenterTypeCode 2
OperationControlProfile OperationControlProfile 1
Plant Plant 1
ShiftNoteType ShiftNoteType 1
ShiftReportType ShiftReportType 1
StandardWorkFormulaParamGroup StandardWorkFormulaParamGroup 1
SupplyArea SupplyArea 1
WorkCenter WorkCenter 1
WorkCenterCategoryCode WorkCenterCategoryCode 2
WorkCenterDesc WorkCenterDesc 1
WorkCenterLastChangeDateTime WorkCenterLastChangeDateTime 1
WorkCenterLocation WorkCenterLocation 1
WorkCenterResponsible WorkCenterResponsible 2
WorkCenterResponsibleName WorkCenterResponsibleName 1
WorkCenterUsage WorkCenterUsage 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _WRKCTR (
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    OPERATIONCONTROLPROFILE,
    PLANT,
    SHIFTNOTETYPE,
    SHIFTREPORTTYPE,
    STANDARDWORKFORMULAPARAMGROUP,
    SUPPLYAREA,
    WORKCENTER,
    WORKCENTERCATEGORYCODE,
    WORKCENTERDESC,
    WORKCENTERLASTCHANGEDATETIME,
    WORKCENTERLOCATION,
    WORKCENTERRESPONSIBLE,
    WORKCENTERRESPONSIBLENAME,
    WORKCENTERUSAGE,
    PRIMARY KEY (WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);