This website is not affiliated with, sponsored by, or approved by SAP AG.

How To get a list of all queries in the system

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

How To get a list of all queries in the system

Postby carlosreis3 » Mon Mar 16, 2015 4:32 am

Hi,
Does any one know if is there a away to have a SQ01 or something else that gives you all the queries available in ECC system

Query | User_Group | Infoset | Created By| ===> Possible result structure

regards,
CR
carlosreis3
 
Posts: 18
Joined: Tue Nov 04, 2014 10:23 am

Re: How To get a list of all queries in the system

Postby Gothmog » Mon Mar 16, 2015 5:07 am

Depending on the query area, table AQLQCAT (standard area) or AQGQCAT (global area) will get you the user group, query name and infoset.
If you want Created by or other header information, use funciton module RSAQ_IMPORT_QUERY_HEADER.
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67
Gothmog
 
Posts: 1943
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: How To get a list of all queries in the system

Postby carlosreis3 » Mon Mar 16, 2015 5:20 am

Hi,

it worked, many thanks!
carlosreis3
 
Posts: 18
Joined: Tue Nov 04, 2014 10:23 am


Return to ABAP

Who is online

Users browsing this forum: No registered users and 9 guests





This website is not affiliated with, sponsored by, or approved by SAP AG.