scmon_vdata_view

DDL: SCMON_VDATA SQL: scmon_vdata Type: view
16 Fields 5 Data Sources

scmon_vdata_view is a CDS View in SAP S/4HANA. It reads from 5 data sources (scmon_data, scmon_proc, scmon_prog, scmon_slice, scmon_sub) and exposes 16 fields with key fields trigid, subid, sliceid.

Data Sources (5)

SourceAliasJoin Type
scmon_data data from
scmon_proc proc inner
scmon_prog prog inner
scmon_slice slice inner
scmon_sub sub inner

Annotations (1)

NameValueLevelField
AbapCatalog.sqlViewName scmon_vdata view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY trigid scmon_data trigid Target Syst. ID
KEY subid scmon_data subid Topic ID
KEY sliceid scmon_data sliceid Slice ID
slicestart scmon_slice startdate Valid From
sliceend scmon_slice enddate Term to
slicegroupid scmon_slice groupid Group name
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 scmon_data counter Version
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_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

CREATE VIEW scmon_vdata_view AS
SELECT
  data.trigid AS trigid,
  data.subid AS subid,
  data.sliceid AS sliceid,
  slice.startdate AS slicestart,
  slice.enddate AS sliceend,
  slice.groupid AS slicegroupid,
  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,
  data.counter AS counter,
  cast(1 as abap.int4) AS summation
FROM scmon_data AS data
INNER JOIN scmon_slice AS slice 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