TMO_HPT_DIREC

Transparent Table Temporary Data

TMO-HPT: Directory

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
TMO_HPT_I_DIRECTORY_R view from TMO-HPT: Directory

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY profile_id TMO_HPT_V_PROFILE_ID Profile ID
KEY profile_type TMO_HPT_V_PROFILE_TYPE Profile Type
KEY start_time TIMESTAMP Time Stamp
end_time TIMESTAMP Time Stamp
status TMO_HPT_V_TRACE_STATUS Trace Status
user_group TMO_CR_V_USER_GROUP User Group
retention_time TMO_HPT_V_RETENTION_TIME Retention Time
retention_timestamp TIMESTAMP Time Stamp
changed_at TIMESTAMP Time Stamp
changed_by TMO_CR_V_USER_ID ABAP User
cfg_filter_abap_user TMO_CR_V_USER_ID ABAP User
cfg_filter_transaction_code TMO_CR_V_TCODE Transaction Code
cfg_filter_statement_hash TMO_HPT_V_STATEMENT_HASH Statement Hash
cfg_filter_stmt_runtime_thresh TMO_HPT_V_STMT_RUNTIME_THRESH Runtime Threshold
cfg_filter_trace_start_time TIMESTAMP Time Stamp
cfg_filter_trace_duration_secs TMO_HPT_V_TRACE_DURATION Trace Duration
cfg_filter_max_statements TMO_HPT_V_MAX_STMT_COUNT Max Statement Count
cfg_filter_statement_substring TMO_HPT_V_STATEMENT_SUBSTRING Stmt Substring
cfg_flag_newly_compiled_plans ABAP_BOOLEAN Truth Value
cfg_flag_incl_data_chg_stmts ABAP_BOOLEAN Truth Value

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: Directory
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TMO_HPT_DIREC (
    CLIENT,                          -- Client [MANDT]
    PROFILE_ID,                      -- Profile ID [TMO_HPT_V_PROFILE_ID]
    PROFILE_TYPE,                    -- Profile Type [TMO_HPT_V_PROFILE_TYPE]
    START_TIME,                      -- Time Stamp [TIMESTAMP]
    END_TIME,                        -- Time Stamp [TIMESTAMP]
    STATUS,                          -- Trace Status [TMO_HPT_V_TRACE_STATUS]
    USER_GROUP,                      -- User Group [TMO_CR_V_USER_GROUP]
    RETENTION_TIME,                  -- Retention Time [TMO_HPT_V_RETENTION_TIME]
    RETENTION_TIMESTAMP,             -- Time Stamp [TIMESTAMP]
    CHANGED_AT,                      -- Time Stamp [TIMESTAMP]
    CHANGED_BY,                      -- ABAP User [TMO_CR_V_USER_ID]
    CFG_FILTER_ABAP_USER,            -- ABAP User [TMO_CR_V_USER_ID]
    CFG_FILTER_TRANSACTION_CODE,     -- Transaction Code [TMO_CR_V_TCODE]
    CFG_FILTER_STATEMENT_HASH,       -- Statement Hash [TMO_HPT_V_STATEMENT_HASH]
    CFG_FILTER_STMT_RUNTIME_THRESH,  -- Runtime Threshold [TMO_HPT_V_STMT_RUNTIME_THRESH]
    CFG_FILTER_TRACE_START_TIME,     -- Time Stamp [TIMESTAMP]
    CFG_FILTER_TRACE_DURATION_SECS,  -- Trace Duration [TMO_HPT_V_TRACE_DURATION]
    CFG_FILTER_MAX_STATEMENTS,       -- Max Statement Count [TMO_HPT_V_MAX_STMT_COUNT]
    CFG_FILTER_STATEMENT_SUBSTRING,  -- Stmt Substring [TMO_HPT_V_STATEMENT_SUBSTRING]
    CFG_FLAG_NEWLY_COMPILED_PLANS,   -- Truth Value [ABAP_BOOLEAN]
    CFG_FLAG_INCL_DATA_CHG_STMTS,    -- Truth Value [ABAP_BOOLEAN]
    PRIMARY KEY (CLIENT, PROFILE_ID, PROFILE_TYPE, START_TIME)
);