Table

[Former Member]

Moderator message: please use a meaningful subject in future

Hi,

I am looking for the table which stores the SQL queries generated using sq01, sq02, sq03.

thanks.

Edited by: Matt on Dec 2, 2008 9:20 AM

[Former Member]

check the link:

[http://sapabap.iespana.es/sap/info/search_fields_tables.htm]

[Former Member]

Yes, I have tried the above ways it is giving me only the structure name, i also tried where used list for the data element as well as the domain, it is not giving the result. That is the reason, I am asking for the specific table which stores the queries generated using SQ01, SQ02 and SQ03 .

Thanks.

[Former Member]

Hello

Look at tables AQ*

May be it will help you.

[Former Member]

Thanks I have found the table which will store the queries generated, I have to generate a report which will get all the queries generated in SAP by customers, and then I have to differentiate them by functional area like (SD, MM, HR, FI) I have created the queries in Sand Box during the generation no where I had to give the functional area of the query, so how can I differentiate, I just gave the table used that data is being stored in the table AQGSCAT, now how can I relate the queries to the functional area.

Thanks.

[Former Member]

Hello

1. Table AQGSCAT contain field CLAS like /SAPQUERY/*

You may take two letters after '/SAPQUERY/' and analize this.

F.e.:

/SAPQUERY/FIBR - FI

/SAPQUERY/HR_ADM - HR

etc

2. This table contain logical database name. From this name you may determine functional area.

3. This table also contain table name. From this name you may also determine functional area.

[Former Member]

Yes, but for the queries I have generated the class is only my infoset name.

Thanks.

[jaheer_hussain]

Hi,

Please try thable AQG0DOC.

With Regards,

Jaheer

[Former Member]

IT IS AQGQDOC, I have tried it but that does not have queries I generated. I got a table AQGQCAT, , my entries are there in it but I am not sure whether this will store all the queries generated .Please give any inputs you think that is relevant to this .

Thanks.

[matt]

Please use a meaningful subject in future

[Former Member]

Sure, I will give understandable subject line.