I_WORKCENTERCAPACITYSHIFT_3

CDS View
25 Fields 2 CDS Views

Capacity Shift Version 3

I_WORKCENTERCAPACITYSHIFT_3 is a CDS View in S/4HANA. Capacity Shift Version 3. It contains 25 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_WorkCenterCapacityShift_4 view_entity from COMPOSITE Work Center Capacity Shift Details
R_WorkCenterCapacityShiftTP view_entity from TRANSACTIONAL Capacity Shift

Fields (25)

KeyField CDS FieldsUsed in Views
KEY AvailableCapacityShift AvailableCapacityShift 1
KEY CapacityActiveVersion CapacityActiveVersion 2
KEY CapacityCategoryAllocation CapacityCategoryAllocation 1
KEY CapacityInternalID CapacityInternalID 2
KEY IntervalEndDate IntervalEndDate 2
KEY WeekDay WeekDay 2
KEY WorkCenterInternalID WorkCenterInternalID 1
KEY WorkCenterTypeCode WorkCenterTypeCode 1
_AvailableCapacityType _AvailableCapacityType 1
_Capacity _Capacity 1
_EndDate _EndDate 1
_WeekDay _WeekDay 1
CapacityBreakDuration CapacityBreakDuration 2
CapacityLastChangeDateTime CapacityLastChangeDateTime 2
CapacityNumberOfCapacities CapacityNumberOfCapacities 2
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 2
IntervalStartDate IntervalStartDate 2
OperatingDurationInSeconds OperatingDurationInSeconds 2
ShiftDefinition ShiftDefinition 2
ShiftDefValidityEndDate ShiftDefValidityEndDate 2
ShiftDefValidityStartDate ShiftDefValidityStartDate 2
ShiftEndTime ShiftEndTime 2
ShiftStartTime ShiftStartTime 2
TotOperatingDurationInSeconds TotOperatingDurationInSeconds 2
WorkDayRule WorkDayRule 2

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.

-- Capacity Shift Version 3
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKCENTERCAPACITYSHIFT_3 (
    AVAILABLECAPACITYSHIFT,
    CAPACITYACTIVEVERSION,
    CAPACITYCATEGORYALLOCATION,
    CAPACITYINTERNALID,
    INTERVALENDDATE,
    WEEKDAY,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    _AVAILABLECAPACITYTYPE,
    _CAPACITY,
    _ENDDATE,
    _WEEKDAY,
    CAPACITYBREAKDURATION,
    CAPACITYLASTCHANGEDATETIME,
    CAPACITYNUMBEROFCAPACITIES,
    CAPACITYPLANUTILIZATIONPERCENT,
    INTERVALSTARTDATE,
    OPERATINGDURATIONINSECONDS,
    SHIFTDEFINITION,
    SHIFTDEFVALIDITYENDDATE,
    SHIFTDEFVALIDITYSTARTDATE,
    SHIFTENDTIME,
    SHIFTSTARTTIME,
    TOTOPERATINGDURATIONINSECONDS,
    WORKDAYRULE,
    PRIMARY KEY (AVAILABLECAPACITYSHIFT, CAPACITYACTIVEVERSION, CAPACITYCATEGORYALLOCATION, CAPACITYINTERNALID, INTERVALENDDATE, WEEKDAY, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More