R_ProjDmndResourceRequestTP

DDL: R_PROJDMNDRESOURCEREQUESTTP Type: view_entity TRANSACTIONAL Package: PS_DMND_VDM_WORK

Resource Request for Resource Dmnd - TP

R_ProjDmndResourceRequestTP is a Transactional CDS View that provides data about "Resource Request for Resource Dmnd - TP" in SAP S/4HANA. It reads from 1 data source (R_ProjectDemandResourceRequest) and exposes 20 fields with key field ProjDmndResourceRequestUUID. It has 2 associations to related views. Part of development package PS_DMND_VDM_WORK.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
R_ProjectDemandResourceRequest R_ProjectDemandResourceRequest from

Associations (2)

CardinalityTargetAliasCondition
[1] I_ProjectDemandTP _Root $projection.ProjectDemandUUID = _Root.ProjectDemandUUID
[0..*] R_ProjDmndRsceReqDistrTP _ProjDmndRsceReqDistr

Annotations (9)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.representativeKey ProjDmndResourceRequestUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Resource Request for Resource Dmnd - TP view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ProjDmndResourceRequestUUID ProjDmndResourceRequestUUID
ProjectDemandWorkUUID ProjectDemandWorkUUID
ProjectDemandUUID ProjectDemandUUID
ProjectUUID ProjectUUID
ReferencedObjectUUID ReferencedObjectUUID
ProjectDemandRequestedResource ProjectDemandRequestedResource
ProjDmndStfngInstructionText ProjDmndStfngInstructionText
ProjDmndRsceReqWorkAssgmtOID ProjDmndRsceReqWorkAssgmtOID
ProjDmndRsceReqWrkfrcPersonOID ProjDmndRsceReqWrkfrcPersonOID
ProjDmndRsceReqStartDate ProjDmndRsceReqStartDate
ProjDmndRsceReqEndDate ProjDmndRsceReqEndDate
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_Root _Root
_Work _Work
_EnterpriseProject _EnterpriseProject
_PersonWorkAgrmt _PersonWorkAgrmt
_ProjDmndRsceReqDistr _ProjDmndRsceReqDistr 
@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'
@Consumption.dbHints: [ 'USE_HEX_PLAN' ] 

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
}

Learn More