Question - 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.