sq01

[Former Member]

what is sq01??i need to do a queri using sq01!!!

the selection fileds are po doc vendor no,material no and output fieldsa are material no,po doc no,vendor no,gr doc no,gr posting date etc.can u give me the code

[Former Member]

Hi,

Check this link, It might helps you.

https://forums.sdn.sap.com/click.jspa?searchID=7649478&messageID=4365732

Thanks.

[Former Member]

THE thread specified by you was not found!!plss send me another link!!or can u tell me how do go abt this while creating the query for my requirement

[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.