I_PROJECTDEMANDWORKTP

CDS View

Project Demand for Resource - TP

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

Used by 6 CDS view(s) 5 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
A_ProjectDemandResource view_entity projection COMPOSITE Resource Demand
C_EnPrjPfSrvsHumRsceDmndDetTP view_entity projection CONSUMPTION Human Resource Profnl Srvcs Proj
C_EntPrjProfnlSrvcDmndStaffing view_entity inner CONSUMPTION Enterprise Project Demand Staffing Data
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

Fields (5)

KeyField CDS FieldsUsed in Views
ActivityType ActivityType 1
ProjDmndAssgmtStatus DemandStaffingStatus 1
ProjDmndBillingControlCategory ProjDmndBillingControlCategory 1
ProjDmndRequestedDeliveryOrg ProjDmndRequestedDeliveryOrg 1
ProjectElementWorkItem WorkItem 1 
//@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


  association [0..*] to I_CostCenterText               as _CostCenterText   on $projection.CostCenter   = _CostCenterText.CostCenter
  association [0..*] to I_CostCenterActivityTypeText   as _ActivityTypeText on $projection.ActivityType = _ActivityTypeText.CostCtrActivityType

  association [0..1] to I_CostCenterActivityTypeText   as _ResourceTypeText on  _ResourceTypeText.ControllingArea      = 'A000'
                                                                            and _ResourceTypeText.CostCtrActivityType  = $projection.ActivityType
                                                                            and _ResourceTypeText.Language             = $session.system_language
                                                                            and _ResourceTypeText.ValidityEndDate     >= $session.system_date
                                                                            and _ResourceTypeText.ValidityStartDate   <= $session.system_date
                                                                            
  association [0..1] to I_EngagementProjectSrvcOrgText as _DeliveryOrgText  on  _DeliveryOrgText.EngagementProjectServiceOrg = $projection.ProjDmndRequestedDeliveryOrg
                                                                            and _DeliveryOrgText.Language                    = $session.system_language

{

  key ProjectDemandWorkUUID,


      ProjectDemandUUID,

      ProjectUUID,

      ReferencedObjectUUID,

      CostCenter,

      ActivityType,

      ProjDmndAssgmtStatus,
      ProjectElementWorkItem,
      ProjDmndBillingControlCategory,
      ProjDmndRequestedDeliveryOrg,
      ProjDmndAssgmtIsInconsistent,

      CreatedByUser,
      CreationDateTime,
      LastChangedByUser,
      LastChangeDateTime,

      /* Associations */

      _Root,

      _CostCenterActType,
      _CostCenter,

      _ResourceAssignment,
      @Semantics.valueRange.maximum: '1'
      _ResourceRequest,
      _CostCenterText,
      _ActivityTypeText,
      _ResourceTypeText,
      _DeliveryOrgText


}

Learn More