TMO_HPT_C_RECORDS_R

DDL: TMO_HPT_C_RECORDS_R SQL: TMO_HPT_C_REC Type: view
25 Fields 1 Data Sources

TMO-SQL: HANA Plan Trace Records

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

Data Sources (1)

SourceAliasJoin Type
TMO_HPT_I_RECORDS_R TMO_HPT_I_RECORDS_R from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName TMO_HPT_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

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY DbConnectionId DbConnectionId
KEY DbUser DbUser
KEY DbSchema DbSchema
KEY StmtExecutionId StmtExecutionId
KEY StmtExecutionStartTime StmtExecutionStartTime Statement Execution Start Time
StmtExecutionEndTime StmtExecutionEndTime Statement Execution End Time
ProfileId ProfileId HPT Profile ID
ProfileType ProfileType Profile Execution Origin
UserId UserId User Name
HostName HostName Hostname
Port Port Port rule
StatementHash StatementHash Statement Hash
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 [µs]
ResultRecordCount ResultRecordCount Result Record Count
RetentionTimestamp RetentionTimestamp Retention End Time

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_HPT_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_HPT_C_REC

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

Learn More