I_SCLT_USER_MESSAGE_TP

DDL: I_SCLT_USER_STATEMENT_TP SQL: I_V_SCLT_UMSG_TP Type: view Package: S_CLT_MODEL
9 Fields 1 Data Sources 2 Associations

CLT: User message trace step

I_SCLT_USER_MESSAGE_TP is a CDS View that provides data about "CLT: User message trace step" in SAP S/4HANA. It reads from 1 data source (sclt_trace_step) and exposes 9 fields with key fields TraceID, OrdinalNumber. It has 2 associations to related views. Part of development package S_CLT_MODEL.

Data Sources (1)

SourceAliasJoin Type
sclt_trace_step sclt_trace_step from

Associations (2)

CardinalityTargetAliasCondition
[1..1] P_SCLT_USER_MESSAGE_STEP _UserMessageStep $projection.TraceID = _UserMessageStep.TraceID and $projection.OrdinalNumber = _UserMessageStep.OrdinalNumber
[1..1] I_SCLT_TRACE_STEP_TP _ParentTraceStep $projection.TraceID = _ParentTraceStep.TraceID and $projection.ParentOrdinalNumber = _ParentTraceStep.OrdinalNumber

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName I_V_SCLT_UMSG_TP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CLT: User message trace step view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY TraceID trace_id Trace ID
KEY OrdinalNumber ordinal_number Ordinal Number
StepType step_type VSS Sol. Step Type
ParentOrdinalNumber parent_ordinal_number Ordinal Number
Message _UserMessageStep Message User Message
ClassName _UserMessageStep ClassName Type Name
ClassETag _UserMessageStep ClassETag
SourceLine _UserMessageStep SourceLine
ParentStepType _ParentTraceStep StepType Coll. Step Cat.

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 I_SCLT_USER_MESSAGE_TP.
-- 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: I_V_SCLT_UMSG_TP

CREATE VIEW I_SCLT_USER_MESSAGE_TP AS
SELECT
  trace_id AS TraceID,
  ordinal_number AS OrdinalNumber,
  step_type AS StepType,
  parent_ordinal_number AS ParentOrdinalNumber,
  _UserMessageStep.Message AS Message,
  _UserMessageStep.ClassName AS ClassName,
  _UserMessageStep.ClassETag AS ClassETag,
  _UserMessageStep.SourceLine AS SourceLine,
  _ParentTraceStep.StepType AS ParentStepType
FROM sclt_trace_step
LEFT OUTER JOIN P_SCLT_USER_MESSAGE_STEP AS _UserMessageStep ON TraceID = _UserMessageStep.TraceID AND OrdinalNumber = _UserMessageStep.OrdinalNumber  -- association [1..1]
LEFT OUTER JOIN I_SCLT_TRACE_STEP_TP AS _ParentTraceStep ON TraceID = _ParentTraceStep.TraceID AND ParentOrdinalNumber = _ParentTraceStep.OrdinalNumber  -- association [1..1]
;

Learn More