_WORKCENTER

27 Fields

_WORKCENTER is an SAP database table in S/4HANA. It contains 27 fields.

Fields (27)

KeyField CDS FieldsUsed in Views
KEY Plant DefaultPlant,MaintenanceWorkCenterPlant,MainWorkCenterPlant,Plant,WorkCenterPlant 41
KEY WorkCenter DefaultWorkCenter,MaintenanceWorkCenter,MaintWorkCenter,MainWorkCenter,OperationWorkCenter,PLANNINGWORKCENTER,WorkCenter 91
KEY WorkCenterInternalID WorkCenterInternalID 10
KEY WorkCenterTypeCode WorkCenterTypeCode 8
_Plant _Plant,_WorkCenterPlant 8
_SupplyArea _SupplyArea 1
_WorkCenter _WorkCenter 2
_WorkCenterCategory _WorkCenterCategory 2
_WorkCenterLocation _WorkCenterLocation 1
_WorkCenterResponsible _WorkCenterResponsible 1
_WorkCenterTextBySemanticKey _WorkCenterTextBySemanticKey 1
_WorkCenterUsage _WorkCenterUsage 2
AdvancedPlanningIsSupported AdvancedPlanningIsSupported 1
CapacityCategoryName CapacityCategoryName 3
CapacityInternalID CapacityInternalID 4
PlantName PlantName 1
PMRPWorkCenterText PMRPWorkCenterText 4
StandardWorkFormulaParamGroup StandardWorkFormulaParamGroup 1
SupplyArea SupplyArea 3
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 1
WorkCenterCategoryCode WorkCenterCategoryCode 20
WorkCenterIsToBeDeleted WorkCenterIsToBeDeleted 1
WorkCenterLocation WorkCenterLocation 3
WorkCenterResponsible WorkCenterResponsible 10
WorkCenterText WorkCenterText 1
WorkCenterUsage WorkCenterUsage 3

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 _WORKCENTER (
    PLANT,
    WORKCENTER,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    _PLANT,
    _SUPPLYAREA,
    _WORKCENTER,
    _WORKCENTERCATEGORY,
    _WORKCENTERLOCATION,
    _WORKCENTERRESPONSIBLE,
    _WORKCENTERTEXTBYSEMANTICKEY,
    _WORKCENTERUSAGE,
    ADVANCEDPLANNINGISSUPPORTED,
    CAPACITYCATEGORYNAME,
    CAPACITYINTERNALID,
    PLANTNAME,
    PMRPWORKCENTERTEXT,
    STANDARDWORKFORMULAPARAMGROUP,
    SUPPLYAREA,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    WORKCENTERCATEGORYCODE,
    WORKCENTERISTOBEDELETED,
    WORKCENTERLOCATION,
    WORKCENTERRESPONSIBLE,
    WORKCENTERTEXT,
    WORKCENTERUSAGE,
    PRIMARY KEY (PLANT, WORKCENTER, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More