WORKDAYS

17 Fields

WORKDAYS is an SAP database table in S/4HANA. It contains 17 fields.

Fields (17)

KeyField CDS FieldsUsed in Views
KEY CalendarDate CalendarDate 5
KEY CapacityCategoryAllocation CapacityCategoryAllocation 1
KEY CapacityInternalID CapacityInternalID 1
KEY WorkCenterInternalID WorkCenterInternalID 1
KEY WorkCenterTypeCode WorkCenterTypeCode 1
CalendarMonth CalendarMonth 4
CalendarWeek CalendarWeek 4
CalendarYear CalendarYear 4
Capacity Capacity 1
CapacityCategoryCode CapacityCategoryCode 1
CapacityResponsiblePlanner CapacityResponsiblePlanner 1
Plant Plant 1
WorkCenter WorkCenter 1
WorkCenterCategoryCode WorkCenterCategoryCode 1
WorkCenterResponsible WorkCenterResponsible 1
WorkDays WorkDays 2
YearWeek YearWeek 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 WORKDAYS (
    CALENDARDATE,
    CAPACITYCATEGORYALLOCATION,
    CAPACITYINTERNALID,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    CALENDARMONTH,
    CALENDARWEEK,
    CALENDARYEAR,
    CAPACITY,
    CAPACITYCATEGORYCODE,
    CAPACITYRESPONSIBLEPLANNER,
    PLANT,
    WORKCENTER,
    WORKCENTERCATEGORYCODE,
    WORKCENTERRESPONSIBLE,
    WORKDAYS,
    YEARWEEK,
    PRIMARY KEY (CALENDARDATE, CAPACITYCATEGORYALLOCATION, CAPACITYINTERNALID, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More