ERP SAP Modules ==> ABAP

Step 4: Creating Query – SQ00 & SQ01

Follow the menu path – SAP Menu -> Tools -> ABAP Workbench -> Utilities -> SAP Query -> Queries

a) In the “Query from User Group: Initial Screen - 
- Click on “Other User Groups” button
- In the pop-up screen, User Groups, select the User Group for which the Query has to created. The pop-up screen closes.
- Enter the Query Code in the “Query” field
- Click on “Create” button

b) A pop-up screen “Restrict Value Range” shows the list of Infosets assigned to the User Group
- Select the Infoset for which Query has to be created

c) In the new screen Create Query: Title, Format - 
- Enter the Description of the Query in the “Title” field
- Click on the “Next Screen” button

d) In the Select Field Group” screen
- Select the Field Groups from which Data Fields have to be selected for the Output
- Click on the “Next Screen” button

e) In the “Select Field” screen - 
- Select the Data Fields which should appear in the output
- Click on the “Next Screen” button

f) In the Screen “Selection” -
- Select the Data Fields for the selection criteria
- Enter the sequence in which the selected fields would appear in the input screen of the query.
- Define if the selection criteria should be Single Value or Multiple Value Rangeby clicking in the appropriate check boxes
- Click on the “Basic List’ button

g) In the screen “Query Layout Design” - 
- Select the Output Fields from the Data Fields section by clicking the appropriate check box
- Change the sequence of Data Field columns if required
- Click on the “Test” button to test the query created

h) On the “Test Query” screen click “Continue”

i) In the “Query” screen -
- Enter the selection criteria
- Click on “Execute” button

j) Save the Query created

Step 5: Running the Query – SQ00
a) In the Query From User Group: Initial screen – 

b) Click on “Other User Groups” button to select the User Group

c) In the pop-up screen “User Groups” select the User Group

d) System lists all the queries created for the User Group

e) Select the appropriate Query

f) Click on “Execute” button

g) User is taken to the Selection screen

h) Enter the selection criteria and click on “Execute” button

i) System runs the query and gives the output

ABAP Query Part 1
Steps For Using Query SQ01, SQ02, SQ03 - Part 1

Get help for your ABAP problems
Do you have a ABAP Question?

ABAP Books
ABAP Certification, BAPI, Java, Web Programming, Smart Forms, Sapscripts Reference Books

More ABAP Tips

• ABAP Programming Tips and Tricks
• ABAP Functions Examples - ABAP Questions - BAPI Programming Tips
• BDC Programming Tips - Sapscripts Tips - Smartforms Tips