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.
- 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.
Free SAP ABAP for HANA Training Tutorials Exercises.
- ABAP on SAP HANA. Part I. First Program in ABAP HANA
- ABAP on SAP HANA. Part II. ADT Eclipse and HANA Studio
- ABAP on SAP HANA. Part III. Debugging in ADT
- CDS Part 1. Core Data Services – Introduction
- CDS Part 2. Core Data Services – Deep Dive
- ABAP on SAP HANA. Part VI. New Age Open SQL ABAP 740
- ABAP on SAP HANA. Part VII. SQL Script and SAP HANA Stored Procedure
- ABAP on SAP HANA. Part VIII. ADBC – ABAP DataBase Connectivity
- ABAP on SAP HANA. Part IX. AMDP – ABAP Managed Database Procedure
- ABAP on SAP HANA. Part X. AMDP with SELECT OPTIONS
- ABAP on SAP HANA. Part XI. Are Native SQL and Open SQL Competitors?
- ABAP on SAP HANA. Part XII. Open SQL, CDS or AMDP, which Code to Data Technique to use?
- ABAP on SAP HANA. Part XIII. Sample Functional Specification of HANA Project
- ABAP on SAP HANA: Part XIV. HANA Ready, HANA-tization & HANA Plus
- CDS Part 3. Expose CDS Views as OData Service through Annotation
- ABAP on SAP HANA: Part XVI. HANAtization
- ABAP on SAP HANA: Part XVII. ATC – ABAP Test Cockpit Setup & Exemption Process
- SAP ABAP on HANA: Part XVIII. SALV IDA (Integrated Data Access)
- ABAP for SAP HANA. Part XIX. Sample Technical Specification of HANA Project
- ABAP for SAP HANA. Part XX. ALV Report On SAP HANA – Opportunities And Challenges
- 4 Useful Tips on ABAP and ABAP on HANA
- Associations in HANA – A Conceptual Approach
- CDS Part 5. ABAP CDS Views With Authorization
- ABAP for SAP HANA. Part XXII. How to Consume Native HANA Views Using ADBC?
- CDS Part 6. Basic Expressions & Operations Available for CDS View – I
- 115 ABAP for SAP HANA Interview Questions & Answers
- CDS Part 7. Basic Expressions & Operations Available for CDS View – II
- CDS Part 8. Usage of Built-In Functions in CDS – I
- CDS Part 9. Usage of Built-In Functions in CDS – II
- CDS Part 10. Usage of Built-In Functions in CDS – III
- CDS Part 11. How to Consume CDS View in Smart Business Service KPI Fiori Apps?
- CDS Part 12. Useful 6 CDS Related Tools in ADT
- CDS Part 13. Key Definition in CDS Views
- CDS Part 14. ABAP Annotations for Translatable Texts in CDS Views
- CDS Part 15. Associations in CDS Views – I
- ABAP for SAP HANA – Part 23. How to Access Database Schema Dynamically Using AMDP?
- Video Course – New Features and Syntaxes in SAP ABAP 7.40+ with Exercises
- CDS Part 16. Usage of Built-In Functions in CDS – IV
- ‘ABAP for SAP HANA’ Points to Remember
- Limitations of Open SQL Compared to SQL Script in HANA