P_SCLT_HEADER_STEP

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 P_SCLT_HEADER_STEP.
-- 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: P_SCLT_HDRS_T_V

CREATE VIEW P_SCLT_HEADER_STEP AS
SELECT
  trace_id AS TraceID,
  session_id AS NodeID,
  '' AS ParentNodeID,
  ordinal_number AS OrdinalNumber,
  parent_ordinal_number AS ParentOrdinalNumber,
  step_type AS StepType,
  Description,
  _SessionDuration.TotalDuration AS Duration,
  case when _Error.TraceID is not null then 'E' when _Warning.TraceID is not null then 'W' when _Info.TraceID is not null then 'I' else '' end as Severity AS TraceIDisnotnullthenIelseendasSeverity,
  start_time AS StartTime
FROM sclt_trace_step AS Step
LEFT OUTER JOIN P_SCLT_SESSION_DURATION AS _SessionDuration ON Step.trace_id = _SessionDuration.TraceID AND Step.session_id = _SessionDuration.SessionID  -- association [1..1]
LEFT OUTER JOIN P_SCLT_SESSION_SEVERITY AS _Error ON TraceID = _Error.TraceID AND NodeID = _Error.SessionID AND _Error.Severity = 'E'  -- association [0..1]
LEFT OUTER JOIN P_SCLT_SESSION_SEVERITY AS _Warning ON TraceID = _Warning.TraceID AND NodeID = _Warning.SessionID AND _Warning.Severity = 'W'  -- association [0..1]
LEFT OUTER JOIN P_SCLT_SESSION_SEVERITY AS _Info ON TraceID = _Info.TraceID AND NodeID = _Info.SessionID AND _Info.Severity = 'I'  -- association [0..1]
;