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