Skip to Content
Technical Articles

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

 

4 Comments
You must be Logged on to comment or reply to a post.
  • 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.

     

  • Thanks for sharing this information it is very useful information which you provided. I remember when  I am in college I didn’t want to create my assignments or reports as well, then my cousin suggested me to use this https://edubirdie.net/ and when I took services from there I really liked it even now sometime I use it. I can just suggest to all used this one for best writing services.