scmon_vrdata_as_view

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 scmon_vrdata_as_view.
-- 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: scmon_vrdata_as

CREATE VIEW scmon_vrdata_as_view AS
SELECT
  sel.selectionid AS selectionid,
  rdata.subid1 AS subid1,
  rdata.subid2 AS subid2,
  sub1.roottype AS roottype1,
  sub1.rootname AS rootname1,
  sub2.roottype AS roottype2,
  sub2.rootname AS rootname2,
  sum(rdata.counter) AS counter,
  cast(1 as abap.int4) AS summation
FROM scmon_slice_s AS sel
INNER JOIN scmon_rdata AS rdata ON /* join condition not captured in parsed metadata */
INNER JOIN scmon_sub AS sub1 ON /* join condition not captured in parsed metadata */
INNER JOIN scmon_sub AS sub2 ON /* join condition not captured in parsed metadata */
;