I_WORKCENTERCAPACITYSHIFT

CDS View
21 Fields 1 CDS Views

Shifts of WorkCenter Capacity

I_WORKCENTERCAPACITYSHIFT is a CDS View in S/4HANA. Shifts of WorkCenter Capacity. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_WorkCenterCapacityShift view from COMPOSITE Capacity Shift

Fields (21)

KeyField CDS FieldsUsed in Views
KEY AvailableCapacityShift AvailableCapacityShift 1
KEY CapacityActiveVersion CapacityActiveVersion 1
KEY CapacityCategoryAllocation CapacityCategoryAllocation 1
KEY CapacityInternalID CapacityInternalID 1
KEY IntervalEndDate IntervalEndDate 1
KEY WeekDay WeekDay 1
KEY WorkCenterInternalID WorkCenterInternalID 1
KEY WorkCenterTypeCode WorkCenterTypeCode 1
CapacityBreakDuration CapacityBreakDuration 1
CapacityNumberOfCapacities CapacityNumberOfCapacities 1
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 1
IntervalStartDate IntervalStartDate 1
Plant Plant 1
ShiftDefValidityEnd ShiftDefValidityEnd 1
ShiftDefValidityStart ShiftDefValidityStart 1
ShiftEndTime ShiftEndTime 1
ShiftName ShiftName 1
ShiftStartTime ShiftStartTime 1
TotOperatingDurationInHours TotOperatingDurationInHours 1
TotOperationDurationUnit TotOperationDurationUnit 1
WorkCenter WorkCenter 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.

-- Shifts of WorkCenter Capacity
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKCENTERCAPACITYSHIFT (
    AVAILABLECAPACITYSHIFT,
    CAPACITYACTIVEVERSION,
    CAPACITYCATEGORYALLOCATION,
    CAPACITYINTERNALID,
    INTERVALENDDATE,
    WEEKDAY,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    CAPACITYBREAKDURATION,
    CAPACITYNUMBEROFCAPACITIES,
    CAPACITYPLANUTILIZATIONPERCENT,
    INTERVALSTARTDATE,
    PLANT,
    SHIFTDEFVALIDITYEND,
    SHIFTDEFVALIDITYSTART,
    SHIFTENDTIME,
    SHIFTNAME,
    SHIFTSTARTTIME,
    TOTOPERATINGDURATIONINHOURS,
    TOTOPERATIONDURATIONUNIT,
    WORKCENTER,
    PRIMARY KEY (AVAILABLECAPACITYSHIFT, CAPACITYACTIVEVERSION, CAPACITYCATEGORYALLOCATION, CAPACITYINTERNALID, INTERVALENDDATE, WEEKDAY, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More