How To Create A Query In Sap R/3 System?

1.	How To Create A Query In Sap R/3 System?
Answer» The query can be created and executed using the t-code SQVI: Execute the t-code SQVI. Enter the name of query to be created and click on create button. Enter the Title and comments for query and select the DATA SOURCE such as table or table join. Select the preferred view as Basis Mode or Layout Mode and click on continue button. Above step will take US to the NEW SCREEN, add the respective table on which we need to create a query. If Data source is selected as table join, select the respective tables as needed and joining fields. Save and come to main screen. Here, you need to select the fields to be displayed in output and their sequence. The query can be created and executed using the t-code SQVI. The query can be created and executed using the t-code SQVI:

Answer»

The query can be created and executed using the t-code SQVI:

Execute the t-code SQVI.
Enter the name of query to be created and click on create button.
Enter the Title and comments for query and select the DATA SOURCE such as table or table join.
Select the preferred view as Basis Mode or Layout Mode and click on continue button.
Above step will take US to the NEW SCREEN, add the respective table on which we need to create a query.
If Data source is selected as table join, select the respective tables as needed and joining fields.
Save and come to main screen. Here, you need to select the fields to be displayed in output and their sequence.
The query can be created and executed using the t-code SQVI.

The query can be created and executed using the t-code SQVI:

Discussion