P_RSHWCCAPACITYDEFINITION

CDS View
18 Fields 3 CDS Views

Work Center Capacity Definition

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

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_RSHWCCapacityWithNights view from CONSUMPTION WC Capacity from day and night shifts
P_RSHWCCapDefWithShiftTime view_entity from CONSUMPTION Work Center Capacity Definition with shift times
P_RSHWorkCenterCapacityChange view from CONSUMPTION Work Center Capacity Change

Fields (18)

KeyField CDS FieldsUsed in Views
KEY AvailableCapacityShift AvailableCapacityShift 1
KEY CapacityActiveVersion CapacityActiveVersion 1
KEY CapacityInternalID CapacityInternalID 2
KEY CapacityStartTime CapacityStartTime 1
KEY WorkCenter WorkCenter 2
KEY WorkCenterInternalID WorkCenterInternalID 2
AvailableCapacityIntervalDurn AvailableCapacityIntervalDurn 1
CapacityBreakDuration CapacityBreakDuration 1
CapacityEndTime CapacityEndTime 1
CapacityNumberOfCapacities CapacityNumberOfCapacities 2
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 2
FactoryCalendar FactoryCalendar 2
Plant Plant 2
ShiftDefinition ShiftDefinition 1
ShiftDefinitionName ShiftDefinitionName 1
WorkCenterCategoryCode WorkCenterCategoryCode 2
WorkCenterTypeCode WorkCenterTypeCode 2
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.

-- Work Center Capacity Definition
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RSHWCCAPACITYDEFINITION (
    AVAILABLECAPACITYSHIFT,
    CAPACITYACTIVEVERSION,
    CAPACITYINTERNALID,
    CAPACITYSTARTTIME,
    WORKCENTER,
    WORKCENTERINTERNALID,
    AVAILABLECAPACITYINTERVALDURN,
    CAPACITYBREAKDURATION,
    CAPACITYENDTIME,
    CAPACITYNUMBEROFCAPACITIES,
    CAPACITYPLANUTILIZATIONPERCENT,
    FACTORYCALENDAR,
    PLANT,
    SHIFTDEFINITION,
    SHIFTDEFINITIONNAME,
    WORKCENTERCATEGORYCODE,
    WORKCENTERTYPECODE,
    WORKDAYRULE,
    PRIMARY KEY (AVAILABLECAPACITYSHIFT, CAPACITYACTIVEVERSION, CAPACITYINTERNALID, CAPACITYSTARTTIME, WORKCENTER, WORKCENTERINTERNALID)
);

Learn More