WORKDEMAND

Transparent Table Application Table
16 Fields 1 CDS Views

Enterprise Work Demand

WORKDEMAND is an SAP database table in S/4HANA. Enterprise Work Demand. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ProjectDemandWork view_entity from BASIC Project Demand for Resource

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY 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
costcenter KOSTL Cost Center
activitytype LSTAR Activity Type
projdmndassgmtstatus TV_PROJ_DMND_ASSGMT_STATUS Assignment Status
projectelementworkitem TV_PROJ_ELEM_WORK_ITEM Work Item ID
projdmndbillingcontrolcategory BILLGCTRLCAT Billing Category
projdmndrequesteddeliveryorg TV_PROJ_DMND_DLVRY_ORG Delivery Org.
projdmndassgmtisinconsistent ABAP_BOOLEAN Truth Value
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.

-- Enterprise Work Demand
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WORKDEMAND (
    CLIENT,                          -- Client [MANDT]
    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]
    COSTCENTER,                      -- Cost Center [KOSTL]
    ACTIVITYTYPE,                    -- Activity Type [LSTAR]
    PROJDMNDASSGMTSTATUS,            -- Assignment Status [TV_PROJ_DMND_ASSGMT_STATUS]
    PROJECTELEMENTWORKITEM,          -- Work Item ID [TV_PROJ_ELEM_WORK_ITEM]
    PROJDMNDBILLINGCONTROLCATEGORY,  -- Billing Category [BILLGCTRLCAT]
    PROJDMNDREQUESTEDDELIVERYORG,    -- Delivery Org. [TV_PROJ_DMND_DLVRY_ORG]
    PROJDMNDASSGMTISINCONSISTENT,    -- Truth Value [ABAP_BOOLEAN]
    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, PROJECTDEMANDWORKUUID)
);

Learn More