Standard service - a fixed amount of work that is performed at a fixed price.  Post Service


Wednesday, 15 May 2019 04:00

QuickView for Functional Consultants in S/4HANA

Written by
Rate this item
(0 votes)

QuickViews are views which can be created in SAP to display information as a report from single data source or multiple data sources efficiently without any coding involved.

Yes, you heard it right. You can create reports without any knowledge of ABAP programming. QuickView is nothing but the age old SQVI or Queries in our SAP ECC system. And nothing has changed in S/4HANA.

If you are already aware of SQVI or SQ01/02/03 transactions. You may quit this article and utilize your time learning something new. ?

The data can be directly read from a selected table, a table join or a logical database. QuickViews are therefore the simplest way to quickly display data from a particular source in an output ALV report with all inbuilt features to sort, hide and other aggregate functions.

Also Read: SQVI (Quick Viewer) for ABAP Developers

The only pre-requisite required for creating QuickView is the user should have authorization to transaction SQ01 or SQVI along with access to read data from data sources.

Implementation Example.

  • Step 1: Call Transaction SQVI
  • Step 2: Enter QuickView name which you want to create and click on create option provided. In the case below we have created ZTEST_QUICK as our QuickView.

One has to also select the data source option for the QuickView. Different QuickView options are table, table join, logical databases and sap query infoset. In our case since we want to display data from two different tables we use table join as dataset.

  • Step 3: Once you create QuickView with data source as table join following window will be displayed.

Click on Insert Table and add two tables (or more) from which you need to display data. In our case the two tables are ZYASH_HEADER and ZYASH_ITEM. Key fields will be mapped automatically (if the automatic mapping is incorrect, you can delete the link and map it manually) and then click exit.

Also Check – Free Video Course on HANA Models/Views

  • Step 4: Select the fields which need to be displayed in the report from the list of available fields.
  • Step 5: One can also add the selection conditions from the selection tab based on which results can be filtered. These fields would act like the input fields of the selection screen of the report.

Also Take – End to End Debugging Course for SAP Functionals

You can also specify the sort condition using the Sort Order tab.

  • Step 6: Click on execute and you see that the report is created automatically with the selection parameters mentioned by you.
  • Step 7: Enter the selection condition and click on more->program->execute

Here the users can perform all functionality what can be achieved in ALV like sorting, exporting data in excel sheet etc. You just created a report using SQVI without a single line of code.

We can add custom code to this report too. SQVI QuickView has a limitation.It can be accessed only by the user who created it. But this limitation can be mitigated by creating a t-code for the corresponding report program generated for the QuickView.

We can tie the report program to a t-code and share the t-code with other users or move to next SAP environment in our SAP Landscape.

If you have used SQVI in ECC, you must have been disappointed. There is no difference between ECC and S/4HANA QuickView. ?

This is my first article at SAPYard. Please leave your feedback and help me improve. Please let us know the topics you want us to cover in future.

If you want to have real time discussions and resolutions, do join our SAP Technical Telegram Group where we have more than 4815+ active SAP consultants from 6 Continents.

Please Note: You need to install Telegram App on your mobile first and then you can join the group using the above link.

Please SUBSCRIBE to SAPYard’s Youtube Channel for Free End to End SAP Video Course and Training.

Free SAP ABAP for HANA Training Tutorials Exercises.

Read 177 times

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.