P_WORKCENTERAVAILABLECAPACITY

CDS View
18 Fields 1 CDS Views

P_WORKCENTERAVAILABLECAPACITY is a CDS View in S/4HANA. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_WorkCenterAvailableCapacity view from COMPOSITE Total Available Capacity of Work Center

Fields (18)

KeyField CDS FieldsUsed in Views
KEY CalendarDate CalendarDate 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
CapacityNumberOfCapacities CapacityNumberOfCapacities 1
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 1
FactoryCalendar FactoryCalendar 1
ShiftDefinition ShiftDefinition 1
ShiftGrouping ShiftGrouping 1
WorkCenterCapacityUnit WorkCenterCapacityUnit 1
WorkCenterUtilizationUnit WorkCenterUtilizationUnit 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_WORKCENTERAVAILABLECAPACITY (
    CALENDARDATE,
    CAPACITYCATEGORYALLOCATION,
    CAPACITYINTERNALID,
    VALIDITYENDDATE,
    WEEKDAY,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    CALENDARMONTH,
    CALENDARWEEK,
    CALENDARYEAR,
    CAPACITYNUMBEROFCAPACITIES,
    CAPACITYPLANUTILIZATIONPERCENT,
    FACTORYCALENDAR,
    SHIFTDEFINITION,
    SHIFTGROUPING,
    WORKCENTERCAPACITYUNIT,
    WORKCENTERUTILIZATIONUNIT,
    WORKDAYS,
    PRIMARY KEY (CALENDARDATE, CAPACITYCATEGORYALLOCATION, CAPACITYINTERNALID, VALIDITYENDDATE, WEEKDAY, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More