scmon_vdata_as_view

DDL: SCMON_VDATA_AS SQL: scmon_vdata_as Type: view
13 Fields 5 Data Sources

scmon_vdata_as_view is a CDS View in SAP S/4HANA. It reads from 5 data sources (scmon_data, scmon_proc, scmon_prog, scmon_slice_s, scmon_sub) and exposes 13 fields with key fields selectionid, trigid, subid.

Data Sources (5)

SourceAliasJoin Type
scmon_data data inner
scmon_proc proc inner
scmon_prog prog inner
scmon_slice_s sel from
scmon_sub sub inner

Annotations (1)

NameValueLevelField
AbapCatalog.sqlViewName scmon_vdata_as view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY selectionid scmon_slice_s selectionid Selection ID
KEY trigid scmon_data trigid Target Syst. ID
KEY subid scmon_data subid Topic ID
roottype scmon_sub roottype Request Type
rootname scmon_sub rootname Root Entity Name
progname scmon_prog progname Tcode/program
object scmon_prog object TRFM Object
obj_name scmon_prog obj_name Object Name
proctype scmon_proc proctype Proc. Bl. Type
procname scmon_proc procname Proc Block Name
classname scmon_proc classname Type Name
counter
summation

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_vdata_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_vdata_as

CREATE VIEW scmon_vdata_as_view AS
SELECT
  sel.selectionid AS selectionid,
  data.trigid AS trigid,
  data.subid AS subid,
  sub.roottype AS roottype,
  sub.rootname AS rootname,
  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_slice_s AS sel
INNER JOIN scmon_data AS data ON /* join condition not captured in parsed metadata */
INNER JOIN scmon_sub AS sub 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 */
;

Learn More