Skip to Content
Technical Articles
Author's profile photo arghadip kar

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

 

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo S Abinath
      S Abinath

      Nice article Thanks for sharing, but topic been discussed a lot on community…

      Author's profile photo Nilesh Abhang
      Nilesh Abhang

      Dear Arghadip Kar,

      Great one !

      I Have done IBSUPPLIER to LFA1 to LFB1, Can you guide  me, in the SQVI how to Connect  LFA1 TO -> ADRNR TO ADR6->> Email Address, I am not able to generate report for Email address.

       

      Author's profile photo priya gupta
      priya gupta

      Thanks a lot, Sir for posting this blog on demand