P_ROOTNODE

CDS View

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

Used by 5 CDS view(s) 7 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_ActiveRisk view from BASIC Count of Active Risk
I_IssueChangeReq view inner BASIC Issue Change Request
I_RootNode view from BASIC Root Node
P_Activitylist view from BASIC
P_IssueChangeReq view inner BASIC

Fields (7)

KeyField CDS FieldsUsed in Views
application application,OriginApplication 2
db_key ChangeRecordUUID 1
id id,MasterProjectUUID,MstrProjIssRefId 4
issue_category issue_category,IssueCategory 2
issue_id ChangeRecord,issue_id 2
issue_type IssueType 1
risk_txt IssueName 1 
@AbapCatalog.sqlViewName: 'PROOTNODE'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.private:true
define view P_RootNode
  as select from /iam/d_i_root    as RootNode
    inner join   /iam/d_i_obj_ref as IssueRefNode on RootNode.db_key = IssueRefNode.parent_key
{

  RootNode.db_key,
  RootNode.application,
  RootNode.issue_category,
  RootNode.issue_type,
  RootNode.issue_id,
  RootNode.archiving_status, // Used in ICM Application

  RootNode.archiving,        // Used in RMA Application

  RootNode.stat_cd,
  RootNode.risk_status,
  RootNode.risk_txt,
  RootNode.identify_stage,
  RootNode.risk_oppt,
  cast( IssueRefNode.id as abap.char( 32 )) as id
  //  IssueRefNode.id

}
where
      IssueRefNode.type_cd     = 'PS'
  and IssueRefNode.category_cd = 'PS_ERP'

Learn More