P_RESPYMGMTTEAMHEADER

CDS View

P_RESPYMGMTTEAMHEADER is a CDS View in S/4HANA. It contains 13 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 13 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_RespyMgmtSuperTeamDetail view left_outer COMPOSITE View for Super Team Detail
I_RespyMgmtTeamHeader view from COMPOSITE Basic View for Team Header
I_RespyTeamCountPerCatAndSts view from COMPOSITE Teams per Team Category and Status

Fields (13)

KeyField CDS FieldsUsed in Views
KEY RespyMgmtTeamID RespyMgmtTeamID 1
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 2
EndDate EndDate 2
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
RespyMgmtGlobalTeamID RespyMgmtGlobalTeamID 1
StartDate StartDate 2
TeamCategory RespyMgmtSuperTeamCategory,RespyMgmtTeamCategory 2
TeamDescription RespyMgmtSuperTeamDescription,RespyMgmtTeamDescForSearch 2
TeamName RespyMgmtSuperTeamName,RespyMgmtTeamNameForSearch 2
TeamStatus RespyMgmtSuperTeamStatus,RespyMgmtTeamStatus 2
TeamType RespyMgmtSuperTeamType,RespyMgmtTeamType 2 
@AbapCatalog.sqlViewName: 'PTEAMHEADER'

@VDM.private: true
@VDM.viewType: #COMPOSITE

@AbapCatalog.compiler.compareFilter: true

@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER

define view P_RespyMgmtTeamHeader
  as select from    I_RespyMgmtTeamHeaderDetail    as Team
  //left outer join P_RespyMgmtTeamHeaderDet     as _TeamDetail      on _TeamDetail.ObjectID = Team.RespyMgmtTeamID

  //Urgent: Put condition for team details begda and endda for bringing only current records.

    left outer join I_RespyMgmtTeamDescription     as _TeamDescription on  _TeamDescription.RespyMgmtTeamID = Team.RespyMgmtTeamID
                                                                       and _TeamDescription.Language        = $session.system_language
    left outer join I_RespyMgmtTeamHeaderAdminData as _AdminData       on _AdminData.RespyMgmtTeamID = Team.RespyMgmtTeamID
  association [0..*] to I_RespyMgmtSuperTeamOfAllLevel as _AllLevelSuperTeam on $projection.RespyMgmtTeamID = _AllLevelSuperTeam.RespyMgmtTeamID
  association [0..1] to I_RespyMgmtTeamType            as _RespyMgmtTeamType on _RespyMgmtTeamType.RespyMgmtTeamType = $projection.TeamType
{
  key cast(Team.RespyMgmtTeamID as hrobjid)             as RespyMgmtTeamID,
  key _TeamDescription.Language                         as LanguageKey,
      Team.TeamName                                     as TeamName,
      Team.RespyMgmtGlobalTeamID,
      _TeamDescription.TeamDescription                  as TeamDescription,
      Team.TeamStatus                                   as TeamStatus,
      Team.RespyMgmtTeamType                            as TeamType,
      _RespyMgmtTeamType.RespyMgmtTeamCategoryForSearch as TeamCategory,
      _AdminData.CreationDateTime                       as CreationDateTime,
      _AdminData.CreatedByUser                          as CreatedByUser,
      _AdminData.LastChangeDateTime                     as LastChangeDateTime,
      _AdminData.LastChangedByUser                      as LastChangedByUser,
      Team.StartDate                                    as StartDate,
      Team.EndDate                                      as EndDate,
      _AllLevelSuperTeam
}

Learn More