I_AVAILABLECAPACITYSHIFT

CDS View
14 Fields 5 CDS Views

Available Capacity Shift

I_AVAILABLECAPACITYSHIFT is a CDS View in S/4HANA. Available Capacity Shift. It contains 14 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
/VSCEW/A_WorkCenterShift view_entity from Workcenter shifts data
P_RSHAvailableCapacityShift view from CONSUMPTION Work Center Capacity Shifts
P_RSHWCCapacityDefinition view left_outer CONSUMPTION Work Center Capacity Definition
P_WorkCenterCapacityDefinition view left_outer COMPOSITE Work Center Capacity Definition
P_WrkCtrAvailableCapShift view_entity from COMPOSITE Work Center Available Capacity Shift

Fields (14)

KeyField CDS FieldsUsed in Views
KEY AvailableCapacityShift AvailableCapacityShift 1
KEY AvailableCapacityType AvailableCapacityType 1
KEY CapacityInternalID CapacityInternalID 1
KEY ValidityEndDate ShiftValidityEndDate,ValidityEndDate 2
KEY WeekDay WeekDay 1
BreakDurationInSeconds BreakDurationInSeconds 1
CapacityEndTimeID CapacityEndTimeID 1
CapacityNumberOfCapacities CapacityNumberOfCapacities 1
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 1
CapacityStartTimeID CapacityStartTimeID 1
OperatingDurationInSeconds OperatingDurationInSeconds 1
ShiftDefinition ShiftDefinition 1
TotOperatingDurationInSeconds TotOperatingDurationInSeconds 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.

-- Available Capacity Shift
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_AVAILABLECAPACITYSHIFT (
    AVAILABLECAPACITYSHIFT,
    AVAILABLECAPACITYTYPE,
    CAPACITYINTERNALID,
    VALIDITYENDDATE,
    WEEKDAY,
    BREAKDURATIONINSECONDS,
    CAPACITYENDTIMEID,
    CAPACITYNUMBEROFCAPACITIES,
    CAPACITYPLANUTILIZATIONPERCENT,
    CAPACITYSTARTTIMEID,
    OPERATINGDURATIONINSECONDS,
    SHIFTDEFINITION,
    TOTOPERATINGDURATIONINSECONDS,
    WORKDAYRULE,
    PRIMARY KEY (AVAILABLECAPACITYSHIFT, AVAILABLECAPACITYTYPE, CAPACITYINTERNALID, VALIDITYENDDATE, WEEKDAY)
);

Learn More