P_RespyMgmtTeamHierarchyNode

DDL: P_RESPYMGMTTEAMHIERARCHYNODE SQL: PRSMHIERNODE Type: view COMPOSITE

P_RespyMgmtTeamHierarchyNode is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_RespyMgmtTeamDescription, I_RespyMgmtTeamHeaderDetail, I_RespyMgmtTeamHierarchy) and exposes 9 fields with key field HierarchyNodeendasHierarchyNode. It has 1 association to related views.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
I_RespyMgmtTeamDescription _TeamDescription left_outer
I_RespyMgmtTeamHeaderDetail TeamHeader from
I_RespyMgmtTeamHierarchy TeamHierarchy left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_RespyMgmtTeamTypeBasic _RespyMgmtTeamType _RespyMgmtTeamType.RespyMgmtTeamType = TeamHeader.RespyMgmtTeamType

Annotations (10)

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

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY HierarchyNodeendasHierarchyNode
ParentNodeendasParentNode
RespyMgmtTeamIDendasRespyMgmtTeamID
RespyMgmtParentTeamID I_RespyMgmtTeamHierarchy RespyMgmtParentTeamID
RespyMgmtTeamName I_RespyMgmtTeamHeaderDetail TeamName
RespyMgmtTeamDescription I_RespyMgmtTeamDescription TeamDescription
TeamStatus I_RespyMgmtTeamHeaderDetail TeamStatus
TeamType I_RespyMgmtTeamHeaderDetail RespyMgmtTeamType
TeamCategory _RespyMgmtTeamType RespyMgmtTeamCategory 
@AbapCatalog.sqlViewName: 'PRSMHIERNODE'
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@AbapCatalog.preserveKey: true
define view P_RespyMgmtTeamHierarchyNode
  as select from    I_RespyMgmtTeamHeaderDetail    as TeamHeader
    left outer join I_RespyMgmtTeamDescription   as _TeamDescription on  _TeamDescription.RespyMgmtTeamID    = TeamHeader.RespyMgmtTeamID
                                                                      and _TeamDescription.Language = $session.system_language
    
    left outer join I_RespyMgmtTeamHierarchy as TeamHierarchy on TeamHierarchy.RespyMgmtTeamID = TeamHeader.RespyMgmtTeamID
    association [0..1] to I_RespyMgmtTeamTypeBasic  as _RespyMgmtTeamType on _RespyMgmtTeamType.RespyMgmtTeamType = TeamHeader.RespyMgmtTeamType
{
  key case when TeamHierarchy.HierarchyNode is null
           then cast(TeamHeader.RespyMgmtTeamID as hierarchynodeuuid)
           else TeamHierarchy.HierarchyNode
           end                                       as HierarchyNode,
      case when TeamHierarchy.ParentNode is null
           then cast('' as hierarchynodeuuid)
           else TeamHierarchy.ParentNode
           end                                       as ParentNode,
      case when TeamHierarchy.RespyMgmtTeamID is null
           then TeamHeader.RespyMgmtTeamID
           else TeamHierarchy.RespyMgmtTeamID
           end                                       as RespyMgmtTeamID, 
           TeamHierarchy.RespyMgmtParentTeamID       as RespyMgmtParentTeamID,          
           TeamHeader.TeamName                       as RespyMgmtTeamName,
           _TeamDescription.TeamDescription          as RespyMgmtTeamDescription,
           TeamHeader.TeamStatus                     as TeamStatus,
           TeamHeader.RespyMgmtTeamType              as TeamType,
           _RespyMgmtTeamType.RespyMgmtTeamCategory  as TeamCategory 
           
}  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RESPYMGMTTEAMDESCRIPTION",
"I_RESPYMGMTTEAMHEADERDETAIL",
"I_RESPYMGMTTEAMHIERARCHY",
"I_RESPYMGMTTEAMTYPEBASIC"
],
"ASSOCIATED":
[
"I_RESPYMGMTTEAMTYPEBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More