I_EntProjTeamRoleStaffInternal

DDL: I_ENTPROJTEAMROLESTAFFINTERNAL Type: view_entity COMPOSITE

Project Team Role Staffing Internal

I_EntProjTeamRoleStaffInternal is a Composite CDS View that provides data about "Project Team Role Staffing Internal" in SAP S/4HANA. It reads from 3 data sources (I_EntProjectEntitlement, I_EnterpriseProjectTeamMember, I_EnterpriseProjectRole) and exposes 7 fields with key field TeamMemberUUID. It has 1 association to related views.

3 data source(s) 7 fields

Data Sources (3)

SourceAliasJoin Type
I_EntProjectEntitlement Entitlement inner
I_EnterpriseProjectTeamMember ProjectMember from
I_EnterpriseProjectRole ProjectRole inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BusinessUser _BusinessUser $projection.ProjectManagerUUID = _BusinessUser.BusinessPartnerUUID

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Project Team Role Staffing Internal view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY TeamMemberUUID I_EnterpriseProjectTeamMember TeamMemberUUID
ProjectUUID I_EnterpriseProjectTeamMember ProjectUUID
ProjectManagerUUID I_EnterpriseProjectTeamMember BusinessPartnerUUID
BusinessPartner _BusinessUser BusinessPartner
PersonFullName _BusinessUser PersonFullName
_Project I_EnterpriseProjectTeamMember _Project
_BusinessUser _BusinessUser 
@AccessControl.authorizationCheck: #CHECK 

@EndUserText.label: 'Project Team Role Staffing Internal'
@VDM.viewType: #COMPOSITE
@ObjectModel: {

    usageType: {
      dataClass:       #MIXED,
      serviceQuality:  #C,
      sizeCategory:    #L
    }
}

define view entity I_EntProjTeamRoleStaffInternal 

  as select from I_EnterpriseProjectTeamMember as ProjectMember 

    inner join   I_EntProjectEntitlement       as Entitlement on  Entitlement.ProjectUUID    = ProjectMember.ProjectUUID 

                                                              and Entitlement.TeamMemberUUID = ProjectMember.TeamMemberUUID 

 

    inner join   I_EnterpriseProjectRole       as ProjectRole on  ProjectRole.ProjectRoleUUID     = Entitlement.ProjectRoleUUID 

                                                              and ProjectRole.ProjectRoleCategory = 'PM' 

  association [0..1] to I_BusinessUser             as _BusinessUser      on $projection.ProjectManagerUUID = _BusinessUser.BusinessPartnerUUID 

{ 

  key ProjectMember.TeamMemberUUID         as TeamMemberUUID, 
      
      @ObjectModel.foreignKey.association: '_Project'  
      ProjectMember.ProjectUUID      as ProjectUUID, 

      ProjectMember.BusinessPartnerUUID as ProjectManagerUUID, 

      _BusinessUser.BusinessPartner, 

      _BusinessUser.PersonFullName,

 

      //      ProjectRole.ProjectRoleUUID       as ProjectRoleUUID, 

      ProjectMember._Project,
      _BusinessUser
}

Learn More