P_RSHWCCAPACITYDEFINITIO_CACHE

CDS View
12 Fields 1 CDS Views

Work Center Capacity Definition

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RSHWCCapacityWithNight_Cache view from CONSUMPTION WC Capacity from day and night shifts

Fields (12)

KeyField CDS FieldsUsed in Views
KEY AvailableCapacityShift AvailableCapacityShift 1
KEY CapacityInternalID CapacityInternalID 1
AvailableCapacityIntervalDurn AvailableCapacityIntervalDurn 1
CapacityNumberOfCapacities CapacityNumberOfCapacities 1
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 1
FactoryCalendar FactoryCalendar 1
Plant Plant 1
WorkCenter WorkCenter 1
WorkCenterCategoryCode WorkCenterCategoryCode 1
WorkCenterInternalID WorkCenterInternalID 1
WorkCenterTypeCode WorkCenterTypeCode 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.

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

Learn More