P_EngmtProjStaffedResource

DDL: P_ENGMTPROJSTAFFEDRESOURCE SQL: PENGSTFRES Type: view COMPOSITE Package: CPD_CDS

Engagement Project Staffed Resource

P_EngmtProjStaffedResource is a Composite CDS View that provides data about "Engagement Project Staffed Resource" in SAP S/4HANA. It reads from 1 data source (I_EngmntProjectPlnDataVersion) and exposes 20 fields with key fields EngagementProject, WorkPackage, EngagementProjectResource, ResourceDemandUUID, EngagementProjectServiceOrg. It has 2 associations to related views. Part of development package CPD_CDS.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_EngmntProjectPlnDataVersion EngmntProjectPlnDataVersion from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_PersnWrkAgreementDet _PersonWorkAgreementDet $projection.EmploymentInternalID = _PersonWorkAgreementDet.PersonWorkAgreement
[0..1] I_EngagementProjectSrvcOrg _EngagementProjectServiceOrg $projection.EngagementProjectServiceOrg = _EngagementProjectServiceOrg.EngagementProjectServiceOrg

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PENGSTFRES view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY EngagementProject EngagementProject
KEY WorkPackage WorkPackage
KEY EngagementProjectResource EngagementProjectResource
KEY ResourceDemandUUID ResourceDemandUUID
KEY EngagementProjectServiceOrg EngagementProjectServiceOrg
KEY EmploymentInternalID EmploymentInternalID
KEY EngagementProjectResourceType EngagementProjectResourceType
WorkItem WorkItem
Currency Currency
UnitOfMeasure UnitOfMeasure
PlndEffortQty
PlndCostAmt
_Currency _Currency
_EngagementProject _EngagementProject
_EngagementProjectResource _EngagementProjectResource
_PlanSkillTags _PlanSkillTags
_UnitOfMeasure _UnitOfMeasure
_EngagementProjectServiceOrg _EngagementProjectServiceOrg
_PersonWorkAgreementDet _PersonWorkAgreementDet
_EngmntProjResourceType _EngmntProjResourceType 
@AbapCatalog.sqlViewName: 'PENGSTFRES'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Engagement Project Staffed Resource'

@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_EngmtProjStaffedResource
  as select from I_EngmntProjectPlnDataVersion as EngmntProjectPlnDataVersion
  association [0..*] to I_PersnWrkAgreementDet     as _PersonWorkAgreementDet      on $projection.EmploymentInternalID = _PersonWorkAgreementDet.PersonWorkAgreement
  association [0..1] to I_EngagementProjectSrvcOrg as _EngagementProjectServiceOrg on $projection.EngagementProjectServiceOrg = _EngagementProjectServiceOrg.EngagementProjectServiceOrg

{
  key EngagementProject,
  key WorkPackage,
  key EngagementProjectResource,
  key ResourceDemandUUID,
  key EngagementProjectServiceOrg,
  key EmploymentInternalID,
  key EngagementProjectResourceType,
      WorkItem,
      
      Currency,
      
      UnitOfMeasure,
      
      sum(EngmntProjectPlnDataVersion.PlndEffortQty) as PlndEffortQty,
      //Supply total cost

      
      sum(EngmntProjectPlnDataVersion.PlndCostAmt)   as PlndCostAmt,
      /* Associations */
      //EngmntProjectPlnDataVersion

      _Currency,
      _EngagementProject,
      _EngagementProjectResource,
      _PlanSkillTags,
      _UnitOfMeasure,
      _EngagementProjectServiceOrg,
      _PersonWorkAgreementDet,
      _EngmntProjResourceType
}

where
      EngmntProjectPlnDataVersion.EngmntProjPlanLineType  = 'S'
  and EngmntProjectPlnDataVersion.EngmtProjFinPlanVersion = '1'
// and    EngmntProjectPlnDataVersion.EngagementProjectResourceType = '0ACT'



group by
  EngagementProject,
  WorkPackage,
  WorkItem,
  EngagementProjectResource,
  EngagementProjectResourceType,
  ResourceDemandUUID,
  Currency,
  UnitOfMeasure,
  EmploymentInternalID,
  EngagementProjectServiceOrg

Learn More