Creation of a Query using the SAP Query Tool Part 3

Navigate to the Maintain Queries Initial screen by using the transaction code /nSQ01.

The title bar lists the query group you are currently in. For example, your title bar

might read Query from User Group ZTEST: Initial Screen. 

 

In the Query field, type ZMY_QUERY as the name for the query you are creating, and then click the Create button.

 

The Info-sets of User Group ZTEST window appears, listing all the available InfoSets (that is, data sources) for your query group. Select the Info-Set you created (Z_SALES_DOCU_DATA, in my example) and then click the green check mark button .

 

 

The Create Query Title Format screen appears. This screen allows you to save the you want to store for the query. The only required field is the Title (long report description). For this example, fill in only the Title field, and then click Save.

  

Click the Basic List button from the Application toolbar to create an SAP basic list query. 

 

 

The Basic List Line Structure screen appears, showing a list of the fields you selected to include in your report.

 

 

In your left hand pane all table fields that you selected in info-set will appear.

In the Select Field screen, a list of all the available field groups populated during the creation of the Info-Set is expanded to display all the fields contained within them. You place a check mark next to any field you want to include in your SAP query and follow same procedure for List fields that you want to include in your output.

 

 

Then save the query. Following view appears.

 

 

Then execute.

 

 Done!!!