sqlmxets

DDL: SQLMXETS SQL: SQLMXETSDD Type: view
13 Fields 1 Data Sources

SQL Monitor: Entities with Timestamp

sqlmxets is a CDS View that provides data about "SQL Monitor: Entities with Timestamp" in SAP S/4HANA. It reads from 1 data source (sqlmxe) and exposes 13 fields with key fields Tablenames, Idx.

Data Sources (1)

SourceAliasJoin Type
sqlmxe sqlmxe from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SQLMXETSDD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SQL Monitor: Entities with Timestamp view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Tablenames tablenames Table Names
KEY Idx idx Table Row
Tableviewname tableviewname Table or View
Cdsviewname cdsviewname CDS View Name
Sqlviewname sqlviewname View Name
Proxysqlviewname proxysqlviewname Proxy View Name
Proxycdsviewname proxycdsviewname Proxy View Name
Tablefunctionname tablefunctionname CDS Table Function
Amdpname amdpname AMDP Method
Annoservicequality annoservicequality Service Quality
Annosizecategory annosizecategory Size Category
Annodataclass annodataclass Data Class
clientINITIALasas4datetime

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 sqlmxets.
-- 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: SQLMXETSDD

CREATE VIEW sqlmxets AS
SELECT
  Tablenames,
  Idx,
  Tableviewname,
  Cdsviewname,
  Sqlviewname,
  Proxysqlviewname,
  Proxycdsviewname,
  Tablefunctionname,
  Amdpname,
  Annoservicequality,
  Annosizecategory,
  Annodataclass,
  dats_tims_to_tstmp( as4date, as4time, abap_system_timezone( $session.client,'NULL' ), $session.client, 'INITIAL' ) as as4datetime AS clientINITIALasas4datetime
FROM sqlmxe
;

Learn More