DMNDRSCERQDSTR

Transparent Table Application Table
21 Fields 1 CDS Views

Project Demand Resource Request Distribution

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ProjDmndRsceReqDistribution view_entity from BASIC Resource Req Distribution for Rsce Dmnd

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY projdmndrscereqdistruuid tv_proj_dmnd_rsce_distr_uuid Request Distr. UUID
projdmndresourcerequestuuid tv_proj_dmnd_rsce_req_uuid Rsce Request UUID
projectdemanduuid tv_proj_dmnd_uuid Demand UUID
projectuuid tv_project_uuid Project UUID
referencedobjectuuid tv_dmnd_ref_obj_uuid Referenced Object
projdmndrscereqdistryearval tv_proj_dmnd_year Year of Distribution
projdmndrscereqdistrperdval tv_proj_dmnd_period Distribution Period
projdmndrscereqdistrquantity tv_proj_dmnd_rsce_req_dist_qty Distributed Quantity
projdmndrscereqdistrqtyunit tv_proj_dmnd_rsce_rq_dst_qty_u Quantity Unit
projdmndrscereqdistrperdamt tv_proj_dmnd_amount Plannend Cost
projdmndrscereqdistrperdamtcur tv_proj_dmnd_amount_currency Currency
projdmndrscereqdistrrevenueamt tv_proj_dmnd_amount_revenue Planned Revenue
projdmndrscereqdistrrevnamtcur tv_proj_dmnd_amount_currency Currency
projdmndreferencedplandatauuid tv_dmnd_itm_plan_uuid Project Plan Item
projdmndrscereqdistrstartdate tv_proj_dmnd_rs_rq_dst_strtdte Distr. Start Date
projdmndrscereqdistrenddate tv_proj_dmnd_rs_rq_dst_enddate Distr. 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 Distribution
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DMNDRSCERQDSTR (
    CLIENT,                          -- Client [mandt]
    PROJDMNDRSCEREQDISTRUUID,        -- Request Distr. UUID [tv_proj_dmnd_rsce_distr_uuid]
    PROJDMNDRESOURCEREQUESTUUID,     -- Rsce Request UUID [tv_proj_dmnd_rsce_req_uuid]
    PROJECTDEMANDUUID,               -- Demand UUID [tv_proj_dmnd_uuid]
    PROJECTUUID,                     -- Project UUID [tv_project_uuid]
    REFERENCEDOBJECTUUID,            -- Referenced Object [tv_dmnd_ref_obj_uuid]
    PROJDMNDRSCEREQDISTRYEARVAL,     -- Year of Distribution [tv_proj_dmnd_year]
    PROJDMNDRSCEREQDISTRPERDVAL,     -- Distribution Period [tv_proj_dmnd_period]
    PROJDMNDRSCEREQDISTRQUANTITY,    -- Distributed Quantity [tv_proj_dmnd_rsce_req_dist_qty]
    PROJDMNDRSCEREQDISTRQTYUNIT,     -- Quantity Unit [tv_proj_dmnd_rsce_rq_dst_qty_u]
    PROJDMNDRSCEREQDISTRPERDAMT,     -- Plannend Cost [tv_proj_dmnd_amount]
    PROJDMNDRSCEREQDISTRPERDAMTCUR,  -- Currency [tv_proj_dmnd_amount_currency]
    PROJDMNDRSCEREQDISTRREVENUEAMT,  -- Planned Revenue [tv_proj_dmnd_amount_revenue]
    PROJDMNDRSCEREQDISTRREVNAMTCUR,  -- Currency [tv_proj_dmnd_amount_currency]
    PROJDMNDREFERENCEDPLANDATAUUID,  -- Project Plan Item [tv_dmnd_itm_plan_uuid]
    PROJDMNDRSCEREQDISTRSTARTDATE,   -- Distr. Start Date [tv_proj_dmnd_rs_rq_dst_strtdte]
    PROJDMNDRSCEREQDISTRENDDATE,     -- Distr. End Date [tv_proj_dmnd_rs_rq_dst_enddate]
    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, PROJDMNDRSCEREQDISTRUUID)
);

Learn More