Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

WHAT IS SQ01?

Former Member
15,836

SEND ME SOME SCREEN SHOTS ON SQ01

2 REPLIES 2

former_member188594
Active Participant
0 Kudos
1,567

Hi,

SQ01 is the transaction code for Query from user group/SAPQUERY/xxxx: Initial screen. ABAP Query is a tool to create report without much coding. This tcode will display a screen with options : change, create, quick viewer, infoset query, display, and description.

Former Member
0 Kudos
1,567

Hi,

From here you can create your own queries (similar to local objects) which can then be converted into InfoSets/Queries in which users can access.

1. Enter a name + Create

2. Give a description, decide if Data Source is a table (single) or a join (many)

3. I assume you are creating a join. When you select join it will take you into the tool to generate the query. The first step is selecting (and joining) your tables. Insert table (Shift +F1) will get you started here. Once all your data is selected you green arrow back to select/map out your selection criteria and the data in which you wish to list in the results.

4. You can execute from here as well to confirm your results

5. Once you are good to go, you can easily convert this query by going back to SQ01 (select SAP Query). Enter your QuickView query name and then in the menu path select Query --> ConvertQuickView. This will then prompt you through the steps to convert your QuickView Query into an SAP infoset/Query.

6. Once you have created the SAP Query you can then assign usergroups via menu path environment --> usergroups for authorization. This allows others to execute your query, however not create one themselves.

Take a look on this link,

http://abapexpert.blogspot.com/2007_07_01_archive.html

Thanks.