RSH_D_PROJASG_D

Transparent Table Application Table
33 Fields 2 CDS Views

I_RSHPROJECTASSIGNMENTTP I_RSHPROJECTASSIGNMENTTP

RSH_D_PROJASG_D is an SAP database table in S/4HANA. I_RSHPROJECTASSIGNMENTTP I_RSHPROJECTASSIGNMENTTP. It contains 33 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_RSHAssignmentDrafts view from BASIC Draft assignment for session user
P_RSHAssignmentPerDayDrafts view from BASIC Per day assigmment drafts

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY projassignmentuuid sysuuid_x UUID
employmentinternalid hrobjid Object ID
resourcedemanduuid /cpd/demand_key Demand Key
sourceofsupply rsh_ps_source_of_supply Source of Supply
sourceofdraftcreationinrsh rsh_ps_proj_asg_draft_source RSH Draft Source
projassignmentdistributionrule abap.char
projassignmentstartdate abap.dats
projassignmentenddate abap.dats
projassignmenttotalhours rsh_ps_proj_total_asg_duration Total Duration
projassignmenthoursperday rsh_ps_proj_asg_duratn_per_day Asg. Duration
projassignmentutilization abap.int1
projassigndaycapacitystartdate abap.dats
projassigndaycapacityenddate abap.dats
projassignisdistrtospecifdays abap.char
projassignisdistrtomonday abap.char
projassignisdistrtotuesday abap.char
projassignisdistrtowednesday abap.char
projassignisdistrtothursday abap.char
projassignisdistrtofriday abap.char
projassignisdistrtosaturday abap.char
projassignisdistrtosunday abap.char
projassignmentcreatedby uname User Name
projassignmentcreatedat timestampl Time Stamp
projassignmentlastchangedby uname User Name
projassignmentlastchangedat timestampl Time Stamp
projassignmentlifecycle rsh_ps_proj_asg_life_cycle Asg. Life Cycle
employeerequestopenduration rsh_ps_employeerequestopenhour Remaining Required Hours
projectlastchangeddatetime tzntstmps Time Stamp
employeeutillvloverbooked rsh_ps_overbooked_threshold Overbooked (%)
employeeutillvlfreecapacity rsh_ps_free_capacity_threshold Free Capacity (%)
activeuuid /bobf/uuid Key
hasactiveentity sdraft_has_active Has active

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.

-- I_RSHPROJECTASSIGNMENTTP I_RSHPROJECTASSIGNMENTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RSH_D_PROJASG_D (
    MANDT,                           -- Client [mandt]
    PROJASSIGNMENTUUID,              -- UUID [sysuuid_x]
    EMPLOYMENTINTERNALID,            -- Object ID [hrobjid]
    RESOURCEDEMANDUUID,              -- Demand Key [/cpd/demand_key]
    SOURCEOFSUPPLY,                  -- Source of Supply [rsh_ps_source_of_supply]
    SOURCEOFDRAFTCREATIONINRSH,      -- RSH Draft Source [rsh_ps_proj_asg_draft_source]
    PROJASSIGNMENTDISTRIBUTIONRULE,  -- abap.char
    PROJASSIGNMENTSTARTDATE,         -- abap.dats
    PROJASSIGNMENTENDDATE,           -- abap.dats
    PROJASSIGNMENTTOTALHOURS,        -- Total Duration [rsh_ps_proj_total_asg_duration]
    PROJASSIGNMENTHOURSPERDAY,       -- Asg. Duration [rsh_ps_proj_asg_duratn_per_day]
    PROJASSIGNMENTUTILIZATION,       -- abap.int1
    PROJASSIGNDAYCAPACITYSTARTDATE,  -- abap.dats
    PROJASSIGNDAYCAPACITYENDDATE,    -- abap.dats
    PROJASSIGNISDISTRTOSPECIFDAYS,   -- abap.char
    PROJASSIGNISDISTRTOMONDAY,       -- abap.char
    PROJASSIGNISDISTRTOTUESDAY,      -- abap.char
    PROJASSIGNISDISTRTOWEDNESDAY,    -- abap.char
    PROJASSIGNISDISTRTOTHURSDAY,     -- abap.char
    PROJASSIGNISDISTRTOFRIDAY,       -- abap.char
    PROJASSIGNISDISTRTOSATURDAY,     -- abap.char
    PROJASSIGNISDISTRTOSUNDAY,       -- abap.char
    PROJASSIGNMENTCREATEDBY,         -- User Name [uname]
    PROJASSIGNMENTCREATEDAT,         -- Time Stamp [timestampl]
    PROJASSIGNMENTLASTCHANGEDBY,     -- User Name [uname]
    PROJASSIGNMENTLASTCHANGEDAT,     -- Time Stamp [timestampl]
    PROJASSIGNMENTLIFECYCLE,         -- Asg. Life Cycle [rsh_ps_proj_asg_life_cycle]
    EMPLOYEEREQUESTOPENDURATION,     -- Remaining Required Hours [rsh_ps_employeerequestopenhour]
    PROJECTLASTCHANGEDDATETIME,      -- Time Stamp [tzntstmps]
    EMPLOYEEUTILLVLOVERBOOKED,       -- Overbooked (%) [rsh_ps_overbooked_threshold]
    EMPLOYEEUTILLVLFREECAPACITY,     -- Free Capacity (%) [rsh_ps_free_capacity_threshold]
    ACTIVEUUID,                      -- Key [/bobf/uuid]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, PROJASSIGNMENTUUID)
);

Learn More