I_ProjectDemandWorkTP

DDL: I_PROJECTDEMANDWORKTP SQL: IPROJDMNDWORKTP Type: view_entity TRANSACTIONAL

Project Demand for Resource - TP

I_ProjectDemandWorkTP is a Transactional CDS View that provides data about "Project Demand for Resource - TP" in SAP S/4HANA. It reads from 1 data source (R_ProjectDemandWork) and exposes 22 fields with key field ProjectDemandWorkUUID. It has 2 associations to related views.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
R_ProjectDemandWork R_ProjectDemandWork from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ProjDmndResourceAssignmentTP _ResourceAssignment
[0..*] R_ProjDmndResourceRequestTP _ResourceRequest

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey ProjectDemandWorkUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Project Demand for Resource - TP view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandWorkUUID ProjectDemandWorkUUID
ProjectDemandUUID ProjectDemandUUID
ProjectUUID ProjectUUID
ReferencedObjectUUID ReferencedObjectUUID
CostCenter CostCenter
ActivityType ActivityType
ProjDmndAssgmtStatus ProjDmndAssgmtStatus
ProjectElementWorkItem ProjectElementWorkItem
ProjDmndBillingControlCategory ProjDmndBillingControlCategory
ProjDmndRequestedDeliveryOrg ProjDmndRequestedDeliveryOrg
ProjDmndAssgmtIsInconsistent ProjDmndAssgmtIsInconsistent
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_Root _Root
_CostCenterActType _CostCenterActType
_CostCenter _CostCenter
_ResourceAssignment _ResourceAssignment
_ResourceRequest _ResourceRequest
_CostCenterText _CostCenterText
_ActivityTypeText _ActivityTypeText 
//@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
      
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_PROJECTDEMANDWORK"
],
"ASSOCIATED":
[
"I_COSTCENTER",
"I_COSTCENTERACTIVITYTYPECTRL",
"I_COSTCENTERACTIVITYTYPETEXT",
"I_COSTCENTERTEXT",
"I_PROJDMNDRESOURCEASSIGNMENTTP",
"I_PROJECTDEMANDTP",
"R_PROJDMNDRESOURCEREQUESTTP"
],
"BASE":
[
"R_PROJECTDEMANDWORK"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More