I_WORKCENTERAVAILABLECAPACITY

CDS View
33 Fields 1 CDS Views

Total Available Capacity of Work Center

I_WORKCENTERAVAILABLECAPACITY is a CDS View in S/4HANA. Total Available Capacity of Work Center. It contains 33 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_WrkCtrAvailableCapacityTP view from TRANSACTIONAL Total Available Capacity of Work Center

Fields (33)

KeyField CDS FieldsUsed in Views
KEY AvailableCapacityShift AvailableCapacityShift 1
KEY CalendarDate CalendarDate 1
KEY CapacityActiveVersion CapacityActiveVersion 1
KEY CapacityCategoryAllocation CapacityCategoryAllocation 1
KEY CapacityInternalID CapacityInternalID 1
KEY ValidityEndDate ValidityEndDate 1
KEY WeekDay WeekDay 1
KEY WorkCenterInternalID WorkCenterInternalID 1
KEY WorkCenterTypeCode WorkCenterTypeCode 1
CalendarMonth CalendarMonth 1
CalendarWeek CalendarWeek 1
CalendarYear CalendarYear 1
CapacityBreakDuration CapacityBreakDuration 1
CapacityEndTime CapacityEndTime 1
CapacityNumberOfCapacities CapacityNumberOfCapacities 1
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 1
CapacityStartTime CapacityStartTime 1
FactoryCalendar FactoryCalendar 1
OperatingCapacityDurationInHrs OperatingCapacityDurationInHrs 1
ShiftDefinition ShiftDefinition 1
ShiftDefinitionName ShiftDefinitionName 1
ShiftEndDate ShiftEndDate 1
ShiftEndTime ShiftEndTime 1
ShiftGrouping ShiftGrouping 1
ShiftName ShiftName 1
ShiftStartDate ShiftStartDate 1
ShiftStartTime ShiftStartTime 1
TotOperatingDurationInHours TotOperatingDurationInHours 1
ValidityBeginDate ValidityBeginDate 1
WorkCenterCapacityUnit WorkCenterCapacityUnit 1
WorkCenterUtilizationUnit WorkCenterUtilizationUnit 1
WorkDayRule WorkDayRule 1
WorkDays WorkDays 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.

-- Total Available Capacity of Work Center
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKCENTERAVAILABLECAPACITY (
    AVAILABLECAPACITYSHIFT,
    CALENDARDATE,
    CAPACITYACTIVEVERSION,
    CAPACITYCATEGORYALLOCATION,
    CAPACITYINTERNALID,
    VALIDITYENDDATE,
    WEEKDAY,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    CALENDARMONTH,
    CALENDARWEEK,
    CALENDARYEAR,
    CAPACITYBREAKDURATION,
    CAPACITYENDTIME,
    CAPACITYNUMBEROFCAPACITIES,
    CAPACITYPLANUTILIZATIONPERCENT,
    CAPACITYSTARTTIME,
    FACTORYCALENDAR,
    OPERATINGCAPACITYDURATIONINHRS,
    SHIFTDEFINITION,
    SHIFTDEFINITIONNAME,
    SHIFTENDDATE,
    SHIFTENDTIME,
    SHIFTGROUPING,
    SHIFTNAME,
    SHIFTSTARTDATE,
    SHIFTSTARTTIME,
    TOTOPERATINGDURATIONINHOURS,
    VALIDITYBEGINDATE,
    WORKCENTERCAPACITYUNIT,
    WORKCENTERUTILIZATIONUNIT,
    WORKDAYRULE,
    WORKDAYS,
    PRIMARY KEY (AVAILABLECAPACITYSHIFT, CALENDARDATE, CAPACITYACTIVEVERSION, CAPACITYCATEGORYALLOCATION, CAPACITYINTERNALID, VALIDITYENDDATE, WEEKDAY, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More