P_EngmntProjAddlResources

DDL: P_ENGMNTPROJADDLRESOURCES Type: view COMPOSITE Package: CPD_CDS

Additional Resources

P_EngmntProjAddlResources is a Composite CDS View that provides data about "Additional Resources" in SAP S/4HANA. It reads from 2 data sources (P_EngmntProjWrkPckgPlanActual, I_WorkPackage) and exposes 14 fields with key fields EngagementProject, WorkPackage, WorkItem, EngagementProjectResource, EngagementProjectServiceOrg. Part of development package CPD_CDS.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
P_EngmntProjWrkPckgPlanActual PA from
I_WorkPackage WP left_outer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PENGADDLRECS view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #COMPOSITE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY EngagementProject P_EngmntProjWrkPckgPlanActual EngagementProject
KEY WorkPackage P_EngmntProjWrkPckgPlanActual WorkPackage
KEY WorkItem P_EngmntProjWrkPckgPlanActual WorkItem
KEY EngagementProjectResource P_EngmntProjWrkPckgPlanActual EngagementProjectResource
KEY EngagementProjectServiceOrg P_EngmntProjWrkPckgPlanActual EngagementProjectServiceOrg
Currency P_EngmntProjWrkPckgPlanActual Currency
ActlCostAmt P_EngmntProjWrkPckgPlanActual ActlCostAmt
UnitOfMeasure P_EngmntProjWrkPckgPlanActual UnitOfMeasure
ActlEffortQty P_EngmntProjWrkPckgPlanActual ActlEffortQty
PlndCostAmt P_EngmntProjWrkPckgPlanActual PlndCostAmt
PlndEffortQty P_EngmntProjWrkPckgPlanActual PlndEffortQty
EngagementProjectResourceType P_EngmntProjWrkPckgPlanActual EngagementProjectResourceType
EngmtProjFinPlanVersion P_EngmntProjWrkPckgPlanActual EngmtProjFinPlanVersion
WorkPackageName I_WorkPackage WorkPackageName 
@AbapCatalog: {
  sqlViewName: 'PENGADDLRECS',
  preserveKey: true,
  compiler.compareFilter: true
}
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #NOT_REQUIRED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Engagement Project Additional Resources'

@ObjectModel.usageType: {
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
@VDM: {
  private: true,
  lifecycle.contract.type: #NONE,
  viewType: #COMPOSITE
}
define view P_EngmntProjAddlResources 
as select from P_EngmntProjWrkPckgPlanActual as PA
left outer join I_WorkPackage as WP on PA.WorkPackage = WP.WorkPackage {
key PA.EngagementProject,
key PA.WorkPackage,
key PA.WorkItem,
key PA.EngagementProjectResource,
key PA.EngagementProjectServiceOrg,

PA.Currency,

PA.ActlCostAmt,

PA.UnitOfMeasure,

PA.ActlEffortQty,

PA.PlndCostAmt,

PA.PlndEffortQty,
PA.EngagementProjectResourceType,
PA.EngmtProjFinPlanVersion,
WP.WorkPackageName
} where PA.EngagementProjectResourceType = '0ADL'
  and PA.EngmtProjFinPlanVersion = '1'

Learn More