topic Re: Modifying Std SAP Query!! in Application Development and Automation Discussions

Modifying Std SAP Query!!

Former Member — Tue, 18 Apr 2006 13:38:29 GMT

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

Re: Modifying Std SAP Query!!

Former Member — Tue, 18 Apr 2006 13:47:07 GMT

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

Re: Modifying Std SAP Query!!

Former Member — Tue, 18 Apr 2006 13:57:51 GMT

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

Re: Modifying Std SAP Query!!

andreas_mann3 — Tue, 18 Apr 2006 14:01:35 GMT

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

Re: Modifying Std SAP Query!!

Former Member — Tue, 18 Apr 2006 14:01:36 GMT

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

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

Cheers

Message was edited by: Vijayendra Rao

Re: Modifying Std SAP Query!!

vinod_gunaware2 — Tue, 18 Apr 2006 15:40:32 GMT

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

Re: Modifying Std SAP Query!!

former_member181966 — Tue, 18 Apr 2006 15:43:58 GMT

Guide to learn Query !!!

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

Thanks

Saquib