P_RespyMgmtRootTeamIndicator

DDL: P_RESPYMGMTROOTTEAMINDICATOR SQL: PRSMROOTTEAMIND Type: view BASIC

P_RespyMgmtRootTeamIndicator is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (P_RespyMgmtSuperTeamAllLevel, P_RespyMgmtTeamHeaderDet, rsm_team_typ_c) and exposes 2 fields with key fields RespyMgmtTeamID, RespyMgmtParentID.

3 data source(s) 2 fields

Data Sources (3)

SourceAliasJoin Type
P_RespyMgmtSuperTeamAllLevel 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 (2)

KeyFieldSource TableSource FieldDescription
KEY RespyMgmtTeamID P_RespyMgmtTeamHeaderDet ObjectID
KEY RespyMgmtParentID P_RespyMgmtSuperTeamAllLevel RespyMgmtParentTeamId 
@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_RespyMgmtSuperTeamAllLevel as SuperTeam on SuperTeam.RespyMgmtTeamId = TeamHeaderDet.ObjectID
{
    key TeamHeaderDet.ObjectID as RespyMgmtTeamID,
    key SuperTeam.RespyMgmtParentTeamId as RespyMgmtParentID,
       case when teamtype.teamcategory <> ''
             then teamtype.teamcategory
             else teamtype.customteamcategory end as RespyMgmtTeamcategory,
        cast ( case when SuperTeam.RespyMgmtParentTeamId is null 
                then 'X'
                else ' ' end as boole_d preserving type ) as RespyMgmtTeamIsRootTeam    
} where TeamHeaderDet.TeamStatus = '01';

Learn More