R_ENTERPRISEPROJECTTEAMMEMBER

CDS View

Team Member of Enterprise Project

R_ENTERPRISEPROJECTTEAMMEMBER is a CDS View in S/4HANA. Team Member of Enterprise Project. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_EntProjectTeamMemberTP view_entity from TRANSACTIONAL Appl Interface for Ent Proj Team member 
@ObjectModel: {
   semanticKey:       [ 'TeamMemberUUID' ],
//   representativeKey: 'TeamMemberUUID',   

   usageType:{
     serviceQuality:  #C,
     dataClass:       #MASTER,
     sizeCategory:    #L
   }
 }
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #SAP_INTERNAL_API
}
 
@AccessControl.authorizationCheck: #MANDATORY 
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Team Member of Enterprise Project'

@Metadata.ignorePropagatedAnnotations: true 
 

define view entity R_EnterpriseProjectTeamMember 
as select from /s4ppm/teammbr as TeamMember 
  association [1..1] to R_EnterpriseProject        as _Project            on $projection.ProjectUUID = _Project.ProjectUUID
  association [0..*] to I_EntProjectEntitlement    as _Entitlement        on $projection.TeamMemberUUID = _Entitlement.TeamMemberUUID
  association [1..1] to I_BusinessPartner          as _BusinessPartner    on $projection.BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID

// 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,  
  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
  
}

Learn More