I_WORKCENTERCAPACITYSHIFT_2

CDS View
22 Fields 5 CDS Views

Shifts of WorkCenter Capacity

I_WORKCENTERCAPACITYSHIFT_2 is a CDS View in S/4HANA. Shifts of WorkCenter Capacity. It contains 22 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
A_WorkCenterCapacityShift_2 view_entity from COMPOSITE Capacity Shift Version 2
I_CapacityShift view_entity from COMPOSITE Ent Resource Capacity Interval Shift
I_WorkCenterCapacityShift_3 view_entity from COMPOSITE Capacity Shift Version 3
R_MassMaintCapIntervalShiftTP view_entity inner TRANSACTIONAL capacity Interval Shift Data
R_WorkCenterPooledCapShiftTP view_entity from TRANSACTIONAL Work Center Pooled Capacity Shift

Fields (22)

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

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_2 (
    AVAILABLECAPACITYSHIFT,
    CAPACITYACTIVEVERSION,
    CAPACITYINTERNALID,
    INTERVALENDDATE,
    WEEKDAY,
    _AVAILABLECAPACITYTYPE,
    _CAPACITY,
    _ENDDATE,
    _WEEKDAY,
    CAPACITYBREAKDURATION,
    CAPACITYLASTCHANGEDATETIME,
    CAPACITYNUMBEROFCAPACITIES,
    CAPACITYPLANUTILIZATIONPERCENT,
    INTERVALSTARTDATE,
    OPERATINGDURATIONINSECONDS,
    SHIFTDEFINITION,
    SHIFTDEFVALIDITYENDDATE,
    SHIFTDEFVALIDITYSTARTDATE,
    SHIFTENDTIME,
    SHIFTSTARTTIME,
    TOTOPERATINGDURATIONINSECONDS,
    WORKDAYRULE,
    PRIMARY KEY (AVAILABLECAPACITYSHIFT, CAPACITYACTIVEVERSION, CAPACITYINTERNALID, INTERVALENDDATE, WEEKDAY)
);

Learn More