I_MSTRPROJTEAMMEMBER
Master Project Team Member
I_MSTRPROJTEAMMEMBER is a CDS View in S/4HANA. Master Project Team Member. It contains 14 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_MstrProjKeyMember | view | inner | CONSUMPTION | Master Project Key Member |
| I_MstrProjTeamRespy | view | inner | COMPOSITE | Master Project Team Responsibility |
Fields (14)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BusinessPartner | BusinessPartner,BusinessPartnerUUID | 2 |
| KEY | EmployeePersonnelNumber | PersonnelNumber | 1 |
| KEY | MasterProject | MasterProject | 1 |
| KEY | MasterProjectTeamRole | MasterProjectTeamRole,ProjectRole | 2 |
| KEY | MstrProjTeamMemberUUID | MstrProjTeamMemberUUID | 1 |
| ChangedBy | ChangedBy | 1 | |
| ChangedDateTime | ChangedDateTime | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| FirstName | FirstName | 1 | |
| IndependentAddressID | IndependentAddressID | 1 | |
| LastName | LastName | 1 | |
| ProjectResponsiblePerson | Name,ProjectResponsiblePerson | 2 | |
| UserID | UserID | 1 |
@AbapCatalog.sqlViewName: 'IMPTMMEM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Master Project Team Member'
define view I_MstrProjTeamMember as select distinct from I_MasterProject as Project
inner join I_EngagementProjectTeam as ProjectTeam on Project.MasterProjectUUID = ProjectTeam.EngagementProjectUUID
left outer join I_EngagementProjectTeamRole as ProjectRoles on ProjectTeam.EngagementProjectTeamUUID = ProjectRoles.EngagementProjectTeamUUID
left outer join I_EngmtProjTeamMember as TeamMembers on ProjectRoles.EngagementProjectTeamRoleUUID = TeamMembers.EngagementProjectTeamRoleUUID
left outer join I_MstrProjMember as ProjMembers on TeamMembers.EngagementProjectMemberUUID = ProjMembers.MstrProjMemberUUID
inner join I_BusinessPartner as BPartner on ProjMembers.BusinessPartner = BPartner.BusinessPartner
association [0..1] to I_MstrProjRoleID as _ProjectRole on $projection.MasterProjectTeamRole = _ProjectRole.ProjectRole
// association [1..1] to I_EmployeeWorkplaceAddress as _Employee on $projection.BusinessPartner = _Employee.EmployeeInternalID //HRDecoupling
association [1..1] to I_WorkforcePerson as _Employee on $projection.BusinessPartner = _Employee.Person //HRDecoupling
{
key Project.MasterProject,
Project.MasterProjectUUID,
ProjectRoles.EngagementProjectTeamRole as MasterProjectTeamRole,
concat_with_space(BPartner.FirstName, BPartner.LastName,1) as ProjectResponsiblePerson,
BPartner.FirstName,
BPartner.LastName,
// _Text[1:Language = $session.system_language].ProjectRoleName as ProjectRoleName,
BPartner.IndependentAddressID,
// BPartner._AddressIndependentEmail.EmailAddress,
// case when BPartner._AddressIndependentMobile.PhoneNumberType = '3'
// then
// BPartner._AddressIndependentMobile.InternationalMobilePhoneNumber
// end as InternationalMobilePhoneNumber,
// case when BPartner._AddressIndependentPhone.PhoneNumberType = '1'
// then
// BPartner._AddressIndependentPhone.InternationalPhoneNumber
// end as InternationalPhoneNumber,
Project.StartDate,
Project.EndDate,
TeamMembers.EngmtProjTeamMemberUUID as MstrProjTeamMemberUUID,
TeamMembers.EngagementProjectMemberUUID as MstrProjMemberUUID,
ProjMembers.BusinessPartner,
ProjMembers.BusinessPartnerType,
ProjMembers.EmploymentInternalID,
ProjMembers.EmployeePersonnelNumber,
ProjMembers.CreationDate,
ProjMembers.ChangedBy,
ProjMembers.ChangedDateTime,
ProjMembers.CreatedByUser,
_Employee._BusinessUser.UserID,
_ProjectRole._Text,
_ProjectRole.ProjectRole
}