scmon_vrdata_view

DDL: SCMON_VRDATA SQL: scmon_vrdata Type: view
12 Fields 4 Data Sources

scmon_vrdata_view is a CDS View in SAP S/4HANA. It reads from 4 data sources (scmon_rdata, scmon_slice, scmon_sub, scmon_sub) and exposes 12 fields with key fields subid1, subid2, sliceid.

Data Sources (4)

SourceAliasJoin Type
scmon_rdata rdata from
scmon_slice slice inner
scmon_sub sub1 inner
scmon_sub sub2 inner

Annotations (1)

NameValueLevelField
AbapCatalog.sqlViewName scmon_vrdata view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY subid1 scmon_rdata subid1
KEY subid2 scmon_rdata subid2
KEY sliceid scmon_rdata sliceid Slice ID
slicestart scmon_slice startdate Valid From
sliceend scmon_slice enddate Term to
slicegroupid scmon_slice groupid Group name
roottype1 scmon_sub roottype Request Type
rootname1 scmon_sub rootname Root Entity Name
roottype2 scmon_sub roottype Request Type
rootname2 scmon_sub rootname Root Entity Name
counter scmon_rdata 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_vrdata_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

CREATE VIEW scmon_vrdata_view AS
SELECT
  rdata.subid1 AS subid1,
  rdata.subid2 AS subid2,
  rdata.sliceid AS sliceid,
  slice.startdate AS slicestart,
  slice.enddate AS sliceend,
  slice.groupid AS slicegroupid,
  sub1.roottype AS roottype1,
  sub1.rootname AS rootname1,
  sub2.roottype AS roottype2,
  sub2.rootname AS rootname2,
  rdata.counter AS counter,
  cast(1 as abap.int4) AS summation
FROM scmon_rdata AS rdata
INNER JOIN scmon_slice AS slice 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 */
;

Learn More