I_AVAILABLECAPACITYSHIFT

CDS View
14 Fields 4 CDS Views

Available Capacity Shift

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_RSHAvailableCapacityShift view from CONSUMPTION
P_RSHWCCapacityDefinition view left_outer CONSUMPTION Work Center Capacity Definition
P_WorkCenterCapacityDefinition view left_outer COMPOSITE
P_WrkCtrAvailableCapShift view from COMPOSITE

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