Steps For Using Query SQ01, SQ02, SQ03 - Part 2

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

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.