SQVI and SQ01 are two different transaction codes used in SAP for query development.
- SQVI (QuickViewer): SQVI is a simple and user-friendly transaction that creates basic ad-hoc queries in SAP. It allows users to define reports without the need for extensive programming knowledge. SQVI provides a graphical interface where you can select tables, and fields, and apply filters to retrieve data. It is typically used for quick data analysis and reporting requirements.
Key features of SQVI:
- Easy-to-use graphical interface.
- Limited options for complex query development.
- Can only access single tables or join tables using simple conditions.
- Limited options for formatting and advanced calculations.
- Suitable for basic reporting needs and quick data analysis.
- Do not require to be assigned to a User Group to execute.
- SQ01 (Query): SQ01 is a more comprehensive and advanced transaction used for creating complex queries in SAP. It provides a broader range of options and functionalities compared to SQVI. SQ01 allows you to define sophisticated reports by utilizing logical databases, complex joins, user-defined functions, and other advanced features.
Key features of SQ01:
- Offers a broader range of query development options.
- Can access multiple tables using complex join conditions.
- Supports logical databases, which provide pre-defined data structures for commonly used reports.
- Enables the creation of user-defined functions and formulas.
- Provides more advanced formatting and layout options.
- Suitable for complex reporting requirements and customized data analysis.
- SAP User must be a part of the User Group assigned to the InfoSet Query for execution.
In summary, SQVI is a quick and simple tool for basic ad-hoc queries, while SQ01 offers more advanced capabilities and flexibility for complex query development and reporting. The choice between SQVI and SQ01 depends on the complexity of the reporting requirements and the level of customization needed.
How to create an SAP Query using SQ01?
- Begin with Transaction SQ03 to create a User Group and here assign Users who should execute the related Queries.
Example: User group: AB
Description: India Logistics Team
Add All SAP Users inside it.
- Navigate to InfoSets via Environment Menu to create a new InfoSets where we will connect the required SAP Tables in a logical way to create a report via SAP Query.
Example: Z_AB_SALES_DATA
Description: India Sales Data
Choose Authorization Group as AB, Enter Description, Choose Table Join using basis tables in our case or others like direct read or via logical database depending on your query complexity and create.
Use Icon Join to Insert Tables as per your requirement:-
Like VBAK, VBAP, VBEP, KNA1, ADRC etc.
Always remember to create links between them using a primary key, Although SAP creates it automatically, You may delete unwanted links and relink them as per your logic.
Example links between KNA1 & ADRC and other tables are depicted below:-
Delete the link you think is unnecessary by right click and deleting And creating New Links.
At last, once all the links are properly done. Click on Infoset and choose Include Key Fields to add to the Field groups.
Select the Field and drag and drop to the right side Field groups to use it as input or as output for the Query.
Once Done for all the tables, SAP InfoSets can be generated and saved.
Now Navigate to User Group from the Environment menu, Make sure it’s selected to User Group AB and assigned. then again navigate to Query via the Environment menu.
- Create a New Query and select the Input and output fields necessary for the Query Report.
Example Z_SALES_REPORT Query is created and Fields are selected like below.
Choose Which Field should be the base for Input and output and select accordingly and save.
Then Query is ready to execute and pull the report.
Cheers !
