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.

Objective

This guide will demonstrate the process of creating a custom report using transaction SQVI.

After logging into SAP System, enter transaction SQVI.


/wp-content/uploads/2016/03/1_910013.png

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.


/wp-content/uploads/2016/03/2_910014.png

Choose mode Basis Mode-To create list directly without design or Layout Mode-To design list click on Continue.


/wp-content/uploads/2016/03/3_910015.png

Select Tables using (Sift+F1) and specify their join condition and enter the tables to be joined here we are taking PA0000.


/wp-content/uploads/2016/03/4_910019.png

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.

/wp-content/uploads/2016/03/5_910025.png

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.


/wp-content/uploads/2016/03/6_910026.png

We can Correct join condition-Join condition can be edited by a right click on the horizontal line between the tables.


/wp-content/uploads/2016/03/7_910027.png

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:

PA0000-PERNR

PA0001-ENDDA

PA0001-BEGDA

PA0001-WERKS

PA0001-PERSG

PA0001-PERSK

PA0001-BTRTL

PA0001-ABKRS

PA0001-ENAME


/wp-content/uploads/2016/03/8_910031.png

Choose Selection Fields-Selection screen will contain following fields:

PA0000-STAT2

PA0000-ENDDA

PA0001-ABKRS

/wp-content/uploads/2016/03/9_910032.png

Choose the Sort sequence-Sort the output by PA0000-PERNR

/wp-content/uploads/2016/03/10_910033.png

Check Consistency (Ctrl+F6) and Execute F8.


/wp-content/uploads/2016/03/11_910034.png

Provide input parameters in selection and Execute


/wp-content/uploads/2016/03/12_910035.png

Output


/wp-content/uploads/2016/03/13_910036.png

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.

/wp-content/uploads/2016/03/14_910043.png

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.

Thanks

Omprasad Reddy

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply