P_RSHRESOURCETIMESLICE

CDS View

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

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_RSHGanttNonWorkingTime view from CONSUMPTION Non working time for Resources
C_RSHResourceTimeSlice view from CONSUMPTION RSH Resource Time Slice
C_RSHStaffingRequestForRes view left_outer CONSUMPTION Staffing Request for Resource
C_RSHTableBasedTreeProperties view from CONSUMPTION View for additional tree properties
P_RSHAvailMatchMonthlyCalc view left_outer COMPOSITE

Fields (6)

KeyField CDS FieldsUsed in Views
KEY EmploymentInternalID EmployeeParentRowId,EmploymentInternalID 2
KEY StartDate StartDate 1
AuthorizationGroup AuthorizationGroup 1
CompanyCode CompanyCode 1
CostCenter CostCenter 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 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_RSHRESOURCETIMESLICE (
    EMPLOYMENTINTERNALID,
    STARTDATE,
    AUTHORIZATIONGROUP,
    COMPANYCODE,
    COSTCENTER,
    ISBUSINESSPURPOSECOMPLETED,
    PRIMARY KEY (EMPLOYMENTINTERNALID, STARTDATE)
);