AUM_RESULTS_V

DDL: AUM_RESULTS_V Type: view_entity
24 Fields 5 Data Sources

AUM_RESULTS_V is a CDS View in SAP S/4HANA. It reads from 5 data sources (aum_alerts, tadir, sedt_prog_tadir, aum_results, aum_times) and exposes 24 fields with key fields run_id, container, testclass, testmethod, pass.

Data Sources (5)

SourceAliasJoin Type
aum_alerts a left_outer
tadir d left_outer
sedt_prog_tadir i left_outer
aum_results r from
aum_times t left_outer

Annotations (1)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY run_id aum_results run_id UUID
KEY container aum_results container Unit
KEY testclass aum_results testclass
KEY testmethod aum_results testmethod
KEY pass aum_results pass Data Driven Tests: ID per data set
object_type sedt_prog_tadir object_type Type
object_name sedt_prog_tadir object_name Technical Name
devclass tadir devclass Package (Obsolete)
status aum_results status Workflow Status
server aum_results server Server
text aum_alerts text User Group
msgid aum_alerts msgid Message ID
exp aum_alerts exp Issued by
act aum_alerts act Switch
include aum_alerts include
line aum_alerts line VAT Return Line Item
started aum_times started Timestamp
dec233else0endasDuration Duration of a single test method.
dec233else0endasSetupDuration
dec233else0endasTeardownDuration
dec233else0endasCreateDuration
dec233endasNetDuration
details aum_alerts details Phone Number
stack aum_alerts stack Bin Stack

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 AUM_RESULTS_V.
-- 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 AUM_RESULTS_V AS
SELECT
  r.run_id AS run_id,
  r.container AS container,
  r.testclass AS testclass,
  r.testmethod AS testmethod,
  r.pass AS pass,
  i.object_type AS object_type,
  i.object_name AS object_name,
  d.devclass AS devclass,
  r.status AS status,
  r.server AS server,
  a.text AS text,
  a.msgid AS msgid,
  a.exp AS exp,
  a.act AS act,
  a.include AS include,
  a.line AS line,
  t.started AS started,
  case when t.started > 0 then cast ( round( utcl_seconds_between( tstmpl_to_utcl(t.started, 'INITIAL', 'INITIAL') , tstmpl_to_utcl( t.ended, 'INITIAL', 'INITIAL' )) , 3) as abap.dec(23,3)) else 0 end as Duration AS dec233else0endasDuration,
  case when t.setup_started > 0 then cast ( round( utcl_seconds_between(tstmpl_to_utcl(t.setup_started, 'INITIAL', 'INITIAL'), tstmpl_to_utcl(t.setup_ended, 'INITIAL', 'INITIAL')) , 3) as abap.dec(23,3)) else 0 end as SetupDuration AS dec233else0endasSetupDuration,
  case when t.teardown_started > 0 then cast ( round( utcl_seconds_between(tstmpl_to_utcl(t.teardown_started, 'INITIAL', 'INITIAL'), tstmpl_to_utcl( t.teardown_ended, 'INITIAL', 'INITIAL')) , 3) as abap.dec(23,3)) else 0 end as TeardownDuration AS dec233else0endasTeardownDuration,
  case when t.create_started > 0 then cast ( round( utcl_seconds_between(tstmpl_to_utcl(t.create_started, 'INITIAL', 'INITIAL'), tstmpl_to_utcl( t.create_ended , 'INITIAL', 'INITIAL')) , 3) as abap.dec(23,3)) else 0 end as CreateDuration AS dec233else0endasCreateDuration,
  case when t.testmethod is initial then 0 else cast ( round( utcl_seconds_between(tstmpl_to_utcl( t.started, 'INITIAL', 'INITIAL'), tstmpl_to_utcl( t.ended , 'INITIAL', 'INITIAL')) - ( utcl_seconds_between(tstmpl_to_utcl( t.create_started , 'INITIAL', 'INITIAL'), tstmpl_to_utcl( t.create_ended, 'INITIAL', 'INITIAL')) + utcl_seconds_between(tstmpl_to_utcl( t.setup_started , 'INITIAL', 'INITIAL'), tstmpl_to_utcl( t.setup_ended , 'INITIAL', 'INITIAL')) + utcl_seconds_between(tstmpl_to_utcl( t.teardown_started, 'INITIAL', 'INITIAL'), tstmpl_to_utcl( t.teardown_ended, 'INITIAL', 'INITIAL')) ) , 3) as abap.dec(23,3) ) end as NetDuration AS dec233endasNetDuration,
  a.details AS details,
  a.stack AS stack
FROM aum_results AS r
LEFT OUTER JOIN sedt_prog_tadir AS i ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tadir AS d ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aum_times AS t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aum_alerts AS a ON /* join condition not captured in parsed metadata */
;

Learn More