P_ROOTNODE

CDS View

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

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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ROOTNODE (
    APPLICATION,
    DB_KEY,
    ID,
    ISSUE_CATEGORY,
    ISSUE_ID,
    ISSUE_TYPE,
    RISK_TXT
);