I_ProjectDemandWork

DDL: I_PROJECTDEMANDWORK Type: view BASIC Package: PS_DMND_VDM_WORK

Project Demand for Resource

I_ProjectDemandWork is a Basic CDS View that provides data about "Project Demand for Resource" in SAP S/4HANA. It reads from 1 data source (R_ProjectDemandWork) and exposes 17 fields with key field ProjectDemandWorkUUID. It has 4 associations to related views. Part of development package PS_DMND_VDM_WORK.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
R_ProjectDemandWork R_ProjectDemandWork from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_ProjectDemand _Root $projection.ProjectDemandUUID = _Root.ProjectDemandUUID
[0..*] I_ProjDmndResourceAssignment _ResourceAssignment $projection.ProjectDemandWorkUUID = _ResourceAssignment.ProjectDemandWorkUUID
[0..*] I_ProjectDemandResourceRequest _ProjDmndRsceReq $projection.ProjectDemandWorkUUID = _ProjDmndRsceReq.ProjectDemandWorkUUID
[0..*] I_CostCenter _CostCenter $projection.CostCenter = _CostCenter.CostCenter

Annotations (18)

NameValueLevelField
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName IPROJDMNDWORK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey ProjectDemandWorkUUID view
ObjectModel.sapObjectNodeType.name DemandResource view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Project Demand for Resource view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandWorkUUID ProjectDemandWorkUUID
ProjectDemandUUID ProjectDemandUUID
CostCenter CostCenter
ActivityType ActivityType
ProjDmndAssgmtStatus ProjDmndAssgmtStatus
ProjectElementWorkItem ProjectElementWorkItem
ProjDmndBillingControlCategory ProjDmndBillingControlCategory
ProjDmndRequestedDeliveryOrg ProjDmndRequestedDeliveryOrg
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_Root _Root
_ResourceAssignment _ResourceAssignment
_ProjDmndRsceReq _ProjDmndRsceReq
_CostCenterActType _CostCenterActType
_CostCenter _CostCenter 
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:  #PUBLIC_LOCAL_API

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED

@AbapCatalog: {
    sqlViewName: 'IPROJDMNDWORK',
    compiler.compareFilter: true,
    preserveKey:true
}

@ObjectModel: {
   modelingPattern: #ANALYTICAL_DIMENSION,
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #EXTRACTION_DATA_SOURCE ],
   semanticKey:       ['ActivityType' ],
   representativeKey: 'ProjectDemandWorkUUID',
   sapObjectNodeType.name: 'DemandResource',
   usageType: {
     serviceQuality:  #B,
     dataClass:       #TRANSACTIONAL,
     sizeCategory:    #XL
   }
}

@Analytics: {
  dataExtraction: {
    enabled: true,
    delta.changeDataCapture: {
      automatic: true
    }
  }
}
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Project Demand for Resource'

define view I_ProjectDemandWork
  as select from R_ProjectDemandWork

  association [1..1] to I_ProjectDemand                as _Root               on  $projection.ProjectDemandUUID = _Root.ProjectDemandUUID
  association [0..*] to I_ProjDmndResourceAssignment   as _ResourceAssignment on  $projection.ProjectDemandWorkUUID = _ResourceAssignment.ProjectDemandWorkUUID
  association [0..*] to I_ProjectDemandResourceRequest as _ProjDmndRsceReq    on  $projection.ProjectDemandWorkUUID = _ProjDmndRsceReq.ProjectDemandWorkUUID
  association [0..*] to I_CostCenter                   as _CostCenter         on  $projection.CostCenter = _CostCenter.CostCenter

{

  key ProjectDemandWorkUUID          as ProjectDemandWorkUUID,
      ProjectDemandUUID              as ProjectDemandUUID,
      CostCenter                     as CostCenter,
      ActivityType                   as ActivityType,
      ProjDmndAssgmtStatus           as ProjDmndAssgmtStatus,
      ProjectElementWorkItem         as ProjectElementWorkItem,
      ProjDmndBillingControlCategory as ProjDmndBillingControlCategory,
      ProjDmndRequestedDeliveryOrg   as ProjDmndRequestedDeliveryOrg,
      //ProjDmndAssgmtIsInconsistent   as ProjDmndAssgmtIsInconsistent,


      @Semantics.user.createdBy: true
      CreatedByUser                  as CreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      CreationDateTime               as CreationDateTime,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser              as LastChangedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      LastChangeDateTime             as LastChangeDateTime,
      
      /* Associations */
      _Root,
      _ResourceAssignment,
      _ProjDmndRsceReq,

      _CostCenterActType,
      _CostCenter

}

Learn More