SCLT_TRACE_STEP
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA