I_EnterpriseProjectTeamMember

DDL: I_ENTERPRISEPROJECTTEAMMEMBER Type: view BASIC

Team Member of Enterprise Project

I_EnterpriseProjectTeamMember is a Basic CDS View that provides data about "Team Member of Enterprise Project" in SAP S/4HANA. It reads from 1 data source (/s4ppm/teammbr) and exposes 9 fields with key field TeamMemberUUID. It has 2 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
/s4ppm/teammbr TeamMember from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_EnterpriseProject _Project $projection.ProjectUUID = _Project.ProjectUUID
[0..*] I_EntProjectEntitlement _Entitlement $projection.TeamMemberUUID = _Entitlement.TeamMemberUUID

Annotations (17)

NameValueLevelField
EndUserText.label Team Member of Enterprise Project view
AbapCatalog.sqlViewName IENTPROJTEAMMBR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey TeamMemberUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY TeamMemberUUID guid
BusinessPartnerUUID bupa_guid
ProjectUUID project_guid
CreatedByUser created_by
CreationDateTime created_on
LastChangedByUser changed_by
LastChangeDateTime changed_on
_Project _Project
_Entitlement _Entitlement 
@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