P_WORKCENTERCAPACITYDEFINITION

CDS View
28 Fields 2 CDS Views

P_WORKCENTERCAPACITYDEFINITION is a CDS View in S/4HANA. It contains 28 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_WorkCenterCapacityShift view from COMPOSITE Shifts of WorkCenter Capacity
P_WorkCtrCapWithNightShift view from COMPOSITE

Fields (28)

KeyField CDS FieldsUsed in Views
KEY AvailableCapacityShift AvailableCapacityShift 2
KEY CapacityActiveVersion CapacityActiveVersion 2
KEY CapacityCategoryAllocation CapacityCategoryAllocation 2
KEY CapacityInternalID CapacityInternalID 2
KEY ValidityEndDate IntervalEndDate 1
KEY WeekDay WeekDay 1
KEY WorkCenterInternalID WorkCenterInternalID 2
KEY WorkCenterTypeCode WorkCenterTypeCode 2
Capacity Capacity 1
CapacityBreakDuration CapacityBreakDuration 2
CapacityCategoryCode CapacityCategoryCode 1
CapacityCategoryName CapacityCategoryName 1
CapacityNumberOfCapacities CapacityNumberOfCapacities 2
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 2
CapacityResponsiblePlanner CapacityResponsiblePlanner 1
FactoryCalendar FactoryCalendar 1
Plant Plant 2
ShiftEndDate ShiftDefValidityEnd 1
ShiftEndTime ShiftEndTime 1
ShiftName ShiftName 2
ShiftStartDate ShiftDefValidityStart 1
ShiftStartTime ShiftStartTime 1
ValidityBeginDate IntervalStartDate 1
WorkCenter WorkCenter 2
WorkCenterCategoryCode WorkCenterCategoryCode 1
WorkCenterDesc WorkCenterDesc 1
WorkCenterResponsible WorkCenterResponsible 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_WORKCENTERCAPACITYDEFINITION (
    AVAILABLECAPACITYSHIFT,
    CAPACITYACTIVEVERSION,
    CAPACITYCATEGORYALLOCATION,
    CAPACITYINTERNALID,
    VALIDITYENDDATE,
    WEEKDAY,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    CAPACITY,
    CAPACITYBREAKDURATION,
    CAPACITYCATEGORYCODE,
    CAPACITYCATEGORYNAME,
    CAPACITYNUMBEROFCAPACITIES,
    CAPACITYPLANUTILIZATIONPERCENT,
    CAPACITYRESPONSIBLEPLANNER,
    FACTORYCALENDAR,
    PLANT,
    SHIFTENDDATE,
    SHIFTENDTIME,
    SHIFTNAME,
    SHIFTSTARTDATE,
    SHIFTSTARTTIME,
    VALIDITYBEGINDATE,
    WORKCENTER,
    WORKCENTERCATEGORYCODE,
    WORKCENTERDESC,
    WORKCENTERRESPONSIBLE,
    WORKDAYRULE,
    PRIMARY KEY (AVAILABLECAPACITYSHIFT, CAPACITYACTIVEVERSION, CAPACITYCATEGORYALLOCATION, CAPACITYINTERNALID, VALIDITYENDDATE, WEEKDAY, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More