SCLT_TRACE_STEP

Transparent Table Temporary Data

CLT: Trace step table

SCLT_TRACE_STEP is an SAP database table in S/4HANA. CLT: Trace step table. It contains 13 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_SCLT_EXCEPTION_TP view from CLT: Exception trace step
I_SCLT_TRACE_STEP_TP view from CLT: Trace Step
I_SCLT_USER_MESSAGE_TP view from CLT: User message trace step
N_SCLT_Trace_Step view_entity from CLT: Trace Step
P_SCLT_HEADER_STEP view from CLT: Header steps for sessions
P_SCLT_SESSION_DURATION view from CLT: Session duration helper view
P_SCLT_SESSION_STEP view from CLT: Helper view for session steps
P_SCLT_STEP_DRILL_STATE view from CLT: Helper view for the drill state
P_SCLT_STEP_DRILL_STATE view left_outer CLT: Helper view for the drill state

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY trace_id sclt_trace_id Trace ID
KEY ordinal_number sclt_ordinal_number Ordinal Number
KEY session_id sclt_session_id Session ID
step_type sclt_step_type Step Type
parent_ordinal_number sclt_ordinal_number Ordinal Number
description sclt_step_description Description
start_runtime sclt_step_start_runtime
duration sclt_step_duration Step Duration
severity sclt_severity Severity
start_time sclt_step_start_time Start Time
hierarchy_level sclt_hierarchy_level CLT: Trace Step Hierarchy Level
aft_target_id saft_target_id Target ID
has_parameter_tracing boolean Boolean Variable (X = True, - = False, Space = Unknown)

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.

-- CLT: Trace step table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCLT_TRACE_STEP (
    TRACE_ID,               -- Trace ID [sclt_trace_id]
    ORDINAL_NUMBER,         -- Ordinal Number [sclt_ordinal_number]
    SESSION_ID,             -- Session ID [sclt_session_id]
    STEP_TYPE,              -- Step Type [sclt_step_type]
    PARENT_ORDINAL_NUMBER,  -- Ordinal Number [sclt_ordinal_number]
    DESCRIPTION,            -- Description [sclt_step_description]
    START_RUNTIME,          -- sclt_step_start_runtime
    DURATION,               -- Step Duration [sclt_step_duration]
    SEVERITY,               -- Severity [sclt_severity]
    START_TIME,             -- Start Time [sclt_step_start_time]
    HIERARCHY_LEVEL,        -- CLT: Trace Step Hierarchy Level [sclt_hierarchy_level]
    AFT_TARGET_ID,          -- Target ID [saft_target_id]
    HAS_PARAMETER_TRACING,  -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    PRIMARY KEY (TRACE_ID, ORDINAL_NUMBER, SESSION_ID)
);