PROJDEMAND_D

Transparent Table Application Table
37 Fields 2 CDS Views

Draft table for entity I_PROJECTDEMANDTP

PROJDEMAND_D is an SAP database table in S/4HANA. Draft table for entity I_PROJECTDEMANDTP. It contains 37 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_ProjectDemandDraft view_entity from EXTENSION Project Demand - Extension
R_ProjectDemandDraft view_entity from BASIC Project Demand Draft

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY projectdemanduuid tv_proj_dmnd_uuid Demand UUID
projectdemand tv_proj_dmnd_id Demand ID
projectdemandname tv_proj_dmnd_name Demand Name
projectdemanddescription tv_proj_dmnd_txt Description
projectdemandcategory tv_proj_dmnd_category Demand Category
projectdemandtype tv_proj_dmnd_demand_type Demand Type
referencedobjectuuid tv_dmnd_ref_obj_uuid Referenced Object
projectuuid tv_project_uuid Project UUID
projectdemandstatus tv_proj_dmnd_status Demand Status
projectdemanddatemaintenance tv_proj_dmnd_date_maintenance Date Alignment
projectdemandstartdate tv_proj_dmnd_start_date Demand Start Date
projectdemandenddate tv_proj_dmnd_end_date Demand End Date
projectdemandreleaseddatetime tv_demand_requested_date_time Requested On
projdmndactualsupplydate tv_proj_dmnd_supply_date Demand Delivery
projectdemandperunitamount tv_proj_dmnd_price_per_unit Price Per Unit
projectdemandrequestcurrency tv_proj_dmnd_curr_unit Demand Currency
projdmndrequestedquantityunit tv_proj_dmnd_quantity_unit Quantity Unit
priceunitqty peinh Price unit
projectdemandrequestnetamount tv_proj_dmnd_net_value Net Value
projdmndreqnetamountcurrency tv_proj_dmnd_curr_unit Demand Currency
projectdemandoverallamount tv_proj_dmnd_overall_amount
projdmndrequestedquantity tv_proj_dmnd_quantity Required Quantity
plant werks_d Plant
projectdemandlastupdatesource tv_proj_dmnd_upd_source Source of Update
purchasinggroup ekgrp Purch. Group
purchasingorganization ekorg Purchasing Org.
createdbyuser tv_created_by Created By
creationdatetime tv_created_on Created On
lastchangedbyuser tv_changed_by Demand Changed By
lastchangedatetime tv_changed_on Demand Changed On
projectdemandlastchangedbyuser abp_lastchange_user Changed By
projdemandlastchangedatetime abp_lastchange_tstmpl Changed On
projdmndexternalreferenceuuid tv_proj_dmnd_ext_ref_uuid External Reference
projectdemandoverallrevenue tv_proj_dmnd_overall_revenue
projdmndoverallrevenuecurrency tv_proj_dmnd_curr_unit Demand Currency
projdmnddatamodelversion tv_proj_dmnd_data_model_ver

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.

-- Draft table for entity I_PROJECTDEMANDTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROJDEMAND_D (
    MANDT,                           -- Client [mandt]
    PROJECTDEMANDUUID,               -- Demand UUID [tv_proj_dmnd_uuid]
    PROJECTDEMAND,                   -- Demand ID [tv_proj_dmnd_id]
    PROJECTDEMANDNAME,               -- Demand Name [tv_proj_dmnd_name]
    PROJECTDEMANDDESCRIPTION,        -- Description [tv_proj_dmnd_txt]
    PROJECTDEMANDCATEGORY,           -- Demand Category [tv_proj_dmnd_category]
    PROJECTDEMANDTYPE,               -- Demand Type [tv_proj_dmnd_demand_type]
    REFERENCEDOBJECTUUID,            -- Referenced Object [tv_dmnd_ref_obj_uuid]
    PROJECTUUID,                     -- Project UUID [tv_project_uuid]
    PROJECTDEMANDSTATUS,             -- Demand Status [tv_proj_dmnd_status]
    PROJECTDEMANDDATEMAINTENANCE,    -- Date Alignment [tv_proj_dmnd_date_maintenance]
    PROJECTDEMANDSTARTDATE,          -- Demand Start Date [tv_proj_dmnd_start_date]
    PROJECTDEMANDENDDATE,            -- Demand End Date [tv_proj_dmnd_end_date]
    PROJECTDEMANDRELEASEDDATETIME,   -- Requested On [tv_demand_requested_date_time]
    PROJDMNDACTUALSUPPLYDATE,        -- Demand Delivery [tv_proj_dmnd_supply_date]
    PROJECTDEMANDPERUNITAMOUNT,      -- Price Per Unit [tv_proj_dmnd_price_per_unit]
    PROJECTDEMANDREQUESTCURRENCY,    -- Demand Currency [tv_proj_dmnd_curr_unit]
    PROJDMNDREQUESTEDQUANTITYUNIT,   -- Quantity Unit [tv_proj_dmnd_quantity_unit]
    PRICEUNITQTY,                    -- Price unit [peinh]
    PROJECTDEMANDREQUESTNETAMOUNT,   -- Net Value [tv_proj_dmnd_net_value]
    PROJDMNDREQNETAMOUNTCURRENCY,    -- Demand Currency [tv_proj_dmnd_curr_unit]
    PROJECTDEMANDOVERALLAMOUNT,      -- tv_proj_dmnd_overall_amount
    PROJDMNDREQUESTEDQUANTITY,       -- Required Quantity [tv_proj_dmnd_quantity]
    PLANT,                           -- Plant [werks_d]
    PROJECTDEMANDLASTUPDATESOURCE,   -- Source of Update [tv_proj_dmnd_upd_source]
    PURCHASINGGROUP,                 -- Purch. Group [ekgrp]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [ekorg]
    CREATEDBYUSER,                   -- Created By [tv_created_by]
    CREATIONDATETIME,                -- Created On [tv_created_on]
    LASTCHANGEDBYUSER,               -- Demand Changed By [tv_changed_by]
    LASTCHANGEDATETIME,              -- Demand Changed On [tv_changed_on]
    PROJECTDEMANDLASTCHANGEDBYUSER,  -- Changed By [abp_lastchange_user]
    PROJDEMANDLASTCHANGEDATETIME,    -- Changed On [abp_lastchange_tstmpl]
    PROJDMNDEXTERNALREFERENCEUUID,   -- External Reference [tv_proj_dmnd_ext_ref_uuid]
    PROJECTDEMANDOVERALLREVENUE,     -- tv_proj_dmnd_overall_revenue
    PROJDMNDOVERALLREVENUECURRENCY,  -- Demand Currency [tv_proj_dmnd_curr_unit]
    PROJDMNDDATAMODELVERSION,        -- tv_proj_dmnd_data_model_ver
    PRIMARY KEY (MANDT, PROJECTDEMANDUUID)
);

Learn More