I_EntProjTeamMbrRoleStaffing

DDL: I_ENTPROJTEAMMBRROLESTAFFING Type: view_entity COMPOSITE Package: VDM_PPM_OBJECTS_TEAMMEMBER

Team Member Role Staffing of Enterprise Project

I_EntProjTeamMbrRoleStaffing is a Composite CDS View that provides data about "Team Member Role Staffing of Enterprise Project" in SAP S/4HANA. It reads from 3 data sources (I_EntProjectEntitlement, I_EnterpriseProjectTeamMember, I_EnterpriseProjectRole) and exposes 6 fields with key field ProjectEntitlementUUID. It has 1 association to related views. Part of development package VDM_PPM_OBJECTS_TEAMMEMBER.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
I_EntProjectEntitlement ProjectEntitlement from
I_EnterpriseProjectTeamMember ProjectMember inner
I_EnterpriseProjectRole ProjectRole inner

Associations (1)

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

Annotations (6)

NameValueLevelField
EndUserText.label Team Member Role Staffing of Enterprise Project view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ProjectEntitlementUUID I_EntProjectEntitlement ProjectEntitlementUUID
ProjectUUID I_EnterpriseProjectTeamMember ProjectUUID
BusinessPartnerUUID I_EnterpriseProjectTeamMember BusinessPartnerUUID
ProjectRoleCategory I_EnterpriseProjectRole ProjectRoleCategory
UserID _BusinessUser UserID
_Project I_EnterpriseProjectTeamMember _Project 
@EndUserText.label: 'Team Member Role Staffing of Enterprise Project'
@VDM.viewType: #COMPOSITE
@ObjectModel: {

    usageType: {
      dataClass:       #MASTER,
      serviceQuality:  #C,
      sizeCategory:    #L
    }
}
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view entity I_EntProjTeamMbrRoleStaffing
  as select from I_EntProjectEntitlement       as ProjectEntitlement
  
    inner join   I_EnterpriseProjectTeamMember as ProjectMember on  ProjectEntitlement.ProjectUUID     = ProjectMember.ProjectUUID 
                                                                and ProjectEntitlement.TeamMemberUUID  = ProjectMember.TeamMemberUUID 
                                                              
    inner join   I_EnterpriseProjectRole       as ProjectRole on  ProjectRole.ProjectUUID     = ProjectMember.ProjectUUID 
                                                              and ProjectRole.ProjectRoleUUID = ProjectEntitlement.ProjectRoleUUID 
    

  association [0..1] to I_BusinessUser             as _BusinessUser      on $projection.BusinessPartnerUUID = _BusinessUser.BusinessPartnerUUID 
{
  key ProjectEntitlement.ProjectEntitlementUUID         as ProjectEntitlementUUID, 
      
      @ObjectModel.foreignKey.association: '_Project'  
      ProjectMember.ProjectUUID      as ProjectUUID, 
      ProjectMember.BusinessPartnerUUID, 
      ProjectRole.ProjectRoleCategory,
      _BusinessUser.UserID, 

      ProjectMember._Project
}

Learn More