Table that stores all the SAP Query details including Changed by ,Date etc.

[Former Member]

Hi Folks,

I am just in search of a table that stores all the information about SAP queries like lastchanged by and changed date i found a structure RS38R which has all these fields.But i couldn't find the table equivalent to the same structure. Please help me finding a solution.

Please answer if you know the exact table which has the Query details with changed date,Created date also.

[Former Member]

My suggestion is:

goto table DD03L and try fieldnames from RS38R and that table displays list of tables got the fieldnames you specified .

Try AQ* IN SE11 aswell (displays list of tables with queries and all that).

Edited by: BrightSide on Mar 20, 2009 2:58 PM

Edited by: BrightSide on Mar 20, 2009 3:14 PM

Edited by: BrightSide on Mar 20, 2009 3:15 PM

[Former Member]

HI,

Check table TRDIR. It stores with genarated program name

If query name is AGENCY1 the table stores with AQZZ==/SAPQUERY/AGENCY1

[Former Member]

Guys,

Consider the situation - when the query is not atall executed for the first time, then it'll not generate any program, so TRDIR will not hold anything.

So the question remains same - what's the table name which holds the ABAP query status infos like

a. query created by (RS38R-CNAM)

b. query creation date (RS38R-CDAT)

c. Last changed by (RS38R-UNAM)

d. Date of last change (RS38R-UDAT)

Regards,

Jayanta Bej.

[ThomasZloch]

It seems that this data is stored in compressed format in table AQLDB, see function module RSAQ_IMPORT_QUERY_HEADER.

Thomas

[Former Member]

Thomas,

Checked the table and also the function module - both of them gets the entry related to the query only when the query is executed atleast once. But what will happen if the query is not atall executed for a single time. In which table I can get those status info which are actually available in the SQ01 --> Extras --> Status Info.

Regards,

Jayanta.

[Former Member]

Dear SAP Professional

Your attention and very precious time allocated to help again would be Truly Appreciated

Would you please help tell if there is any table store query name and info set name, please?

(There are a few similar query and similar info set, would like to find correct info set to edit and regenerate for specific querry)

Thank Very Much in Advance &Best Regards,

Table TDIR stores generated program from query in my system including querry authorization group

[Former Member]

Hi All,

I also have a similar kind of requirement. We have uncompressed the table AQLDB and we want to make the data in readable format. How can that be achived through ABAP code..?

Any ideas?

Many thanks,

Saikat