What is SAP SQ01 used for?

Posted on by Mary Andersen

What is SAP SQ01 used for?

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.

How do I transport a query report in SAP?

Call transaction SQ02 again in the standard area of the target system, and choose the Transports button to branch to the query transport tool. Now select the transport action Import . In the Dataset with Imports row, enter the number of the transport request that contains the transported query objects.

How do I Create a query using SQ01?

CREATING A QUERY

  1. Goto SQ01.
  2. Give the description of the query in the next screen.
  3. Click on the next screen, select the field group to be used.
  4. Click on the next screen, select the fields you want displayed.

How do I copy a SQ01 query in SAP?

how to copy existing query report into new query report

  1. 1.In SQ01 go to “”EDIT->other user group”” and i selected user group as /SAPQUERY/FK.
  2. I typed F1 in query field and click change button.

How do I find query in SQ01?

An InfoSet can be assigned to several roles or user groups.

  1. Advantages–
  2. Goto SQ01.
  3. Give the description of the query in the next screen.
  4. Click on the next screen, select the field group to be used.
  5. Click on the next screen, select the fields you want displayed.

How do I export a SQ01 query?

Assigned Tags

  1. Goto transaction SQ02.
  2. Click on ‘ Transports’ icon (CTRL+F3).
  3. In ‘Transport action’ select ‘Download’.
  4. Select 4th radio button ‘Transport Queris’.
  5. Enter the name your user group and query and click on execute.
  6. Give the file name and location where you want to save the query backup and click on save.

How do I Create a report in SQ01 in SAP?

As soon as a suitable InfoSet is available for your user group, you can generate a query for it:

  1. Call transaction SQ01.
  2. To execute an existing query, select it from the table, and choose Execute (F8).
  3. To create a new query, enter a name for it, and choose the Create button.

How do I write a query in SQ01?

How do I add a query to a TR in SAP?

Use Existing TR or Create new TR using the Icon “create request”–> write Description of TR–>Save… Now the system automatically Generated new TR Number. ( below screen shot)–>click OK.. Then click the Refresh button on à now the Query is assigned with Transport request along with Package.

How do I create a report in SQ01?