WORKCENTERCAPACITY

25 Fields

WORKCENTERCAPACITY is an SAP database table in S/4HANA. It contains 25 fields.

Fields (25)

KeyField CDS FieldsUsed in Views
KEY CalendarDate CalendarDate 1
KEY CapacityCategoryAllocation CapacityCategoryAllocation 2
KEY CapacityInternalID CapacityInternalID 5
KEY CapacityStartTime CapacityStartTime 2
KEY WorkCenterInternalID WorkCenterInternalID 5
KEY WorkCenterTypeCode WorkCenterTypeCode 5
AvailableCapacityIntervalDurn AvailableCapacityIntervalDurn 1
AvailableCapacityShift AvailableCapacityShift 1
CapacityEndTime CapacityEndTime 1
CapacityNumberOfCapacities CapacityNumberOfCapacities 1
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 1
FactoryCalendar FactoryCalendar 1
MachineType MachineType 1
NightSplitDate NightSplitDate 1
OperatingDurationInSeconds OperatingDurationInSeconds 1
Plant Plant 5
SupplyArea SupplyArea 1
TotOperatingDurationInSeconds TotOperatingDurationInSeconds 2
ValidityBeginDate ValidityBeginDate 1
ValidityEndDate ValidityEndDate 2
WorkCenter WorkCenter 5
WorkCenterCategoryCode WorkCenterCategoryCode 4
WorkCenterLocation WorkCenterLocation 1
WorkCenterResponsible WorkCenterResponsible 1
WorkDayRule WorkDayRule 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 WORKCENTERCAPACITY (
    CALENDARDATE,
    CAPACITYCATEGORYALLOCATION,
    CAPACITYINTERNALID,
    CAPACITYSTARTTIME,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    AVAILABLECAPACITYINTERVALDURN,
    AVAILABLECAPACITYSHIFT,
    CAPACITYENDTIME,
    CAPACITYNUMBEROFCAPACITIES,
    CAPACITYPLANUTILIZATIONPERCENT,
    FACTORYCALENDAR,
    MACHINETYPE,
    NIGHTSPLITDATE,
    OPERATINGDURATIONINSECONDS,
    PLANT,
    SUPPLYAREA,
    TOTOPERATINGDURATIONINSECONDS,
    VALIDITYBEGINDATE,
    VALIDITYENDDATE,
    WORKCENTER,
    WORKCENTERCATEGORYCODE,
    WORKCENTERLOCATION,
    WORKCENTERRESPONSIBLE,
    WORKDAYRULE,
    PRIMARY KEY (CALENDARDATE, CAPACITYCATEGORYALLOCATION, CAPACITYINTERNALID, CAPACITYSTARTTIME, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More