I_ENTERPRISEPROJECTTEAMMEMBER

CDS View

Team Member of Enterprise Project

I_ENTERPRISEPROJECTTEAMMEMBER is a CDS View in S/4HANA. Team Member of Enterprise Project. It contains 4 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 4 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_EntProjectTeamMemberUser view_entity from COMPOSITE EntProject Team Members and their users
I_EntProjTeamRoleStaffInternal view_entity from COMPOSITE Project Team Role Staffing Internal
I_PPM_ProjectManager view from COMPOSITE Enterprise Project Manager
P_CUSTPROJSLSORDITMBYUSER view inner COMPOSITE
P_EngmntProjectRoleAssgmt view left_outer COMPOSITE
P_EngmntProjWithStdRoles view left_outer COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY TeamMemberUUID TeamMemberUUID 3
_Project _Project 1
BusinessPartnerUUID BusinessPartnerUUID,ProjectManagerUUID 4
ProjectUUID ProjectUUID 3 
@EndUserText.label: 'Team Member of Enterprise Project'

@AbapCatalog: {
    sqlViewName: 'IENTPROJTEAMMBR',
    compiler.compareFilter: true,
    preserveKey: true,
    dataMaintenance: #RESTRICTED
}

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
   representativeKey: 'TeamMemberUUID',
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #EXTRACTION_DATA_SOURCE ],
   usageType: {
     serviceQuality:  #A,
     dataClass:       #MASTER,
     sizeCategory:    #L
   }
}

@Metadata.ignorePropagatedAnnotations: true

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:  #PUBLIC_LOCAL_API

@Analytics.dataExtraction: {
        enabled: true
}

@Analytics.dataExtraction.delta.changeDataCapture.automatic: true

define view I_EnterpriseProjectTeamMember as select from /s4ppm/teammbr as TeamMember 
  association [1..1] to I_EnterpriseProject          as _Project            on $projection.ProjectUUID = _Project.ProjectUUID
  association [0..*] to I_EntProjectEntitlement      as _Entitlement        on $projection.TeamMemberUUID = _Entitlement.TeamMemberUUID

// can not be exposed as BuPa UUID is not key

//  association [1..1] to I_BusinessPartner            as _BusinessPartner    on $projection.BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID

 
{
  key guid      as TeamMemberUUID, 
//  @ObjectModel.foreignKey.association: '_BusinessPartner'

  bupa_guid     as BusinessPartnerUUID, 
  @ObjectModel.foreignKey.association: '_Project'  
  project_guid  as ProjectUUID, 
  @Semantics.user.createdBy: true
  created_by    as CreatedByUser,
  //@Semantics.systemDateTime.createdAt: true

  created_on    as CreationDateTime,
  @Semantics.user.lastChangedBy: true
  changed_by    as LastChangedByUser,
  //@Semantics.systemDateTime.lastChangedAt: true

  changed_on    as LastChangeDateTime,

  /* Associations */ 
  _Project,
  _Entitlement 

//  _BusinessPartner

  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/S4PPM/TEAMMBR"
],
"ASSOCIATED":
[
"I_ENTERPRISEPROJECT",
"I_ENTPROJECTENTITLEMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More