R_PROJDMNDRESOURCEREQUESTTP

CDS View

Resource Request for Resource Dmnd - TP

R_PROJDMNDRESOURCEREQUESTTP is a CDS View in S/4HANA. Resource Request for Resource Dmnd - TP. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_ProjectDemandResourceRequest view_entity projection COMPOSITE Resource Request
I_ProjDmndResourceRequestTP view_entity projection TRANSACTIONAL Resource Request for Resource Dmnd - TP
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ObjectModel: {
   representativeKey: 'ProjDmndResourceRequestUUID',
   usageType: {
     serviceQuality:  #A,
     dataClass:       #TRANSACTIONAL,
     sizeCategory:    #XL
   }
}

@EndUserText.label: 'Resource Request for Resource Dmnd - TP'

define view entity R_ProjDmndResourceRequestTP
  as select from R_ProjectDemandResourceRequest

  association     to parent I_ProjectDemandWorkTP as _Work on $projection.ProjectDemandWorkUUID = _Work.ProjectDemandWorkUUID
  composition [0..*] of R_ProjDmndRsceReqDistrTP  as _ProjDmndRsceReqDistr

  association [1] to I_ProjectDemandTP            as _Root on $projection.ProjectDemandUUID = _Root.ProjectDemandUUID

{
  key ProjDmndResourceRequestUUID,
      ProjectDemandWorkUUID,
      ProjectDemandUUID,
      ProjectUUID,
      ReferencedObjectUUID,
      ProjectDemandRequestedResource,
      ProjDmndStfngInstructionText,
      ProjDmndRsceReqWorkAssgmtOID,
      ProjDmndRsceReqWrkfrcPersonOID,
      ProjDmndRsceReqStartDate,
      ProjDmndRsceReqEndDate,

      CreatedByUser,
      CreationDateTime,
      LastChangedByUser,
      LastChangeDateTime,

      /* Associations */
      _Root,
      _Work,

      /* External Associations */
      _EnterpriseProject,
      _PersonWorkAgrmt,

      /*  R_ProjDmndRsceReqDistrTP Associations */
      _ProjDmndRsceReqDistr
}