Hi Experts,
Issue : A fully buffered table say TVARVC is used in a query. I wanted to do a basic check whether the contents are loaded to the buffer for the first time. And expected the second query on the same table to get values from the buffer and not from DB again as it is a buffered table. But i couldn't see the table in ST10.
Steps taken : I have gone through some blogs and checked results for Today - All server & this server in ST10. But there is no field called Buffer state to check whether it is loaded or active as mentioned in few blogs. On running ST10 for today, no records were displayed though i ran select query of a buffered table.
Queries : PLs enlighten me on what could be the issue..how can we make sure that a table is buffered and is active?
Note: Select statement is not having order by or any expressions to bypass the buffer. Pasting it below. Thanks in advance!
SELECT SINGLE low FROM tvarvc INTO @DATA(lv_low)WHERE name = 'A499'AND TYPE = 'S'AND SIGN = 'I'AND low EQ 'STK'.