SQLMDZVDISZ1

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 SQLMDZVDISZ1.
-- 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: SQLMCZVDISZ1
-- Parameters: p_unixtimefrom : abap.int4, p_unixtimeto : abap.int4

CREATE VIEW SQLMDZVDISZ1 AS
SELECT
  measid,
  infoid,
  subid,
  progname,
  progkind,
  proctype,
  procname,
  procline,
  hashcode,
  include,
  line,
  fragment,
  pgmid,
  object,
  obj_name,
  devclass,
  runlevel,
  roottype,
  rootname,
  stmtkind,
  tablenames,
  tablename01,
  tablename02,
  tablename03,
  tablename04,
  tablename05,
  tablename06,
  tablename07,
  tablename08,
  tablename09,
  tablename10,
  progdate,
  progtime,
  outdated,
  sum( xcnt ) AS xcnt,
  sum( rcnt ) AS rcnt,
  min( rtmin ) AS rtmin,
  max( rtmax ) AS rtmax,
  sum( rtsum ) AS rtsum,
  sum( rtsqs ) AS rtsqs,
  min( dbmin ) AS dbmin,
  max( dbmax ) AS dbmax,
  sum( dbsum ) AS dbsum,
  sum( dbsqs ) AS dbsqs
FROM SQLMDZVDISZ
;