I_PROJDMNDRESOURCEASSIGNMENTTP
Resource Assignment to Resource Dmnd - TP
I_PROJDMNDRESOURCEASSIGNMENTTP is a CDS View in S/4HANA. Resource Assignment to Resource Dmnd - TP. It contains 5 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_ProjDmndResourceAssignment | view_entity | projection | COMPOSITE | Resource Assignment |
| C_EntProjDmndRsceAssignment | view_entity | from | CONSUMPTION | Project Demand Resource Assignment Data |
| C_ProjDmndResourceAssignmentTP | view_entity | projection | CONSUMPTION | Proj Dmnd Resource Assign Consumption TP |
| C_ProjDmndRsceAssgmtAllTP | view_entity | projection | CONSUMPTION | Manage Resource Assignment for All tab |
| I_ProjDmndRsceAssignmentTP_2 | view_entity | projection | TRANSACTIONAL | Resource Assignment to Resource Dmnd - TP |
Fields (5)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ProjDmndRsceAssgmt | ProjDmndRsceAssgmt | 1 |
| KEY | ProjDmndRsceAssgmtUUID | ProjDmndRsceAssgmtUUID | 1 |
| KEY | ProjectDemandUUID | ProjectDemandUUID | 1 |
| KEY | ProjectUUID | ProjectUUID | 1 |
| ProjectDemandSupplyDeliveryOrg | ProjectDemandSupplyDeliveryOrg | 1 |
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
//@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
//@AbapCatalog: {
// sqlViewName: 'IPROJDMNDRSCEATP',
// compiler.compareFilter: true,
// preserveKey:true
//}
@ObjectModel: {
semanticKey: [ 'ProjDmndRsceAssgmt' ],
// representativeKey: 'ProjDmndRsceAssgmtUUID',
// alternativeKey: ['ProjectDemandWorkUUID'],
usageType: {
serviceQuality: #A,
dataClass: #TRANSACTIONAL,
sizeCategory: #XL
}
}
@EndUserText.label: 'Resource Assignment to Resource Dmnd - TP'
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_ProjDmndResourceAssignmentTP
as select from R_ProjDmndResourceAssignment
association to parent I_ProjectDemandWorkTP as _Work on $projection.ProjectDemandWorkUUID = _Work.ProjectDemandWorkUUID
composition [0..*] of R_ProjDmndRsceAssgmtDistrTP as _AssgmtDistribution
association [1..1] to I_ProjectDemandTP as _Root on $projection.ProjectDemandUUID = _Root.ProjectDemandUUID
//RAP migration change
association [1..1] to I_EntProjWrkAgrmtDetails as _WrkAgrmtDetails on $projection.ProjDmndRsceAssgmt = _WrkAgrmtDetails.PersonWorkAgreement
{
@UI.hidden: true
key ProjDmndRsceAssgmtUUID,
@UI.hidden: true
ProjectDemandWorkUUID,
@UI.hidden: true
ProjectDemandUUID,
ProjDmndRsceAssgmt,
ProjDmndRsceAssgmtQuantity,
// @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
ProjDmndRsceAssgmtQuantityUnit,
ProjectUUID,
ReferencedObjectUUID,
ProjectDemandSupplyIdentifier,
ProjectDemandSupplyDeliveryOrg,
ProjectDemandSourceOfSupply,
ProjAssgmtLastUpdateSource,
ProjDmndRsceWorkAssgmtOID,
ProjDmndRsceWrkfrcPersonOID,
ProjDmndRsceAssgmtStartDate,
ProjDmndRsceAssgmtEndDate,
CreatedByUser,
CreationDateTime,
LastChangedByUser,
LastChangeDateTime,
/* Associations */
_WrkAgrmtDetails,
_PersonWorkAgreement,
_Root,
_Work,
_RsceAssgmtQuantityUnit,
_AssgmtDistribution
}