Query Status - In active

[Former Member]

In table RSRREPDIR if query is inactive then does it mean query is deleted and cannot be accessed, When does the query turn to inactive(INA) status.

Is GEN1TIME = the last used time of the query, or do i need to get this info(last used time) from RSZCOMPDIR

Is there any link from where i will get the explanation for the fields in the table.

Cheers,

[Former Member]

Could you please also give the procedure on how do identify unused queries and delete it from the system.

[Former Member]

Use Tcode RSZDELETE to delete the queries and to see whaich queries are least used I think above tables are enough to analyis the last used timestamp of the queries.

For deletion of Queries Pls use REP in type field

Edited by: N S on Jan 19, 2011 1:23 PM

[Former Member]

Thanks NS,

Could you also indicate the scenarios in which the query turns to inactive ?

[Former Member]

Didn't had this kind of situationbut might be due to wrong definationa nd incorrect formulas

Also you can activate the same using RSRT.

Remember generation of queries will always help