WHAT IS SQ01?

[Former Member]

SEND ME SOME SCREEN SHOTS ON SQ01

[former_member188594]

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]

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.