I_SLT_RplctnStatisticLastHour

DDL: I_SLT_RPLCTNSTATISTICLASTHOUR SQL: ISLTRPLCTNSTATHR Type: view BASIC

SLT Replication Statistics in Last Hour

I_SLT_RplctnStatisticLastHour is a Basic CDS View that provides data about "SLT Replication Statistics in Last Hour" in SAP S/4HANA. It reads from 2 data sources (P_SLT_RplctnStstcTimeStmpCalct, iuuc_repl_stat) and exposes 4 fields with key field MigrationObjectUUID.

Data Sources (2)

SourceAliasJoin Type
P_SLT_RplctnStstcTimeStmpCalct _TimeStampCalculation inner
iuuc_repl_stat iuuc_repl_stat from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ISLTRPLCTNSTATHR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SLT Replication Statistics in Last Hour view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY MigrationObjectUUID iuuc_repl_stat cobj_guid UUID 22 char.
NrOfRecordsInsertedLastHour
NrOfRecordsUpdatedLastHour
NrOfRecordsDeletedLastHour

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_SLT_RplctnStatisticLastHour.
-- 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: ISLTRPLCTNSTATHR

CREATE VIEW I_SLT_RplctnStatisticLastHour AS
SELECT
  iuuc_repl_stat.cobj_guid AS MigrationObjectUUID,
  sum(iuuc_repl_stat.ins_rec_actual) AS NrOfRecordsInsertedLastHour,
  sum(iuuc_repl_stat.upd_rec_actual) AS NrOfRecordsUpdatedLastHour,
  sum(iuuc_repl_stat.del_rec_actual) AS NrOfRecordsDeletedLastHour
FROM iuuc_repl_stat
INNER JOIN P_SLT_RplctnStstcTimeStmpCalct AS _TimeStampCalculation ON /* join condition not captured in parsed metadata */
;