R_PROJECTDEMANDRESOURCEREQUEST

CDS View

Resource Request for Resource Demand

R_PROJECTDEMANDRESOURCEREQUEST is a CDS View in S/4HANA. Resource Request for Resource Demand. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ProjectDemandResourceRequest view from BASIC Resource Request for Resource Demand
R_ProjDmndResourceRequestTP view_entity from TRANSACTIONAL Resource Request for Resource Dmnd - TP 
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

@Analytics.technicalName: 'RPrjDmndRsceReq'
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ObjectModel: {
   modelingPattern: #ANALYTICAL_DIMENSION,
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ],
   representativeKey: 'ProjDmndResourceRequestUUID',
   usageType: {
     serviceQuality:  #A,
     dataClass:       #TRANSACTIONAL,
     sizeCategory:    #XL
   }
}

@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Resource Request for Resource Demand'
@Consumption.dbHints: [ 'USE_HEX_PLAN' ] 

define view entity R_ProjectDemandResourceRequest
  as select from dmndrscereq

  association [1]    to R_ProjectDemand               as _Root                 on $projection.ProjectDemandUUID = _Root.ProjectDemandUUID
  association [1]    to R_ProjectDemandWork           as _Work                 on $projection.ProjectDemandWorkUUID = _Work.ProjectDemandWorkUUID
  association [0..*] to R_ProjDmndRsceReqDistribution as _ProjDmndRsceReqDistr on $projection.ProjDmndResourceRequestUUID = _ProjDmndRsceReqDistr.ProjDmndResourceRequestUUID

  association [1]    to I_EnterpriseProject           as _EnterpriseProject    on $projection.ProjectUUID = _EnterpriseProject.ProjectUUID
  association [1]    to I_PersonWorkAgreement_1       as _PersonWorkAgrmt      on $projection.ProjectDemandRequestedResource = _PersonWorkAgrmt.PersonWorkAgreement  

{
  key projdmndresourcerequestuuid    as ProjDmndResourceRequestUUID,
      projectdemandworkuuid          as ProjectDemandWorkUUID,
      projectdemanduuid              as ProjectDemandUUID,

      @ObjectModel.foreignKey.association: '_EnterpriseProject'
      //Casting to a type which annotates Change Document Relevance as false. This field is already written into Change Document in root node .

      //cast(projectuuid as tv_proj_dmnd_uuid_chg_doc preserving type ) as ProjectUUID, "commented out, please see message 2380013083

      cast(projectuuid as tv_project_uuid_chg_doc preserving type ) as ProjectUUID,
            
      //Casting to a type which annotates Change Document Relevance as false. This field is already written into Change Document in root node .

      //cast(referencedobjectuuid as tv_proj_dmnd_uuid_chg_doc preserving type ) as ReferencedObjectUUID, "commented out, please see message 2380013083

      cast(referencedobjectuuid as tv_dmnd_ref_obj_uuid_chg_doc preserving type ) as ReferencedObjectUUID, 

      @ObjectModel.foreignKey.association: '_PersonWorkAgrmt'
      projectdemandrequestedresource as ProjectDemandRequestedResource,

      projdmndstfnginstructiontext   as ProjDmndStfngInstructionText,
      projdmndrscereqworkassgmtoid   as ProjDmndRsceReqWorkAssgmtOID,
      projdmndrscereqwrkfrcpersonoid as ProjDmndRsceReqWrkfrcPersonOID,
      projdmndrscereqstartdate       as ProjDmndRsceReqStartDate,
      projdmndrscereqenddate         as ProjDmndRsceReqEndDate,

      @Semantics.user.createdBy: true
      createdbyuser                  as CreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      creationdatetime               as CreationDateTime,
      @Semantics.user.lastChangedBy: true
      lastchangedbyuser              as LastChangedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      lastchangedatetime             as LastChangeDateTime,

      /* Associations */
      _Root,
      _Work,
      _ProjDmndRsceReqDistr,

      /* External Associations */
      _EnterpriseProject,
      _PersonWorkAgrmt
}

Learn More