CAPACITYPERDAY

9 Fields

CAPACITYPERDAY is an SAP database table in S/4HANA. It contains 9 fields.

Fields (9)

KeyField CDS FieldsUsed in Views
KEY CalendarDate CalendarDate 2
KEY CapacityInternalID CapacityInternalID 4
KEY CapacityStartTime CapacityStartTime 2
KEY MaintenanceOrder MaintenanceOrder 2
KEY MaintenanceOrderOperation MaintenanceOrderOperation 2
KEY MaintenanceOrderSubOperation MaintenanceOrderSubOperation 2
KEY WeekDay WeekDay 1
KEY WorkCenterInternalID WorkCenterInternalID 1
KEY WorkCenterTypeCode WorkCenterTypeCode 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 CAPACITYPERDAY (
    CALENDARDATE,
    CAPACITYINTERNALID,
    CAPACITYSTARTTIME,
    MAINTENANCEORDER,
    MAINTENANCEORDEROPERATION,
    MAINTENANCEORDERSUBOPERATION,
    WEEKDAY,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (CALENDARDATE, CAPACITYINTERNALID, CAPACITYSTARTTIME, MAINTENANCEORDER, MAINTENANCEORDEROPERATION, MAINTENANCEORDERSUBOPERATION, WEEKDAY, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More