I_RESPYMGMTDIRECTSUPERTEAM

CDS View

Basic view for direct super teams of a team

I_RESPYMGMTDIRECTSUPERTEAM is a CDS View in S/4HANA. Basic view for direct super teams of a team. It contains 2 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 2 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_MfgBPResponsibility view inner CONSUMPTION Manufacturing User Responsibilities
I_RespyMgmtSuperTeamDetail view from COMPOSITE View for Super Team Detail

Fields (2)

KeyField CDS FieldsUsed in Views
KEY RespyMgmtSuperTeamID RespyMgmtSuperTeamID 1
KEY RespyMgmtTeamID RespyMgmtTeamID 1 
@AbapCatalog.sqlViewName: 'IRESPYMGMTSUPRTM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Basic view for direct super teams of a team'
define view I_RespyMgmtDirectSuperTeam
  as select from P_RespyMgmtSuperTeam as SuperTeam
  //    left outer join P_RespyMgmtTeamHeader as SuperTeamDetails on SuperTeamDetails.RespyMgmtTeamID = SuperTeam.RespyMgmtSuperTeamID

  association [0..1] to I_RespyMgmtTeamHeaderDetail    as _TeamHeaderDetail  on SuperTeam.RespyMgmtSuperTeamID = _TeamHeaderDetail.RespyMgmtTeamID
  //  association [0..1] to P_RespyMgmtTeamType            as _RespyMgmtTeamType  on _RespyMgmtTeamType.RespyMgmtTeamType = _TeamHeader.RespyMgmtTeamType

  association [0..*] to I_RespyMgmtSuperTeamOfAllLevel as _AllLevelSuperTeam on $projection.RespyMgmtTeamID = _AllLevelSuperTeam.RespyMgmtTeamID
{
  key SuperTeam.RespyMgmtTeamID                               as RespyMgmtTeamID,
  key SuperTeam.RespyMgmtSuperTeamID                          as RespyMgmtSuperTeamID,
      //      SuperTeamDetails.TeamName                               as RespyMgmtSuperTeamName,

      //      SuperTeamDetails.TeamType                               as RespyMgmtSuperTeamType,

      //      SuperTeamDetails.TeamStatus                             as RespyMgmtSuperTeamStatus,

      //      SuperTeamDetails.TeamDescription                        as RespyMgmtSuperTeamDescription,

      //      SuperTeamDetails.TeamCategory                           as RespyMgmtSuperTeamCategory,

      //      SuperTeamDetails.CreationDateTime                       as CreationDateTime,

      //      SuperTeamDetails.CreatedByUser                          as CreatedByUser,

      //      SuperTeamDetails.LastChangeDateTime                     as LastChangeDateTime,

      //      SuperTeamDetails.LastChangedByUser                      as LastChangedByUser,

      //      SuperTeamDetails.StartDate                              as StartDate,

      //      SuperTeamDetails.EndDate                                as EndDate,

      _AllLevelSuperTeam,
      _TeamHeaderDetail
      //      _RespyMgmtTeamType


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

Learn More