topic Re: Table in Application Development and Automation Discussions

Table

Former Member — Tue, 02 Dec 2008 05:17:33 GMT

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

Re: Table

Former Member — Tue, 02 Dec 2008 05:23:44 GMT

check the link:

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

Re: Table

Former Member — Tue, 02 Dec 2008 05:36:51 GMT

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.

Re: Table

jaheer_hussain — Tue, 02 Dec 2008 06:16:09 GMT

Hi,

Please try thable AQG0DOC.

With Regards,

Jaheer

Re: Table

Former Member — Tue, 02 Dec 2008 06:22:31 GMT

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.

Re: Table

Former Member — Tue, 02 Dec 2008 06:24:53 GMT

Hello

Look at tables AQ*

May be it will help you.

Re: Table

Former Member — Tue, 02 Dec 2008 07:23:59 GMT

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.

Re: Table

Former Member — Tue, 02 Dec 2008 08:14:00 GMT

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.

Re: Table

matt — Tue, 02 Dec 2008 08:20:58 GMT

Please use a meaningful subject in future

Re: Table

Former Member — Tue, 02 Dec 2008 08:28:26 GMT

Sure, I will give understandable subject line.

Re: Table

Former Member — Tue, 02 Dec 2008 08:30:37 GMT

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

Thanks.