TMO_HPT_RECORDS

Transparent Table Temporary Data
26 Fields 1 CDS Views

TMO-HPT: Records

TMO_HPT_RECORDS is an SAP database table in S/4HANA. TMO-HPT: Records. It contains 26 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
TMO_HPT_I_RECORDS_R view from TMO-HPT: Records

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY db_connection_id TMO_CR_V_DB_CONNECTION_ID DB Connection ID
KEY db_user TMO_CR_V_DB_USER Database User
KEY db_schema TMO_CR_V_DB_SCHEMA Database Schema
KEY stmt_execution_id TMO_HPT_V_STMT_EXEC_ID Statement Execution ID
KEY stmt_execution_start_time TMO_HPT_V_TRACE_TIMESTAMP HPT Trace Timestamp
stmt_execution_end_time TMO_HPT_V_TRACE_TIMESTAMP HPT Trace Timestamp
profile_id TMO_HPT_V_PROFILE_ID Profile ID
profile_type TMO_HPT_V_PROFILE_TYPE Profile Type
user_id TMO_CR_V_USER_ID ABAP User
host_name TMO_CR_V_HOST Host Name
port TMO_CR_V_PORT Port
statement_hash TMO_HPT_V_STATEMENT_HASH Statement Hash
source_code_position TMO_HPT_V_SOURCE_CODE_POSITION Source Code Position
request_entry_name TMO_CR_V_REQUEST_ENTRY_NAME Request Entry Name
request_entry_type SREQUEST_TYPE Request Entry Type
transaction_code TMO_CR_V_TCODE Transaction Code
wmpc_id TMO_CR_V_WMPC_ID WMPC ID
wmpc_variant TMO_CR_V_WMPC_VARIANT WMPC Varian
epp_root_context_id TMO_CR_V_EPP_ROOT_CONTEXT_ID EPP Root Context ID
epp_transaction_id TMO_CR_V_EPP_TRANSACTION_ID EPP Transaction ID
epp_connection_id TMO_CR_V_EPP_CONNECTION_ID EPP Connection ID
epp_connection_counter TMO_CR_V_EPP_CONNECTION_COUNT EPP Connection Counter
execution_time TMO_HPT_V_EXECUTION_TIME Statement Execution Time
result_record_count TMO_HPT_V_RESULT_RECORD_COUNT Result Record Count
retention_timestamp TIMESTAMP Time Stamp

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- TMO-HPT: Records
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TMO_HPT_RECORDS (
    CLIENT,                     -- Client [MANDT]
    DB_CONNECTION_ID,           -- DB Connection ID [TMO_CR_V_DB_CONNECTION_ID]
    DB_USER,                    -- Database User [TMO_CR_V_DB_USER]
    DB_SCHEMA,                  -- Database Schema [TMO_CR_V_DB_SCHEMA]
    STMT_EXECUTION_ID,          -- Statement Execution ID [TMO_HPT_V_STMT_EXEC_ID]
    STMT_EXECUTION_START_TIME,  -- HPT Trace Timestamp [TMO_HPT_V_TRACE_TIMESTAMP]
    STMT_EXECUTION_END_TIME,    -- HPT Trace Timestamp [TMO_HPT_V_TRACE_TIMESTAMP]
    PROFILE_ID,                 -- Profile ID [TMO_HPT_V_PROFILE_ID]
    PROFILE_TYPE,               -- Profile Type [TMO_HPT_V_PROFILE_TYPE]
    USER_ID,                    -- ABAP User [TMO_CR_V_USER_ID]
    HOST_NAME,                  -- Host Name [TMO_CR_V_HOST]
    PORT,                       -- Port [TMO_CR_V_PORT]
    STATEMENT_HASH,             -- Statement Hash [TMO_HPT_V_STATEMENT_HASH]
    SOURCE_CODE_POSITION,       -- Source Code Position [TMO_HPT_V_SOURCE_CODE_POSITION]
    REQUEST_ENTRY_NAME,         -- Request Entry Name [TMO_CR_V_REQUEST_ENTRY_NAME]
    REQUEST_ENTRY_TYPE,         -- Request Entry Type [SREQUEST_TYPE]
    TRANSACTION_CODE,           -- Transaction Code [TMO_CR_V_TCODE]
    WMPC_ID,                    -- WMPC ID [TMO_CR_V_WMPC_ID]
    WMPC_VARIANT,               -- WMPC Varian [TMO_CR_V_WMPC_VARIANT]
    EPP_ROOT_CONTEXT_ID,        -- EPP Root Context ID [TMO_CR_V_EPP_ROOT_CONTEXT_ID]
    EPP_TRANSACTION_ID,         -- EPP Transaction ID [TMO_CR_V_EPP_TRANSACTION_ID]
    EPP_CONNECTION_ID,          -- EPP Connection ID [TMO_CR_V_EPP_CONNECTION_ID]
    EPP_CONNECTION_COUNTER,     -- EPP Connection Counter [TMO_CR_V_EPP_CONNECTION_COUNT]
    EXECUTION_TIME,             -- Statement Execution Time [TMO_HPT_V_EXECUTION_TIME]
    RESULT_RECORD_COUNT,        -- Result Record Count [TMO_HPT_V_RESULT_RECORD_COUNT]
    RETENTION_TIMESTAMP,        -- Time Stamp [TIMESTAMP]
    PRIMARY KEY (CLIENT, DB_CONNECTION_ID, DB_USER, DB_SCHEMA, STMT_EXECUTION_ID, STMT_EXECUTION_START_TIME)
);

Learn More