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