CAPACITYPERDAY

22 Fields

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

Fields (22)

KeyField CDS FieldsUsed in Views
KEY CalendarDate CalendarDate 5
KEY CapacityInternalID CapacityInternalID 7
KEY CapacityStartTime CapacityStartTime 5
KEY MaintenanceOrder MaintenanceOrder 2
KEY MaintenanceOrderOperation MaintenanceOrderOperation 2
KEY MaintenanceOrderSubOperation MaintenanceOrderSubOperation 2
KEY WeekDay WeekDay 2
KEY WorkCenterInternalID WorkCenterInternalID 4
KEY WorkCenterTypeCode WorkCenterTypeCode 4
AvailableCapacityIntervalDurn AvailableCapacityIntervalDurn 1
AvailableCapacityShift AvailableCapacityShift 1
CapacityBreakDuration CapacityBreakDuration 1
CapacityEndTime CapacityEndTime 1
CapacityNumberOfCapacities CapacityNumberOfCapacities 1
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 1
FactoryCalendar FactoryCalendar 1
NightSplitDate NightSplitDate 1
Plant Plant 1
WorkCenter WorkCenter 1
WorkCenterCategoryCode WorkCenterCategoryCode 1
WorkDayRule WorkDayRule 1
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 CAPACITYPERDAY (
    CALENDARDATE,
    CAPACITYINTERNALID,
    CAPACITYSTARTTIME,
    MAINTENANCEORDER,
    MAINTENANCEORDEROPERATION,
    MAINTENANCEORDERSUBOPERATION,
    WEEKDAY,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    AVAILABLECAPACITYINTERVALDURN,
    AVAILABLECAPACITYSHIFT,
    CAPACITYBREAKDURATION,
    CAPACITYENDTIME,
    CAPACITYNUMBEROFCAPACITIES,
    CAPACITYPLANUTILIZATIONPERCENT,
    FACTORYCALENDAR,
    NIGHTSPLITDATE,
    PLANT,
    WORKCENTER,
    WORKCENTERCATEGORYCODE,
    WORKDAYRULE,
    YEARWEEK,
    PRIMARY KEY (CALENDARDATE, CAPACITYINTERNALID, CAPACITYSTARTTIME, MAINTENANCEORDER, MAINTENANCEORDEROPERATION, MAINTENANCEORDERSUBOPERATION, WEEKDAY, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More