P_RSHRESOURCEAVAILABILITY

CDS View
3 Fields 6 CDS Views

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

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_RSHGanttTimeInterval view from CONSUMPTION Time Interval for Resources
P_RSHBscRsceUtilization view inner CONSUMPTION
P_RSHBscStaffReqSupply view left_outer CONSUMPTION Staffing Request Supply Data from CPM
P_RSHBscStaffReqSupplyCalc view left_outer CONSUMPTION
P_RSHResourceUtilization view from COMPOSITE
P_RSHResourceUtilznWithDraft view from CONSUMPTION

Fields (3)

KeyField CDS FieldsUsed in Views
KEY CalendarDate CalendarDate 4
KEY EmploymentInternalID EmploymentInternalID 4
Availability EmployeeAvailableHours 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_RSHRESOURCEAVAILABILITY (
    CALENDARDATE,
    EMPLOYMENTINTERNALID,
    AVAILABILITY,
    PRIMARY KEY (CALENDARDATE, EMPLOYMENTINTERNALID)
);

Learn More