I_RSHPROJECTASSIGNMENT

CDS View
8 Fields 11 CDS Views

Project Assignment

I_RSHPROJECTASSIGNMENT is a CDS View in S/4HANA. Project Assignment. It contains 8 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_EngmntProjStaffedResource view left_outer CONSUMPTION Engagement Project Staffed Resource
C_RSHTableBasedTreeProperties view left_outer CONSUMPTION View for additional tree properties
I_RSHProjectAssignmentHrs view from COMPOSITE Resource Assignments
I_RSHProjectAssignmentTP view from TRANSACTIONAL Project Assignment TP
P_RSHAsgnSummaryPerRequest view from COMPOSITE Aggregated Assginment Summary per Resource Request
P_RSHAssignment view from COMPOSITE Assignment Header
P_RSHAssignmentWithDraft view from COMPOSITE Per Day Assignment details with draft
P_RSHAssignmentWithDraft view union COMPOSITE Per Day Assignment details with draft
P_RSHResourceSkillsFromAsg view from COMPOSITE Resource Skills from existing Assignment
P_RSHRsceAssgmtReqDetails view from COMPOSITE Request details for resource assignments
P_RSHStaffingReqAssgmtHours view from COMPOSITE Staffing request and the duration

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ProjAssignmentUUID DraftUUID,ProjAssignmentUUID 4
EmploymentInternalID EmploymentInternalID 4
ProjAssignmentEndDate ProjAssignmentEndDate,StaffedResourceEndDate 4
ProjAssignmentLastChangedBy ProjAssignmentLastChangedBy 1
ProjAssignmentStartDate ProjAssignmentStartDate,StaffedResourceStartDate 4
ProjAssignmentTotalHours AssignedHours,ProjAssignmentTotalHours 3
ResourceDemandUUID ResourceDemandUUID 4
SourceOfSupply SourceOfSupply 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.

-- Project Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RSHPROJECTASSIGNMENT (
    PROJASSIGNMENTUUID,
    EMPLOYMENTINTERNALID,
    PROJASSIGNMENTENDDATE,
    PROJASSIGNMENTLASTCHANGEDBY,
    PROJASSIGNMENTSTARTDATE,
    PROJASSIGNMENTTOTALHOURS,
    RESOURCEDEMANDUUID,
    SOURCEOFSUPPLY,
    PRIMARY KEY (PROJASSIGNMENTUUID)
);

Learn More