P_RSHWCCAPACITYPERDAY

CDS View
6 Fields 4 CDS Views

P_RSHWCCAPACITYPERDAY is a CDS View in S/4HANA. It contains 6 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_RSHOrderGanttNonWrkgTmeIntvl view from CONSUMPTION
P_RSHWCCapacityPerWorkDay view from CONSUMPTION
P_RSHWorkCenterNonWrkgTmeIntvl view from CONSUMPTION Non working interval for the work center
P_RSHWorkCenterWrkgTmeIntvl view from CONSUMPTION Working Interval for the work center is returned

Fields (6)

KeyField CDS FieldsUsed in Views
KEY CalendarDate CalendarDate 4
KEY CapacityInternalID CapacityInternalID 4
KEY CapacityStartTime CapacityStartTime 4
KEY WeekDay WeekDay 1
KEY WorkCenterInternalID WorkCenterInternalID 3
KEY WorkCenterTypeCode WorkCenterTypeCode 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RSHWCCAPACITYPERDAY (
    CALENDARDATE,
    CAPACITYINTERNALID,
    CAPACITYSTARTTIME,
    WEEKDAY,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (CALENDARDATE, CAPACITYINTERNALID, CAPACITYSTARTTIME, WEEKDAY, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More