S_SCLT_TRACE_STEP_C

DDL: S_SCLT_TRACE_STEP_C Type: view Package: S_CLT_MODEL
11 Fields 1 Data Sources 1 Associations

CLT: Trace Step Consumption View

S_SCLT_TRACE_STEP_C is a CDS View that provides data about "CLT: Trace Step Consumption View" in SAP S/4HANA. It reads from 1 data source (I_SCLT_TRACE_STEP_TP) and exposes 11 fields with key fields TraceID, OrdinalNumber. It has 1 association to related views. Part of development package S_CLT_MODEL.

Data Sources (1)

SourceAliasJoin Type
I_SCLT_TRACE_STEP_TP Step from

Associations (1)

CardinalityTargetAliasCondition
[1..1] S_SCLT_TRACE_C _Trace $projection.TraceID = _Trace.TraceID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName S_V_SCLT_STEP_C view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CLT: Trace Step Consumption View view
ObjectModel.compositionRoot false view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY TraceID TraceID Trace ID
KEY OrdinalNumber OrdinalNumber Sequence Number
SessionID SessionID Transaction ID
ParentOrdinalNumber ParentOrdinalNumber Ordinal Number
StepType StepType Coll. Step Cat.
Description Description Well Code Des.
Duration Duration Tot.Duration in Days
Severity Severity Thresh.Val. Severity
StartTime StartTime Time Stamp
HierarchyLevel HierarchyLevel Hierarchy Level
_Trace _Trace

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 S_SCLT_TRACE_STEP_C.
-- 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.

CREATE VIEW S_SCLT_TRACE_STEP_C AS
SELECT
  TraceID,
  OrdinalNumber,
  SessionID,
  ParentOrdinalNumber,
  StepType,
  Description,
  Duration,
  Severity,
  StartTime,
  HierarchyLevel
FROM I_SCLT_TRACE_STEP_TP AS Step
LEFT OUTER JOIN S_SCLT_TRACE_C AS _Trace ON TraceID = _Trace.TraceID  -- association [1..1]
;

Learn More