scmon_vdatarc_view

DDL: SCMON_VDATARC SQL: scmon_vdatarc Type: view
12 Fields 4 Data Sources

scmon_vdatarc_view is a CDS View in SAP S/4HANA. It reads from 4 data sources (scmon_vdatarc_k_view, scmon_proc, scmon_prog, scmon_slice) and exposes 12 fields with key fields trigid, sliceid.

Data Sources (4)

SourceAliasJoin Type
scmon_vdatarc_k_view data from
scmon_proc proc inner
scmon_prog prog inner
scmon_slice slice inner

Annotations (1)

NameValueLevelField
AbapCatalog.sqlViewName scmon_vdatarc view

Fields (12)

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

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_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

CREATE VIEW scmon_vdatarc_view AS
SELECT
  data.trigid AS trigid,
  data.sliceid AS sliceid,
  slice.startdate AS slicestart,
  slice.enddate AS sliceend,
  slice.groupid AS slicegroupid,
  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
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 */
;

Learn More