I_RespyMgmtTeamHeader

@AbapCatalog.sqlViewName: 'ITEAMHEADER'

@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: [ '_AllLevelSuperTeam' ]
//@AccessControl.personalData.blocking: #REQUIRED

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.semanticKey:  [ 'RespyMgmtTeamName' ]
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'RespyMgmtTeamID'
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Basic View for Team Header'
define view I_RespyMgmtTeamHeader
  as select from P_RespyMgmtTeamHeader as Team
  //    association [0..1] to I_RespyMgmtTeamType            as _RespyMgmtTeamType on _RespyMgmtTeamType.RespyMgmtTeamType = Team.TeamType

  association [0..*] to I_RespyMgmtSuperTeamOfAllLevel as _AllLevelSuperTeam on Team.RespyMgmtTeamID = _AllLevelSuperTeam.RespyMgmtTeamID
  //    association [0..1] to I_User as _User on _User.UserID = Team.CreatedByUser

{
      @ObjectModel.text.element: 'RespyMgmtTeamDescription'
  key Team.RespyMgmtTeamID                            as RespyMgmtTeamID,
      cast(Team.TeamName as rsm_de_team_name)         as RespyMgmtTeamName,
      Team.RespyMgmtGlobalTeamID,
      Team.TeamName                                   as RespyMgmtTeamNameForSearch,
      @Semantics.text: true
      cast(Team.TeamDescription as rsm_de_team_descr) as RespyMgmtTeamDescription,
      Team.TeamDescription                            as RespyMgmtTeamDescForSearch,
      Team.TeamStatus                                 as RespyMgmtTeamStatus,
      Team.TeamType                                   as RespyMgmtTeamType,
      Team.TeamCategory                               as RespyMgmtTeamCategory,
      Team.CreationDateTime                           as CreationDateTime,
      Team.CreatedByUser                              as CreatedByUser,
      Team.LastChangeDateTime                         as LastChangeDateTime,
      Team.LastChangedByUser                          as LastChangedByUser,
      Team.StartDate                                  as StartDate,
      Team.EndDate                                    as EndDate,
      cast('' as char255 )                            as RespyMgmtAttributeNameValPair,
      cast('' as char1 preserving type )              as RespyMgmtTeamHasSubTeam,
      _AllLevelSuperTeam
      //      _User

};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_RESPYMGMTTEAMHEADER"
],
"ASSOCIATED":
[
"I_RESPYMGMTSUPERTEAMOFALLLEVEL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/