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