I_PPM_TeamMemberRoleStaffingTP

DDL: I_PPM_TEAMMEMBERROLESTAFFINGTP SQL: IPPMTEAMMROLSTTP Type: view TRANSACTIONAL

Team Member Role Staffing Transactional

I_PPM_TeamMemberRoleStaffingTP is a Transactional CDS View that provides data about "Team Member Role Staffing Transactional" in SAP S/4HANA. It reads from 1 data source (I_PPM_TeamMemberRoleStaffing) and exposes 21 fields with key field StaffingUUID. It has 2 associations to related views.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_PPM_TeamMemberRoleStaffing RoleStaffing from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PPM_ProjectTP _Root $projection.ProjectUUID = _Root.ProjectUUID
[1..1] I_PPM_TeamMember _TeamMember RoleStaffing.ProjectUUID = _TeamMember.ProjectUUID and RoleStaffing.BusinessPartnerUUID = _TeamMember.BusinessPartnerUUID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IPPMTEAMMROLSTTP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Team Member Role Staffing Transactional view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.writeDraftPersistence PPM_TEAM_ROLST_D view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY StaffingUUID StaffingUUID
TeamMemberUUID _TeamMember TeamMemberUUID
ProjectRoleUUID ProjectRoleUUID
BusinessPartnerUUID BusinessPartnerUUID
ProjectSummaryTaskUUID ProjectSummaryTaskUUID
ProjectUUID ProjectUUID
BusinessPartner I_PPM_TeamMemberRoleStaffing BusinessPartner
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
ProjectRoleType ProjectRoleType
ProjectRoleCategory ProjectRoleCategory
_BusinessUser _BusinessUser
_Root _Root
_ProjectRoleType _ProjectRoleType
_ProjectRoleTypeCategory _ProjectRoleTypeCategory
_ProjectRoleText _ProjectRoleText
_ProjectRoleTypeText _ProjectRoleTypeText
_ProjectRoleTypeCategoryText _ProjectRoleTypeCategoryText
_ProjectRoot _ProjectRoot 
@AbapCatalog.sqlViewName: 'IPPMTEAMMROLSTTP'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Team Member Role Staffing Transactional'

@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #D 
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED

@ObjectModel:
  {
    writeDraftPersistence: 'PPM_TEAM_ROLST_D',
    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    representativeKey: [ 'StaffingUUID' ]
  }


define view I_PPM_TeamMemberRoleStaffingTP as select from I_PPM_TeamMemberRoleStaffing as RoleStaffing
  association [1..1] to I_PPM_ProjectTP    as _Root       on  $projection.ProjectUUID = _Root.ProjectUUID 
  association [1..1] to I_PPM_TeamMember as _TeamMember on  RoleStaffing.ProjectUUID = _TeamMember.ProjectUUID
                                                          and RoleStaffing.BusinessPartnerUUID = _TeamMember.BusinessPartnerUUID
{
  //I_PPM_TeamMemberRoleStaffing 

  key StaffingUUID, 

  _TeamMember.TeamMemberUUID,
  
  ProjectRoleUUID, 
  BusinessPartnerUUID, 
  ProjectSummaryTaskUUID, 
  ProjectUUID, 
  
  RoleStaffing.BusinessPartner,
  
  @Semantics.user.createdBy: true
  CreatedByUser,
  @Semantics.systemDateTime.createdAt: true
  CreationDateTime,
  @Semantics.user.lastChangedBy: true
  LastChangedByUser,
  @Semantics.systemDateTime.lastChangedAt: true
  LastChangeDateTime,
  @ObjectModel.readOnly: false
  ProjectRoleType,
  ProjectRoleCategory,
    
  /* Associations */ 
  _BusinessUser,
  
  @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
  _Root, 
  
  _ProjectRoleType,
  _ProjectRoleTypeCategory,
  
  /* Texts */
  _ProjectRoleText,
  _ProjectRoleTypeText,
  _ProjectRoleTypeCategoryText,
  _ProjectRoot
} // where ProjectRoleCategory <> 'PM'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_TEAMMEMBER",
"I_PPM_TEAMMEMBERROLESTAFFING"
],
"ASSOCIATED":
[
"I_BUSINESSUSERBASIC",
"I_PPM_PROJECTROLETEXT",
"I_PPM_PROJECTROLETYPE",
"I_PPM_PROJECTROLETYPECATEGORY",
"I_PPM_PROJECTROLETYPECATTEXT",
"I_PPM_PROJECTROLETYPETEXT",
"I_PPM_PROJECTROOT",
"I_PPM_PROJECTTP",
"I_PPM_TEAMMEMBER"
],
"BASE":
[
"I_PPM_TEAMMEMBERROLESTAFFING"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More