Missing realtime records in Hana
I see a small latency in item details i.e vbap information when replicated through SLT . When i do realtime reporting using this transactional information it's incorrect. For example for Sales Order there are some line items missing in Hana i.e didn't get replicated yet at the time of reporting or view execution , however header and some items did get replicated. How can we handle this situation? Please help , this is urgent. Thanks.
Lars Breddemann replied
Nope, there's nothing to "monitor" here, since neither SLT nor SAP HANA know about which tables belong together on the source side.
You may consider to include filter conditions into your queries that only show data from, e.g. around 5 mins ago, to ensure that all dependent records have meanwhile been replicated.
If and how this is possible depends on the tables you're dealing with and if they come with some sort of update timestamp.