RESOURCEASSGMT

Transparent Table Application Table
21 Fields 1 CDS Views

Resource Assignment - Direct Staffing

RESOURCEASSGMT is an SAP database table in S/4HANA. Resource Assignment - Direct Staffing. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ProjDmndResourceAssignment view_entity from BASIC Resource Assignment to Rsce Dmnd

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY projdmndrsceassgmtuuid tv_proj_dmnd_assignment_uuid Resource Assgmt UUID
projectdemandworkuuid tv_proj_dmnd_work_uuid Resource Dmnd UUID
projectdemanduuid tv_proj_dmnd_uuid Demand UUID
projdmndrsceassgmt tv_proj_dmnd_persno Resource
projdmndrsceassgmtquantity tv_proj_dmnd_effort Assigned Quantity
projdmndrsceassgmtquantityunit tv_proj_dmnd_effort_unit Quantity Unit
projectuuid tv_project_uuid Project UUID
referencedobjectuuid tv_dmnd_ref_obj_uuid Referenced Object
projectdemandsupplyidentifier tv_proj_dmnd_supply_id Resource Supply ID
projectdemandsupplydeliveryorg tv_proj_dmnd_supply_dlvry_id Delivery Org.
projectdemandsourceofsupply tv_proj_dmnd_source_of_supply Assignment Source
projassgmtlastupdatesource tv_proj_assgmt_upd_source Source of Update
projdmndrsceworkassgmtoid tv_proj_dmnd_odm_workassgmntid Work Assignment ID
projdmndrscewrkfrcpersonoid tv_proj_dmnd_odm_wrkfrcperson Workforce Person ID
projdmndrsceassgmtstartdate tv_proj_dmnd_start_date Demand Start Date
projdmndrsceassgmtenddate tv_proj_dmnd_end_date Demand End Date
createdbyuser abp_creation_user Created By
creationdatetime abp_creation_tstmpl Created On
lastchangedbyuser abp_lastchange_user Changed By
lastchangedatetime abp_lastchange_tstmpl Changed On

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.

-- Resource Assignment - Direct Staffing
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RESOURCEASSGMT (
    CLIENT,                          -- Client [mandt]
    PROJDMNDRSCEASSGMTUUID,          -- Resource Assgmt UUID [tv_proj_dmnd_assignment_uuid]
    PROJECTDEMANDWORKUUID,           -- Resource Dmnd UUID [tv_proj_dmnd_work_uuid]
    PROJECTDEMANDUUID,               -- Demand UUID [tv_proj_dmnd_uuid]
    PROJDMNDRSCEASSGMT,              -- Resource [tv_proj_dmnd_persno]
    PROJDMNDRSCEASSGMTQUANTITY,      -- Assigned Quantity [tv_proj_dmnd_effort]
    PROJDMNDRSCEASSGMTQUANTITYUNIT,  -- Quantity Unit [tv_proj_dmnd_effort_unit]
    PROJECTUUID,                     -- Project UUID [tv_project_uuid]
    REFERENCEDOBJECTUUID,            -- Referenced Object [tv_dmnd_ref_obj_uuid]
    PROJECTDEMANDSUPPLYIDENTIFIER,   -- Resource Supply ID [tv_proj_dmnd_supply_id]
    PROJECTDEMANDSUPPLYDELIVERYORG,  -- Delivery Org. [tv_proj_dmnd_supply_dlvry_id]
    PROJECTDEMANDSOURCEOFSUPPLY,     -- Assignment Source [tv_proj_dmnd_source_of_supply]
    PROJASSGMTLASTUPDATESOURCE,      -- Source of Update [tv_proj_assgmt_upd_source]
    PROJDMNDRSCEWORKASSGMTOID,       -- Work Assignment ID [tv_proj_dmnd_odm_workassgmntid]
    PROJDMNDRSCEWRKFRCPERSONOID,     -- Workforce Person ID [tv_proj_dmnd_odm_wrkfrcperson]
    PROJDMNDRSCEASSGMTSTARTDATE,     -- Demand Start Date [tv_proj_dmnd_start_date]
    PROJDMNDRSCEASSGMTENDDATE,       -- Demand End Date [tv_proj_dmnd_end_date]
    CREATEDBYUSER,                   -- Created By [abp_creation_user]
    CREATIONDATETIME,                -- Created On [abp_creation_tstmpl]
    LASTCHANGEDBYUSER,               -- Changed By [abp_lastchange_user]
    LASTCHANGEDATETIME,              -- Changed On [abp_lastchange_tstmpl]
    PRIMARY KEY (CLIENT, PROJDMNDRSCEASSGMTUUID)
);

Learn More