TMO_SQL_C_RECORDS_R

DDL: TMO_SQL_C_RECORDS_R SQL: TMO_SQL_C_REC Type: view Package: S_TMO_SQL_ODATA
25 Fields 1 Data Sources 1 OData Services

TMO-SQL: HANA Plan Trace Records

TMO_SQL_C_RECORDS_R is a CDS View that provides data about "TMO-SQL: HANA Plan Trace Records" in SAP S/4HANA. It reads from 1 data source (TMO_HPT_I_RECORDS_R) and exposes 25 fields with key fields DbConnectionId, DbUser, DbSchema, StmtExecutionId, StmtExecutionStartTime. It is exposed through 1 OData service (TMO_UI_SQL_PLAN_CACHE_R). Part of development package S_TMO_SQL_ODATA.

Data Sources (1)

SourceAliasJoin Type
TMO_HPT_I_RECORDS_R TMO_HPT_I_RECORDS_R from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName TMO_SQL_C_REC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label TMO-SQL: HANA Plan Trace Records view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
TMO_UI_SQL_PLAN_CACHE_R TMO_UI_SQL_PLAN_CACHE_R_O4 V4 C1 NOT_RELEASED

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY DbConnectionId DbConnectionId
KEY DbUser DbUser
KEY DbSchema DbSchema
KEY StmtExecutionId StmtExecutionId
KEY StmtExecutionStartTime StmtExecutionStartTime Execution Start Time
KEY StatementHash StatementHash Statement Hash
StmtExecutionEndTime StmtExecutionEndTime Execution End Time
ProfileId ProfileId Profile
ProfileType ProfileType Profile Type
UserId UserId User Name
HostName HostName Hostname
Port Port Port rule
SourceCodePosition SourceCodePosition
RequestEntryName RequestEntryName Request Entry Name
RequestEntryType RequestEntryType Request Entry Type
TransactionCode TransactionCode Transaction Code
WmpcId WmpcId WMPC ID
WmpcVariant WmpcVariant WMPC Variant
EppRootContextId EppRootContextId Root ID
EppTransactionId EppTransactionId Transaction
EppConnectionId EppConnectionId Connection ID
EppConnectionCounter EppConnectionCounter Counter
ExecutionTime ExecutionTime Execution Time
ResultRecordCount ResultRecordCount
RetentionTimestamp RetentionTimestamp Time Stamp

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 TMO_SQL_C_RECORDS_R.
-- 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: TMO_SQL_C_REC

CREATE VIEW TMO_SQL_C_RECORDS_R AS
SELECT
  DbConnectionId,
  DbUser,
  DbSchema,
  StmtExecutionId,
  StmtExecutionStartTime,
  StatementHash,
  StmtExecutionEndTime,
  ProfileId,
  ProfileType,
  UserId,
  HostName,
  Port,
  SourceCodePosition,
  RequestEntryName,
  RequestEntryType,
  TransactionCode,
  WmpcId,
  WmpcVariant,
  EppRootContextId,
  EppTransactionId,
  EppConnectionId,
  EppConnectionCounter,
  ExecutionTime,
  ResultRecordCount,
  RetentionTimestamp
FROM TMO_HPT_I_RECORDS_R
;

Learn More