I_Scbo_TraceStep_TP

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_Scbo_TraceStep_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_SCBO_TRCS_TP

CREATE VIEW I_Scbo_TraceStep_TP AS
SELECT
  trace_run_id AS TraceRunId,
  ordinal_number AS OrdinalNumber,
  parent_ordinal_number AS ParentOrdinalNumber,
  business_object_id AS BusinessObjectId,
  node_id AS NodeId,
  step_type AS StepType,
  logic_type AS LogicType,
  action_id AS ActionID,
  evaluation_type AS EvaluationType,
  evaluation_time_point AS EvaluationTimePoint,
  _UserMessage.SourceLine AS SourceLine,
  case when step_type = 'EXC' then _Exception.ClassName when step_type = 'USR' then _UserMessage.ClassName else '' end as ClassName AS ClassNameelseendasClassName,
  case when step_type = 'EXC' then _Exception.Etag when step_type = 'USR' then _UserMessage.Etag else '' end as Etag AS EtagelseendasEtag,
  case when step_type = 'EXC' then _Exception.ExceptionText when step_type = 'USR' then _UserMessage.Message else '' end as StepDescription AS MessageelseendasStepDescription,
  _TraceParams.Parameters AS Parameters,
  case when action_id is not null and action_id != '' then _Action.Description else _Eval_Time_Point_Text.description end as LogicName AS descriptionendasLogicName,
  Severity
FROM scbo_trc_step AS TraceStep
LEFT OUTER JOIN I_Scbo_TraceHeader_TP AS _TraceHeader ON TraceRunId = _TraceHeader.TraceRunId  -- association [1..1]
LEFT OUTER JOIN I_Scbo_Action AS _Action ON ActionID = _Action.ActionID AND BusinessObjectId = _Action.BusinessObjectID AND NodeId = _Action.NodeID AND _Action.VersionNumber = '0000000000'  -- association [0..1]
LEFT OUTER JOIN I_Scbo_Bl_Eval_Time_Point_Text AS _Eval_Time_Point_Text ON EvaluationTimePoint = _Eval_Time_Point_Text.code AND _Eval_Time_Point_Text.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Scbo_TraceException_TP AS _Exception ON TraceRunId = _Exception.TraceRunId AND OrdinalNumber = _Exception.OrdinalNumber  -- association [0..1]
LEFT OUTER JOIN I_Scbo_Trace_Usr_Msg_TP AS _UserMessage ON TraceRunId = _UserMessage.TraceRunId AND OrdinalNumber = _UserMessage.OrdinalNumber  -- association [0..1]
LEFT OUTER JOIN I_Scbo_TraceParams_TP AS _TraceParams ON TraceRunId = _TraceParams.TraceRunId AND OrdinalNumber = _TraceParams.OrdinalNumber  -- association [0..1]
;