Modifying Std SAP Query!!

[Former Member]

Hi All,

There is transaction which takes me to the selection screen and if i go to the status and get the program name it displays some long strange name (since it's a SAP query ), so my question is:

1> How to get the infoset attached to this query and if am to modify the query how to do that?

2> if i go to Sq01 and enter what i got as program name it says this query doesnt exists!!

so i guess the query name and report name generated on the fly are diff..

so how do i know the query name ??

plz help..

for example goto transaction s_alr_87012168...

Thx

Gunjan

Message was edited by: Gunjan

[Former Member]

Goto sq01 and click on the first button on the application tool bar which is user group. This will popup the different user groups.

Select the user group relevant to you and this will being up all the queries associated along with that user group. Select the query and execute it.

Hope this helps

cheers

vj

[Former Member]

hi

thx for that!!..but again i dont see my sap query among the displayed ones!!....is ther any other way?...where r these queries being stored?

help.......

thx

gunjan

[Former Member]

Hi Gunjan,

You can only view those queries assigned to your user group. Or if the query is global.

try doing a sql trace on sq01 you might get the underlying tables.

Regards

VJ

Look for AQ* tables you will find few tables where you can lookup.

Cheers

VJ

Message was edited by: Vijayendra Rao

[andreas_mann3]

hi,

your example is not a query.

I think that are special reports from

<a href="http://help.sap.com/saphelp_47x200/helpdata/en/5c/c1d119445f11d189f00000e81ddfac/frameset.htm">Displaying the Due Date Analysis</a>

Andreas

[vinod_gunaware2]

SQ00 ABAP/4 Query: Start Queries

SQ01 ABAP/4 Query: Maintain Queries

SQ02 ABAP/4 Query: Maintain Funct. Areas

SQ03 ABAP/4 Query: Maintain User Groups

SQ07 ABAP/4 Query: Language Comparison

Change or select USER groups. U can find ur query.

Or if u know trasaction goto se93 find name of program from that u can find out name of query.

regards

vinod

[former_member181966]

Guide to learn Query !!!

http://www.sappoint.com/abap/ab4query.pdf

Thanks

Saquib