P_CAPACITYDEFINITION

CDS View
26 Fields 4 CDS Views

Work Center Capacity Definition

P_CAPACITYDEFINITION is a CDS View in S/4HANA. Work Center Capacity Definition. It contains 26 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_CapacityWithNightShift view_entity from COMPOSITE Work Center Capacity With Night Shift
P_WorkCenterAvailableCapacity view inner COMPOSITE Total Available Capacity of Work Center
P_WrkCtrMntrSchedShift view_entity from CONSUMPTION Work Center Shifts
P_WrkCtrMntrSchedValidShift view_entity inner CONSUMPTION Work Center Valid Shifts

Fields (26)

KeyField CDS FieldsUsed in Views
KEY AvailableCapacityShift AvailableCapacityShift 4
KEY CapacityActiveVersion CapacityActiveVersion 4
KEY CapacityInternalID CapacityInternalID 2
KEY ValidityEndDate ValidityEndDate 3
KEY WeekDay WeekDay 1
AvailableCapacityIntervalDurn AvailableCapacityIntervalDurn 1
Capacity Capacity 1
CapacityBreakDuration CapacityBreakDuration 1
CapacityCategoryCode CapacityCategoryCode 2
CapacityCategoryName CapacityCategoryName 1
CapacityEndTime CapacityEndTime 1
CapacityNumberOfCapacities CapacityNumberOfCapacities 2
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 2
CapacityResponsiblePlanner CapacityResponsiblePlanner 1
CapacityStartTime CapacityStartTime 1
FactoryCalendar FactoryCalendar 3
Plant Plant,WorkCenterPlant 2
ShiftDefinition ShiftDefinition 1
ShiftEndDate ShiftEndDate 1
ShiftEndTime ShiftEndTime 3
ShiftGrouping ShiftGrouping 1
ShiftName ShiftName 1
ShiftStartDate ShiftStartDate 1
ShiftStartTime ShiftStartTime 3
ValidityBeginDate ValidityBeginDate 2
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.

-- Work Center Capacity Definition
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CAPACITYDEFINITION (
    AVAILABLECAPACITYSHIFT,
    CAPACITYACTIVEVERSION,
    CAPACITYINTERNALID,
    VALIDITYENDDATE,
    WEEKDAY,
    AVAILABLECAPACITYINTERVALDURN,
    CAPACITY,
    CAPACITYBREAKDURATION,
    CAPACITYCATEGORYCODE,
    CAPACITYCATEGORYNAME,
    CAPACITYENDTIME,
    CAPACITYNUMBEROFCAPACITIES,
    CAPACITYPLANUTILIZATIONPERCENT,
    CAPACITYRESPONSIBLEPLANNER,
    CAPACITYSTARTTIME,
    FACTORYCALENDAR,
    PLANT,
    SHIFTDEFINITION,
    SHIFTENDDATE,
    SHIFTENDTIME,
    SHIFTGROUPING,
    SHIFTNAME,
    SHIFTSTARTDATE,
    SHIFTSTARTTIME,
    VALIDITYBEGINDATE,
    WORKDAYRULE,
    PRIMARY KEY (AVAILABLECAPACITYSHIFT, CAPACITYACTIVEVERSION, CAPACITYINTERNALID, VALIDITYENDDATE, WEEKDAY)
);

Learn More