Report Generation by Quick Viewer-SQVI
Quick Viewer is a Report Generating tool. Quick Viewer has been designed for users with little or no knowledge of the SAP programming language. It generates simple reports as per business need, without the need for any ABAP coding. It is quick and easy to use tool for quick collection of data from SAP R/3 system.
This guide will demonstrate the process of creating a custom report using transaction SQVI.
After logging into SAP System, enter transaction SQVI.
Enter name of the Quick View and press Create
Input Title and Comment. Enter a title for your report. In this example Employees List and Choose “Table Join” in the drop down menu as the Data Source.
Following Data sources can be used:
Table: Select this when business requirement is to fetch records from only single database table.
Table Join: Select this when business requirement is to fetch records from more than one table.
Logical Database: Select this when business requirement is to fetch records from a Logical Database(PNP,PNPCE,PCH and PAP).
SAP Query InfoSet: Select this when business requirement is to fetch records based on an available InfoSet of a SAP Query.
Choose mode Basis Mode-To create list directly without design or Layout Mode-To design list click on Continue.
Select Tables using (Sift+F1) and specify their join condition and enter the tables to be joined here we are taking PA0000.
Again Select Tables using (Sift+F1) and specify their join condition and enter the tables to be joined here we are taking PA0001.Like wise we can join Tables.
SAP automatically proposes joins based on data type of the field. Join condition is represented as horizontal line connecting the fields of the database tables.
We can Correct join condition-Join condition can be edited by a right click on the horizontal line between the tables.
Press F3and reach to main screen. Also press to change mode and choose the field to be displayed.
Output will display following fields from the database tables:
Choose Selection Fields-Selection screen will contain following fields:
Choose the Sort sequence-Sort the output by PA0000-PERNR
Check Consistency (Ctrl+F6) and Execute F8.
Provide input parameters in selection and Execute
Converting Quick Views to TCODE-Go to system status and copy program name. Go to SE93 and enter TCODE name as YHR_EMPLY and create and past the program name and save.
Now we can use TCODE-YHR_EMPLY for executing report.
I hope you all enjoyed reading through this document. If you liked this document and found it to be beneficial, request you to please kindly rate it for the benefit of other users.