DMNDRSCEREQ

Transparent Table Application Table

Project Demand Resource Request

DMNDRSCEREQ is an SAP database table in S/4HANA. Project Demand Resource Request. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ProjectDemandResourceRequest view_entity from BASIC Resource Request for Resource Demand

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY projdmndresourcerequestuuid TV_PROJ_DMND_RSCE_REQ_UUID Rsce Request UUID
projectdemandworkuuid TV_PROJ_DMND_WORK_UUID Resource Dmnd UUID
projectdemanduuid TV_PROJ_DMND_UUID Demand UUID
projectuuid TV_PROJECT_UUID Project UUID
referencedobjectuuid TV_DMND_REF_OBJ_UUID Referenced Object
projectdemandrequestedresource TV_PROJ_DMND_PERSNO Resource
projdmndstfnginstructiontext TV_PROJ_DMND_STFNG_INSTR Staffing Instruction
projdmndrscereqworkassgmtoid TV_PROJ_DMND_ODM_WORKASSGMNTID Work Assignment ID
projdmndrscereqwrkfrcpersonoid TV_PROJ_DMND_ODM_WRKFRCPERSON Workforce Person ID
projdmndrscereqstartdate TV_PROJ_DMND_START_DATE Demand Start Date
projdmndrscereqenddate 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.

-- Project Demand Resource Request
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DMNDRSCEREQ (
    CLIENT,                          -- Client [MANDT]
    PROJDMNDRESOURCEREQUESTUUID,     -- Rsce Request UUID [TV_PROJ_DMND_RSCE_REQ_UUID]
    PROJECTDEMANDWORKUUID,           -- Resource Dmnd UUID [TV_PROJ_DMND_WORK_UUID]
    PROJECTDEMANDUUID,               -- Demand UUID [TV_PROJ_DMND_UUID]
    PROJECTUUID,                     -- Project UUID [TV_PROJECT_UUID]
    REFERENCEDOBJECTUUID,            -- Referenced Object [TV_DMND_REF_OBJ_UUID]
    PROJECTDEMANDREQUESTEDRESOURCE,  -- Resource [TV_PROJ_DMND_PERSNO]
    PROJDMNDSTFNGINSTRUCTIONTEXT,    -- Staffing Instruction [TV_PROJ_DMND_STFNG_INSTR]
    PROJDMNDRSCEREQWORKASSGMTOID,    -- Work Assignment ID [TV_PROJ_DMND_ODM_WORKASSGMNTID]
    PROJDMNDRSCEREQWRKFRCPERSONOID,  -- Workforce Person ID [TV_PROJ_DMND_ODM_WRKFRCPERSON]
    PROJDMNDRSCEREQSTARTDATE,        -- Demand Start Date [TV_PROJ_DMND_START_DATE]
    PROJDMNDRSCEREQENDDATE,          -- 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, PROJDMNDRESOURCEREQUESTUUID)
);