How to Write a Report Directly in Production and share it with use of SQVI?

Introduction

Anyone who works in SAP Production environment is faced with the situation to Build quick Reports on the Fly without moving Transports. In most companies the Process to move Transports goes through a lot a Processes which takes a lot of Time. A simple requirement can be find me all the Purchase order with vendor Name and that are attached to a Workorder. Yes this will require a simple join and to build this with CDS/ABAP I need transport and I have someone breathing down my neck to get this Report.

The below solution is a life saver and works wonders for simple joins.

Solution

Everybody knows how to create an ABAP Query and trust me you can find a lot of them in SCN.

Here is a Link in case you need it.

https://blogs.sap.com/2015/12/21/equipment-task-list-display-report-by-using-sqvi/

Our Blog starts after we have created the much needed ABAP Query.

Go to SQVI Transaction Code

Now Follow the below path to generate the Program for your SQVI Query.

Now follow the below Path to get the Generated Program Name.

Here is Our Generated Program Name.

Go To SE38 and Paste the Program Name

Wala here is our Selection Screen. Please be aware this can be useful for Users who have SE38 Authorization in Production. Still it is a fair deal than moving Transports in the fly. We can use SQ01 also for which you can get lots of Blog.

Conclusion

You can use this Blog for both SAP ECC and S/4 HANA. Please remember this is system Specific and we should use this only for emergency purpose 🙂 This is not an alternative for ABAP Program with a proper Timeline.

Below is the Video Version

Create ABAP Query