I_SLT_LastConfignItmRplctnDurn

DDL: I_SLT_LASTCONFIGNITMRPLCTNDURN SQL: ISLTLASTCIRPLDRN Type: view BASIC
2 Fields 1 Data Sources

Duration of last replication

I_SLT_LastConfignItmRplctnDurn is a Basic CDS View that provides data about "Duration of last replication" in SAP S/4HANA. It reads from 1 data source (P_SLT_RplctnLtncyTimeStmpCalct) and exposes 2 fields with key field MigrationObjectUUID.

Data Sources (1)

SourceAliasJoin Type
P_SLT_RplctnLtncyTimeStmpCalct P_SLT_RplctnLtncyTimeStmpCalct from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ISLTLASTCIRPLDRN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Duration of last replication view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY MigrationObjectUUID MigrationObjectUUID UUID 22 char.
LastReplicationDurationInSecs

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_LastConfignItmRplctnDurn.
-- 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: ISLTLASTCIRPLDRN

CREATE VIEW I_SLT_LastConfignItmRplctnDurn AS
SELECT
  MigrationObjectUUID,
  tstmp_seconds_between(MaxReplicationLatencyEndTime, TSTMP_CURRENT_UTCTIMESTAMP(), 'INITIAL') AS LastReplicationDurationInSecs
FROM P_SLT_RplctnLtncyTimeStmpCalct
;

Learn More