P_RESPYMGMTTEAMHEADERDET

CDS View

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

Used by 4 CDS view(s) 4 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_RespyMgmtTeamHeaderBasic view left_outer BASIC Team Header Basic data
I_RespyMgmtTeamHeaderDetail view left_outer BASIC Team Header Details
P_RespyMgmtRootTeamIndicator view from BASIC
P_RespyMgmtSuperTeamOfAllLevel view left_outer BASIC

Fields (4)

KeyField CDS FieldsUsed in Views
KEY ObjectID RespyMgmtTeamID 1
RespyMgmtGlobalTeamID RespyMgmtGlobalTeamID 2
TeamStatus RespyMgmtTeamStatus,TeamStatus 2
TeamType RespyMgmtSuperTeamType,RespyMgmtTeamType 3 
@AbapCatalog.sqlViewName: 'PTEAMHDRDET'
@VDM.private: true
@VDM.viewType: #BASIC

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

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

define view P_RespyMgmtTeamHeaderDet
  as select from hrp7730 as TeamDetail
{

  TeamDetail.objid        as ObjectID,
  TeamDetail.teamstatus   as TeamStatus,
  TeamDetail.teamtype     as TeamType,
  TeamDetail.globalteamid as RespyMgmtGlobalTeamID
}
where
        TeamDetail.otype = 'TH'
  and   TeamDetail.plvar = '01'
  and   TeamDetail.histo = ' '
  and   TeamDetail.istat = '1'
  and(
        TeamDetail.begda <= $session.system_date
    and TeamDetail.endda >= $session.system_date
  );

Learn More