ST02 table not found as buffered, but ST05 buffer traced

[Former Member]

- activated table buffering in SE11 (for Z* table-view, generic buffering, 2 fields)

- then wrote ABAP test-program

- then traced with ST05 OK

  (trace records are found: first select from DB, then read from Buffer)

but in ST02 the table is not showing at all

(Details Analysis Menu, Table buffers: Generic Key, Buffered Objects)

Do table-views not show up in ST02? or when/how do they show up?

Can I refresh the info? (the Refresh Button didn't help)

(this is a test system with only one Application Server - so I should be on the correct server)

AHGA

[Former Member]

Hi,

Did you check by clicking the button in ST02?

(Details Analysis Menu, Table buffers: Generic Key, Buffered Objects)

and then "Analyze table"

[Former Member]

AFAIK this is DB05 which I personally use only for examining selectivity before creating table buffering or a DB-Table index;

but I did try your suggestion, and this gives this message

>>

Table ZPA_A_SFLIGHT_V does not exist

Message no. S1350

Diagnosis

The selected table does not exist on the database.

Either it does not exist in the Data Dictionary

or it is only a structure or a view.

<<

where ZPA_A_SFLIGHT_V is a database-view created in se11 which has table buffering activated

and traced buffering in ST05

thx

[Former Member]

I wonder how you set the "buffering active" for a view? The "Technical Setting" is only available for database table not view. So while make the selection , please use the table name and not the view name. It looks like ZPA_A_SFLIGHT is the database table name. Try with this only.

[Former Member]

FWIW

apparently ST02 gathered the info (generically buffered tables, since startup)

into BUFFERED_TABLES[] via

- report rstabl11

-- form get_shm_statistic.

--- call function 'SAPWL_TABSTAT_SINCE_STARTUP'

---- call function 'SAPTUNE_TABLE_STATISTICS'

----- call function 'DB_SHOW_TABLE_STATISTICS'

------  call 'DB_RSQLSTA' id 'T'  field db_stat_item_tab[]

                          id '64' field 64bit_support.

when here in DB_STAT_ITEM_TAB[]

there is no entry in field "TNAME" for the Z* tableview(database view) in question

(with generic table buffering enabled in SE11,

and whose buffering was successfully traced with st05)