I_PROJECTDEMANDWORKTP

CDS View

Project Demand for Resource - TP

I_PROJECTDEMANDWORKTP is a CDS View in S/4HANA. Project Demand for Resource - TP. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_ProjectDemandResource view_entity projection COMPOSITE Resource Demand
C_ProjectDemandWorkAllTP view_entity projection CONSUMPTION Manage Resource Demands for All tab
C_ProjectDemandWorkTP view_entity projection CONSUMPTION Project Demand Work Consumption TP view
I_ProjectDemandResourceTP view_entity projection TRANSACTIONAL Project Demand for Resource - TP
//@AbapCatalog.sqlViewName: 'IPROJDMNDWORKTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true


@AccessControl.authorizationCheck: #CHECK

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {

                                          
                                        

                               
                                                    
                               

   semanticKey:       ['ActivityType'],
   representativeKey: 'ProjectDemandWorkUUID',
   //alternativeKey:    ['ProjectDemandUUID'],


   usageType: {
     serviceQuality:  #B,
     dataClass:       #TRANSACTIONAL,
     sizeCategory:    #XL
   }

}

@EndUserText.label: 'Project Demand for Resource - TP'

// Due changed RAP guideline, this view should be rather R_ProjectDemandWorkTP (ideally R_ProjectDemandResourceTP since Resource is in use).

// But "Work" will be kept to avoid unintended side effects (BO was migrated to RAP).

define view entity I_ProjectDemandWorkTP
  as select from R_ProjectDemandWork

  association to parent I_ProjectDemandTP              as _Root            on $projection.ProjectDemandUUID = _Root.ProjectDemandUUID  
  composition [0..*] of I_ProjDmndResourceAssignmentTP as _ResourceAssignment // Prior 2208 named as _ResourceRequest, but changed to _ResourceAssignment with 2208.

  composition [0..*] of R_ProjDmndResourceRequestTP    as _ResourceRequest    // _ResourceRequest must be used here with 2208


{

  key ProjectDemandWorkUUID,

                                 
      ProjectDemandUUID, 
      
      ProjectUUID,

      ReferencedObjectUUID,
                                                           
      CostCenter,
                                                       
      ActivityType,

      ProjDmndAssgmtStatus,  
      ProjectElementWorkItem,
      ProjDmndBillingControlCategory,
      ProjDmndRequestedDeliveryOrg,
      ProjDmndAssgmtIsInconsistent, 
      
      CreatedByUser,
      CreationDateTime,
      LastChangedByUser,
      LastChangeDateTime,
      
      /* Associations */
                                                                                     
      _Root,
      
      _CostCenterActType,
      _CostCenter,
      
      _ResourceAssignment,                                        
      _ResourceRequest,
      _CostCenterText,
      _ActivityTypeText
      
      
}