I_EngmntProjRole

DDL: I_ENGMNTPROJROLE SQL: IENGMNTPROJROLE Type: view COMPOSITE

Engagement Project Roles

I_EngmntProjRole is a Composite CDS View that provides data about "Engagement Project Roles" in SAP S/4HANA. It reads from 1 data source (I_EngagementProject) and exposes 16 fields with key field EngagementProject. It has 1 association to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_EngagementProject EngagementProject from

Associations (1)

CardinalityTargetAliasCondition
[1..*] P_EngagementProjectRole EnagementProjectRole EngagementProject.EngagementProject = EnagementProjectRole.EngagementProject

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IENGMNTPROJROLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Engagement Project Roles view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY EngagementProject I_EngagementProject EngagementProject
EngagementProjectType I_EngagementProject EngagementProjectType
EngagementProjectServiceOrg I_EngagementProject EngagementProjectServiceOrg
EngagementProjectCategory I_EngagementProject EngagementProjectCategory
ProjectAccountant
ProjectController
ProjectPartner
ProjectManager
ProjectManagerExternalID
ProjectManagerName
ProjectAccountantExternalID
ProjectAccountantName
ProjectControllerExternalID
ProjectControllerName
ProjectPartnerExternalID
ProjectPartnerName 
@AbapCatalog.sqlViewName: 'IENGMNTPROJROLE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'Engagement Project Roles'
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view I_EngmntProjRole
  as select from I_EngagementProject as EngagementProject
  association [1..*] to P_EngagementProjectRole as EnagementProjectRole on EngagementProject.EngagementProject = EnagementProjectRole.EngagementProject
{
  key EngagementProject.EngagementProject                                                       as EngagementProject,
      EngagementProject.EngagementProjectType                                                   as EngagementProjectType,
      EngagementProject.EngagementProjectServiceOrg                                             as EngagementProjectServiceOrg,
      EngagementProject.EngagementProjectCategory                                               as EngagementProjectCategory,
      max(EnagementProjectRole.ProjectAccountant)                                               as ProjectAccountant,
      max(EnagementProjectRole.ProjectController)                                               as ProjectController,
      max(EnagementProjectRole.ProjectPartner)                                                  as ProjectPartner,
      max(EnagementProjectRole.ProjectManager)                                                  as ProjectManager,
      max(EnagementProjectRole.ProjectManagerExternalID)                                        as ProjectManagerExternalID,
      max(EnagementProjectRole.ProjectManagerName)                                              as ProjectManagerName,
      max(EnagementProjectRole.ProjectAccountantExternalID)                                     as ProjectAccountantExternalID,
      max(EnagementProjectRole.ProjectAccountantName)                                           as ProjectAccountantName,
      max(EnagementProjectRole.ProjectControllerExternalID)                                     as ProjectControllerExternalID,
      max(EnagementProjectRole.ProjectControllerName)                                           as ProjectControllerName,
      max(EnagementProjectRole.ProjectPartnerExternalID)                                        as ProjectPartnerExternalID,
      max(EnagementProjectRole.ProjectPartnerName)                                              as ProjectPartnerName
}
group by
  EngagementProject.EngagementProject,
  EngagementProject.EngagementProjectType,
  EngagementProject.EngagementProjectServiceOrg,
  EngagementProject.EngagementProjectCategory
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENGAGEMENTPROJECT",
"P_ENGAGEMENTPROJECTROLE"
],
"ASSOCIATED":
[
"P_ENGAGEMENTPROJECTROLE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More