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)
);