scmon_vdatarc_a_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_vdatarc_a_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_vdatarc_a

CREATE VIEW scmon_vdatarc_a_view AS
SELECT
  data.trigid AS trigid,
  prog.progname AS progname,
  prog.object AS object,
  prog.obj_name AS obj_name,
  proc.proctype AS proctype,
  proc.procname AS procname,
  proc.classname AS classname,
  sum(data.counter) AS counter,
  cast(1 as abap.int4) AS summation
FROM scmon_vdatarc_k_view AS data
INNER JOIN scmon_slice AS slice ON /* join condition not captured in parsed metadata */
INNER JOIN scmon_proc AS proc ON /* join condition not captured in parsed metadata */
INNER JOIN scmon_prog AS prog ON /* join condition not captured in parsed metadata */
;