I_RootNode

DDL: I_ROOTNODE SQL: IROOTNODE Type: view BASIC

Root Node

I_RootNode is a Basic CDS View that provides data about "Root Node" in SAP S/4HANA. It reads from 1 data source (P_RootNode) and exposes 9 fields. It has 1 association to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
P_RootNode RootNode from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MasterProject _MasterProject $projection.MstrProjIssRefId = _MasterProject.ProjectUUID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IROOTNODE view
VDM.viewType #BASIC view
EndUserText.label Root Node view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID P_RootNode id
ChangeRecordUUID P_RootNode db_key
MstrProjIssRefId P_RootNode id
IssueName P_RootNode risk_txt
ChangeRecord P_RootNode issue_id
OriginApplication P_RootNode application
IssueType P_RootNode issue_type
IssueCategory P_RootNode issue_category
_MasterProject _MasterProject 
@AbapCatalog.sqlViewName: 'IROOTNODE'
@VDM.viewType: #BASIC
@EndUserText.label: 'Root Node'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MIXED

define view I_RootNode
  as select from P_RootNode as RootNode
 association [0..1] to I_MasterProject as _MasterProject on $projection.MstrProjIssRefId = _MasterProject.ProjectUUID
{
  RootNode.id             as MasterProjectUUID,
  RootNode.db_key as  ChangeRecordUUID,
  RootNode.id as MstrProjIssRefId,
  RootNode.risk_txt as IssueName,
  RootNode.issue_id as ChangeRecord,
  RootNode.application as OriginApplication,
  RootNode.issue_type as IssueType,
  RootNode.issue_category as IssueCategory,
  _MasterProject 
} 
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ROOTNODE"
],
"ASSOCIATED":
[
"I_MASTERPROJECT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More