R_ProjDmndRsceAssignmentDraft

DDL: R_PROJDMNDRSCEASSIGNMENTDRAFT Type: view_entity BASIC
29 Fields 1 Data Sources 4 Associations

Resource Assignment – Draft Query

R_ProjDmndRsceAssignmentDraft is a Basic CDS View that provides data about "Resource Assignment – Draft Query" in SAP S/4HANA. It reads from 1 data source (dmndrsceassgmt_d) and exposes 29 fields with key field ProjDmndRsceAssgmtUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
dmndrsceassgmt_d dmndrsceassgmt_d from

Associations (4)

CardinalityTargetAliasCondition
[1..1] R_ProjectDemandDraft _Root $projection.ProjectDemandUUID = _Root.ProjectDemandUUID
[1..1] R_ProjectDemandResourceDraft _Work $projection.ProjectDemandWorkUUID = _Work.ProjectDemandWorkUUID
[0..1] I_UnitOfMeasure _RsceAssgmtQuantityUnit $projection.ProjDmndRsceAssgmtQuantityUnit = _RsceAssgmtQuantityUnit.UnitOfMeasure and _RsceAssgmtQuantityUnit.UnitOfMeasureDimension = 'TIME' and _RsceAssgmtQuantityUnit.SIUnitCnvrsnRateNumerator = 3600
[1..1] I_PersonWorkAgreement_1 _PersonWorkAgreement $projection.ProjDmndRsceAssgmt = _PersonWorkAgreement.PersonWorkAgreement

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Resource Assignment – Draft Query view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY ProjDmndRsceAssgmtUUID projdmndrsceassgmtuuid Resource Assgmt UUID
ProjectDemandWorkUUID projectdemandworkuuid Resource Dmnd UUID
ProjectDemandUUID projectdemanduuid Entity GUID
ProjDmndRsceAssgmt projdmndrsceassgmt Resource
ProjDmndRsceAssgmtQuantity projdmndrsceassgmtquantity Assigned Quantity
ProjDmndRsceAssgmtQuantityUnit projdmndrsceassgmtquantityunit Quantity Unit
ProjectUUID projectuuid Project UUID
ReferencedObjectUUID referencedobjectuuid Referenced Object
ProjectDemandSupplyIdentifier projectdemandsupplyidentifier Resource Supply ID
ProjectDemandSupplyDeliveryOrg projectdemandsupplydeliveryorg Delivery Org.
ProjectDemandSourceOfSupply projectdemandsourceofsupply Assignment Source
ProjAssgmtLastUpdateSource projassgmtlastupdatesource Source of Update
ProjDmndRsceWorkAssgmtOID projdmndrsceworkassgmtoid Work Assignment ID
ProjDmndRsceWrkfrcPersonOID projdmndrscewrkfrcpersonoid Workforce Person ID
ProjDmndRsceAssgmtStartDate projdmndrsceassgmtstartdate Demand Start Date
ProjDmndRsceAssgmtEndDate projdmndrsceassgmtenddate Demand End Date
CreatedByUser createdbyuser User Name
CreationDateTime creationdatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
_Root _Root
_Work _Work
_RsceAssgmtQuantityUnit _RsceAssgmtQuantityUnit
_PersonWorkAgreement _PersonWorkAgreement

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_ProjDmndRsceAssignmentDraft.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_ProjDmndRsceAssignmentDraft AS
SELECT
  ProjDmndRsceAssgmtUUID,
  ProjectDemandWorkUUID,
  ProjectDemandUUID,
  ProjDmndRsceAssgmt,
  ProjDmndRsceAssgmtQuantity,
  ProjDmndRsceAssgmtQuantityUnit,
  ProjectUUID,
  ReferencedObjectUUID,
  ProjectDemandSupplyIdentifier,
  ProjectDemandSupplyDeliveryOrg,
  ProjectDemandSourceOfSupply,
  ProjAssgmtLastUpdateSource,
  ProjDmndRsceWorkAssgmtOID,
  ProjDmndRsceWrkfrcPersonOID,
  ProjDmndRsceAssgmtStartDate,
  ProjDmndRsceAssgmtEndDate,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftEntityOperationCode,
  HasActiveEntity
FROM dmndrsceassgmt_d
LEFT OUTER JOIN R_ProjectDemandDraft AS _Root ON ProjectDemandUUID = _Root.ProjectDemandUUID  -- association [1..1]
LEFT OUTER JOIN R_ProjectDemandResourceDraft AS _Work ON ProjectDemandWorkUUID = _Work.ProjectDemandWorkUUID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RsceAssgmtQuantityUnit ON ProjDmndRsceAssgmtQuantityUnit = _RsceAssgmtQuantityUnit.UnitOfMeasure AND _RsceAssgmtQuantityUnit.UnitOfMeasureDimension = 'TIME' AND _RsceAssgmtQuantityUnit.SIUnitCnvrsnRateNumerator = 3600  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement ON ProjDmndRsceAssgmt = _PersonWorkAgreement.PersonWorkAgreement  -- association [1..1]
;

Learn More