P_RootNode

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_RootNode.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PROOTNODE

CREATE VIEW P_RootNode AS
SELECT
  RootNode.db_key AS db_key,
  RootNode.application AS application,
  RootNode.issue_type AS issue_type,
  RootNode.issue_id AS issue_id,
  RootNode.archiving AS archiving,
  RootNode.stat_cd AS stat_cd,
  RootNode.risk_status AS risk_status,
  RootNode.risk_txt AS risk_txt,
  RootNode.risk_oppt AS risk_oppt,
  cast( IssueRefNode.id as abap.char( 32 )) AS id
FROM /iam/d_i_root AS RootNode
INNER JOIN /iam/d_i_obj_ref AS IssueRefNode ON /* join condition not captured in parsed metadata */
;