Adding current time stamp based upon the source system tables in hana

[#1]

Hello Experts,

I have a scenario as explained below...

Through a procedure , we are extracting data from hana calculation view to a reporting table through a field called LAST_CHANGED ( updates the last changed timestamp in the base tables )

Now when are tables are getting replicated through SLT , we expect a latency delay

ie: if a table is getting changed at 3:00 pm at the source , my view (target) gets the data at 3.30 pm. So in order to deal with this we are planning to have a current timestamp filed in the View so that my procedure can extract the delta records based upon the current time stamp field from the view.

need suggestions on how to handle this situation apart from using DB triggers (As it is not recommended by SAP)

Thanks for your help.

[Cocquerel]

You may have a look to HANA Native Datastore Object (NDSO) if it fits your requirement, see https://help.sap.com/viewer/1e4f857a22aa477081d41d3b6fa48d99/2.0.3.0/en-US/10c100f55eb640c8ad71fdfd3...