P_RespyMgmtRootTeamIndicator

DDL: P_RESPYMGMTROOTTEAMINDICATOR SQL: PRSMROOTTEAMIND Type: view BASIC Package: CA_RSM_TEAMS_DDIC

Private view for indicating root teams

P_RespyMgmtRootTeamIndicator is a Basic CDS View that provides data about "Private view for indicating root teams" in SAP S/4HANA. It reads from 3 data sources (P_RespyMgmtSuperTeam, P_RespyMgmtTeamHeaderDet, rsm_team_typ_c) and exposes 3 fields with key fields RespyMgmtTeamID, RespyMgmtParentID. Part of development package CA_RSM_TEAMS_DDIC.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
P_RespyMgmtSuperTeam SuperTeam left_outer
P_RespyMgmtTeamHeaderDet TeamHeaderDet from
rsm_team_typ_c teamtype left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PRSMROOTTEAMIND view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY RespyMgmtTeamID P_RespyMgmtTeamHeaderDet ObjectID
KEY RespyMgmtParentID P_RespyMgmtSuperTeam RespyMgmtSuperTeamID
RespyMgmtTeamcategory rsm_team_typ_c teamcategory 
@AbapCatalog.sqlViewName: 'PRSMROOTTEAMIND'
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:#MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RespyMgmtRootTeamIndicator as select from P_RespyMgmtTeamHeaderDet as TeamHeaderDet
left outer join rsm_team_typ_c as teamtype on teamtype.teamtype = TeamHeaderDet.TeamType
left outer join P_RespyMgmtSuperTeam as SuperTeam on SuperTeam.RespyMgmtTeamID = TeamHeaderDet.ObjectID
{
    key TeamHeaderDet.ObjectID as RespyMgmtTeamID,
    key SuperTeam.RespyMgmtSuperTeamID as RespyMgmtParentID,
       teamtype.teamcategory as RespyMgmtTeamcategory,
        cast ( case when SuperTeam.RespyMgmtSuperTeamID is null 
                then 'X'
                else ' ' end as boole_d preserving type ) as RespyMgmtTeamIsRootTeam    
} where TeamHeaderDet.TeamStatus = '01';

Learn More