RODPS_REPL_AUDIT_VIEW1

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 RODPS_REPL_AUDIT_VIEW1.
-- 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: RODPS_AUDIT1

CREATE VIEW RODPS_REPL_AUDIT_VIEW1 AS
SELECT
  rkey.pointer AS pointer,
  rkey.modelname AS modelname,
  rkey.queuename AS queuename,
  rkey.rid AS rid,
  rkey.delta_extension AS delta_init,
  rkey.uname AS username,
  rkey.closed AS closed,
  sum(tid.packagesize) / cast(1000 as float) AS requestsize,
  rkey.caller AS caller,
  rkey.unpermitted AS unpermitted
FROM rodps_repl_key AS rkey
LEFT OUTER JOIN rodps_repl_tid_packagesize AS tid ON /* join condition not captured in parsed metadata */
;