I_ProjDmndResourceAssignmentTP

DDL: I_PROJDMNDRESOURCEASSIGNMENTTP Type: view_entity TRANSACTIONAL Package: PS_DMND_VDM_WORK

Resource Assignment to Resource Dmnd - TP

I_ProjDmndResourceAssignmentTP is a Transactional CDS View that provides data about "Resource Assignment to Resource Dmnd - TP" in SAP S/4HANA. It reads from 1 data source (R_ProjDmndResourceAssignment) and exposes 26 fields with key field ProjDmndRsceAssgmtUUID. It has 3 associations to related views. Part of development package PS_DMND_VDM_WORK.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
R_ProjDmndResourceAssignment R_ProjDmndResourceAssignment from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ProjectDemandTP _Root $projection.ProjectDemandUUID = _Root.ProjectDemandUUID
[1..1] I_EntProjWrkAgrmtDetails _WrkAgrmtDetails $projection.ProjDmndRsceAssgmt = _WrkAgrmtDetails.PersonWorkAgreement
[0..*] R_ProjDmndRsceAssgmtDistrTP _AssgmtDistribution

Annotations (8)

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

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ProjDmndRsceAssgmtUUID ProjDmndRsceAssgmtUUID
ProjectDemandWorkUUID ProjectDemandWorkUUID
ProjectDemandUUID ProjectDemandUUID
ProjDmndRsceAssgmt ProjDmndRsceAssgmt
ProjDmndRsceAssgmtQuantity ProjDmndRsceAssgmtQuantity
ProjDmndRsceAssgmtQuantityUnit ProjDmndRsceAssgmtQuantityUnit
ProjectUUID ProjectUUID
ReferencedObjectUUID ReferencedObjectUUID
ProjectDemandSupplyIdentifier ProjectDemandSupplyIdentifier
ProjectDemandSupplyDeliveryOrg ProjectDemandSupplyDeliveryOrg
ProjectDemandSourceOfSupply ProjectDemandSourceOfSupply
ProjAssgmtLastUpdateSource ProjAssgmtLastUpdateSource
ProjDmndRsceWorkAssgmtOID ProjDmndRsceWorkAssgmtOID
ProjDmndRsceWrkfrcPersonOID ProjDmndRsceWrkfrcPersonOID
ProjDmndRsceAssgmtStartDate ProjDmndRsceAssgmtStartDate
ProjDmndRsceAssgmtEndDate ProjDmndRsceAssgmtEndDate
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_WrkAgrmtDetails _WrkAgrmtDetails
_PersonWorkAgreement _PersonWorkAgreement
_Root _Root
_Work _Work
_RsceAssgmtQuantityUnit _RsceAssgmtQuantityUnit
_AssgmtDistribution _AssgmtDistribution 
@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

}

Learn More