SQLMEZVDISZ

DDL: SQLMEZVDISZ Type: view_entity
47 Fields 4 Data Sources

SQLMEZVDISZ is a CDS View in SAP S/4HANA. It reads from 4 data sources (sqlmzd, sqlmzi, sqlmzs, sqlmzz) and exposes 47 fields with key fields measid, infoid, subid, timeid.

Data Sources (4)

SourceAliasJoin Type
sqlmzd d from
sqlmzi i inner
sqlmzs s inner
sqlmzz z inner

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY measid sqlmzd measid INT4
KEY infoid sqlmzd infoid Weighing Data
KEY subid sqlmzd subid Topic ID
KEY timeid sqlmzd timeid INT4
progname sqlmzi progname Tcode/program
progkind sqlmzi progkind Prog. Kind
proctype sqlmzi proctype Proc. Bl. Type
procname sqlmzi procname Proc Block Name
procline sqlmzi procline Proc Block Line
hashcode sqlmzi hashcode HashCode to FG
include sqlmzi include
line sqlmzi line VAT Return Line Item
fragment sqlmzi fragment ABAP Source Code
pgmid sqlmzi pgmid Program Name
object sqlmzi object TRFM Object
obj_name sqlmzi obj_name Object Name
devclass sqlmzi devclass Package (Obsolete)
progdate sqlmzi progdate Program Run Date
progtime sqlmzi progtime Time
outdated sqlmzi outdated Outdated
runlevel sqlmzs runlevel Run Mode
roottype sqlmzs roottype Request Type
rootname sqlmzs rootname Root Entity Name
stmtkind sqlmzs stmtkind SQL Operation
tablenames sqlmzs tablenames Table Names
tablename01 sqlmzs tablename01 Table Name
tablename02 sqlmzs tablename02 Table Name
tablename03 sqlmzs tablename03 Table Name
tablename04 sqlmzs tablename04 Table Name
tablename05 sqlmzs tablename05 Table Name
tablename06 sqlmzs tablename06 Table Name
tablename07 sqlmzs tablename07 Table Name
tablename08 sqlmzs tablename08 Table Name
tablename09 sqlmzs tablename09 Table Name
tablename10 sqlmzs tablename10 Table Name
unixtimefrom sqlmzz unixtimefrom INT4
unixtimeto sqlmzz unixtimeto INT4
xcnt sqlmzd xcnt
rcnt sqlmzd rcnt
rtmin sqlmzd rtmin
rtmax sqlmzd rtmax
rtsum sqlmzd rtsum
rtsqs sqlmzd rtsqs
dbmin sqlmzd dbmin
dbmax sqlmzd dbmax
dbsum sqlmzd dbsum
dbsqs sqlmzd dbsqs

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 SQLMEZVDISZ.
-- 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.

CREATE VIEW SQLMEZVDISZ AS
SELECT
  d.measid AS measid,
  d.infoid AS infoid,
  d.subid AS subid,
  d.timeid AS timeid,
  i.progname AS progname,
  i.progkind AS progkind,
  i.proctype AS proctype,
  i.procname AS procname,
  i.procline AS procline,
  i.hashcode AS hashcode,
  i.include AS include,
  i.line AS line,
  i.fragment AS fragment,
  i.pgmid AS pgmid,
  i.object AS object,
  i.obj_name AS obj_name,
  i.devclass AS devclass,
  i.progdate AS progdate,
  i.progtime AS progtime,
  i.outdated AS outdated,
  s.runlevel AS runlevel,
  s.roottype AS roottype,
  s.rootname AS rootname,
  s.stmtkind AS stmtkind,
  s.tablenames AS tablenames,
  s.tablename01 AS tablename01,
  s.tablename02 AS tablename02,
  s.tablename03 AS tablename03,
  s.tablename04 AS tablename04,
  s.tablename05 AS tablename05,
  s.tablename06 AS tablename06,
  s.tablename07 AS tablename07,
  s.tablename08 AS tablename08,
  s.tablename09 AS tablename09,
  s.tablename10 AS tablename10,
  z.unixtimefrom AS unixtimefrom,
  z.unixtimeto AS unixtimeto,
  d.xcnt AS xcnt,
  d.rcnt AS rcnt,
  d.rtmin AS rtmin,
  d.rtmax AS rtmax,
  d.rtsum AS rtsum,
  d.rtsqs AS rtsqs,
  d.dbmin AS dbmin,
  d.dbmax AS dbmax,
  d.dbsum AS dbsum,
  d.dbsqs AS dbsqs
FROM sqlmzd AS d
INNER JOIN sqlmzi AS i ON /* join condition not captured in parsed metadata */
INNER JOIN sqlmzs AS s ON /* join condition not captured in parsed metadata */
INNER JOIN sqlmzz AS z ON /* join condition not captured in parsed metadata */
;

Learn More