PROJDEMAND_D

Transparent Table Application Table
42 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 42 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 (42)

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_LIMIT Overall Limit
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
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityconsistencystatus abap.char
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
projectdemandlastchangedbyuser ABP_LASTCHANGE_USER Changed By
projdemandlastchangedatetime ABP_LASTCHANGE_TSTMPL Changed On
projdmndexternalreferenceuuid TV_PROJ_DMND_EXT_REF_UUID External Reference
dummy_proj_demand_incl_eew TV_PROJDMND_INCL_EEW Dummy

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,      -- Overall Limit [TV_PROJ_DMND_OVERALL_LIMIT]
    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]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- abap.char
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PROJECTDEMANDLASTCHANGEDBYUSER,  -- Changed By [ABP_LASTCHANGE_USER]
    PROJDEMANDLASTCHANGEDATETIME,    -- Changed On [ABP_LASTCHANGE_TSTMPL]
    PROJDMNDEXTERNALREFERENCEUUID,   -- External Reference [TV_PROJ_DMND_EXT_REF_UUID]
    DUMMY_PROJ_DEMAND_INCL_EEW,      -- Dummy [TV_PROJDMND_INCL_EEW]
    PRIMARY KEY (MANDT, PROJECTDEMANDUUID)
);

Learn More