DMNDRSCEASSGMT_D

Transparent Table Application Table
28 Fields 1 CDS Views

Draft table for entity I_PROJDMNDRESOURCEASSIGNMENTTP

DMNDRSCEASSGMT_D is an SAP database table in S/4HANA. Draft table for entity I_PROJDMNDRESOURCEASSIGNMENTTP. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ProjDmndRsceAssignmentDraft view_entity from BASIC Resource Assignment – Draft Query

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY projdmndrsceassgmtuuid TV_PROJ_DMND_ASSIGNMENT_UUID Resource Assgmt UUID
projectdemandworkuuid TV_PROJ_DMND_WORK_UUID Resource Dmnd UUID
projectdemanduuid TV_PROJ_DMND_UUID Demand UUID
projdmndrsceassgmt TV_PROJ_DMND_PERSNO Resource
projdmndrsceassgmtquantity TV_PROJ_DMND_EFFORT Assigned Quantity
projdmndrsceassgmtquantityunit TV_PROJ_DMND_EFFORT_UNIT Quantity Unit
projectuuid TV_PROJECT_UUID Project UUID
referencedobjectuuid TV_DMND_REF_OBJ_UUID Referenced Object
projectdemandsupplyidentifier TV_PROJ_DMND_SUPPLY_ID Resource Supply ID
projectdemandsupplydeliveryorg TV_PROJ_DMND_SUPPLY_DLVRY_ID Delivery Org.
projectdemandsourceofsupply TV_PROJ_DMND_SOURCE_OF_SUPPLY Assignment Source
projassgmtlastupdatesource TV_PROJ_ASSGMT_UPD_SOURCE Source of Update
projdmndrsceworkassgmtoid TV_PROJ_DMND_ODM_WORKASSGMNTID Work Assignment ID
projdmndrscewrkfrcpersonoid TV_PROJ_DMND_ODM_WRKFRCPERSON Workforce Person ID
projdmndrsceassgmtstartdate TV_PROJ_DMND_START_DATE Demand Start Date
projdmndrsceassgmtenddate TV_PROJ_DMND_END_DATE Demand 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
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

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_PROJDMNDRESOURCEASSIGNMENTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DMNDRSCEASSGMT_D (
    MANDT,                           -- Client [MANDT]
    PROJDMNDRSCEASSGMTUUID,          -- Resource Assgmt UUID [TV_PROJ_DMND_ASSIGNMENT_UUID]
    PROJECTDEMANDWORKUUID,           -- Resource Dmnd UUID [TV_PROJ_DMND_WORK_UUID]
    PROJECTDEMANDUUID,               -- Demand UUID [TV_PROJ_DMND_UUID]
    PROJDMNDRSCEASSGMT,              -- Resource [TV_PROJ_DMND_PERSNO]
    PROJDMNDRSCEASSGMTQUANTITY,      -- Assigned Quantity [TV_PROJ_DMND_EFFORT]
    PROJDMNDRSCEASSGMTQUANTITYUNIT,  -- Quantity Unit [TV_PROJ_DMND_EFFORT_UNIT]
    PROJECTUUID,                     -- Project UUID [TV_PROJECT_UUID]
    REFERENCEDOBJECTUUID,            -- Referenced Object [TV_DMND_REF_OBJ_UUID]
    PROJECTDEMANDSUPPLYIDENTIFIER,   -- Resource Supply ID [TV_PROJ_DMND_SUPPLY_ID]
    PROJECTDEMANDSUPPLYDELIVERYORG,  -- Delivery Org. [TV_PROJ_DMND_SUPPLY_DLVRY_ID]
    PROJECTDEMANDSOURCEOFSUPPLY,     -- Assignment Source [TV_PROJ_DMND_SOURCE_OF_SUPPLY]
    PROJASSGMTLASTUPDATESOURCE,      -- Source of Update [TV_PROJ_ASSGMT_UPD_SOURCE]
    PROJDMNDRSCEWORKASSGMTOID,       -- Work Assignment ID [TV_PROJ_DMND_ODM_WORKASSGMNTID]
    PROJDMNDRSCEWRKFRCPERSONOID,     -- Workforce Person ID [TV_PROJ_DMND_ODM_WRKFRCPERSON]
    PROJDMNDRSCEASSGMTSTARTDATE,     -- Demand Start Date [TV_PROJ_DMND_START_DATE]
    PROJDMNDRSCEASSGMTENDDATE,       -- Demand End Date [TV_PROJ_DMND_END_DATE]
    CREATEDBYUSER,                   -- Created By [ABP_CREATION_USER]
    CREATIONDATETIME,                -- Created On [ABP_CREATION_TSTMPL]
    LASTCHANGEDBYUSER,               -- Changed By [ABP_LASTCHANGE_USER]
    LASTCHANGEDATETIME,              -- Changed On [ABP_LASTCHANGE_TSTMPL]
    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]
    PRIMARY KEY (MANDT, PROJDMNDRSCEASSGMTUUID)
);

Learn More