RSB4H_STAT_U

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 RSB4H_STAT_U.
-- 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: RSB4H_STAT_UN

CREATE VIEW RSB4H_STAT_U AS
SELECT
  stat.task_list_run AS TASK_LIST_RUN,
  stat.task AS TASK,
  stat.eventid AS EVENTID,
  stat.tlogo AS TLOGO,
  stat.objnm AS OBJNM,
  stat.is_parallel AS is_parallel,
  stat.uname AS username,
  '' AS externalData,
  case is_parallel when 'X' then 0 else stat.evtime end as EVTIME AS evtimeendasEVTIME,
  case is_parallel when 'X' then 0 else stat.evcount end as EVCOUNT AS evcountendasEVCOUNT,
  case is_parallel when '' then 0 else stat.evtime end as EVTIME_PARALLEL AS evtimeendasEVTIME_PARALLEL,
  case is_parallel when '' then 0 else stat.evcount end as EVCOUNT_PARALLEL AS evcountendasEVCOUNT_PARALLEL,
  stat.taskrun_count as evruncount AS task_list_runasTASK_LIST_RUN,
  stat2.taskrun_count AS evruncount
FROM rsb4h_stat AS stat
-- UNION with additional select branch(es): rsb4h_stat_aggr
;