How to create Report by using SQVI
Hi,
i would like share document for how to create report by using SQVI. I know Some of consultants aware about this. I am sharing this for who don’t have any idea about SQVI Query.
Transaction Code : SQVI (Quick Viewer)
enter name in place of quick view and click on create.
enter Title like description and select data source table join
Again click on table and enter table which should be link to previous table. Example in EKKO Po number it is linked to EKPO PO number.
Now extract the table which is showing left side
Here two rows showing 1) list fields 2) selection fields
selection fields means in selection screen what fields required , these fields are display in input selection screen
list fields means out put format.
Example i am selecting purchase document number, document date and material number as input fields.
and out put filed as material number, vendor number,PO number, item number, Po amount, Po qty, delivery date and scheduling qty, quantity of goods received, issued qty, PR number, PR item number .
If you want one filed as input and out put select both. If you want in only input screen then select only selection fields, if you want as out put select only list fields. For example see below screen
Once selection is completed, please save it.
Now execute (F8)
After lot of comments and suggestions, i am adding little more use full to other users.
First thanks to our greatest Lion Jurgen 🙂 for sharing the below documents. Lot of users they asking queries how we can see SQVI maintained report in other user. I am only R&D on SQVI, may be this is reason i am not found proper result. But Jurgen provided beautiful link, We can see now other user sqvi reports in our system.
Hope it is very helpfull to all.
Thanks for Jurgen .
Jurgen is always 100% right. 😘 ……..
If is there any mistakes. Please excuse ………
This is right way to use it..
Can i use this report in other user?
You can use all users, not only for MM users.
Thanks for you comment
Please check your document, i can only see 3 of your 13 screenshots
Hi Jurgen,
I have attached all screen shots but not uploading properly. Any way i again attached screens.
Thanks Jurgen
Are you certain you uploaded the screenshots? Pasting does not work properly.
When I look at the image name it is always saying pastedimage
in case this problem is with upoad then you should report a bug in http://scn.sap.com/community/support/scn-bug-reporting
Thank you.... Its very usefull to all freshers
Thanks Pramod for your comment.
Thanks Ravindra
There is some problem with screenshots otherwise good .
Thanks !!
Thank you so much. It is really helpful.
should this done in Production system?
Ya you can do in Production also.
Hi Ravindra,
Could you please tell me if sqvi is a sensitive transaction or anybody can take access to this?
Hi,
I hope any body can take this access. There is no impact on the existing screens..
If you like please give rating
really useful document
Hi Ravindra,
Thanks for your sharing your valuable knowledge.
one thing i want to know that, if there are 2 user id's (SAP_MM & SAP_SD).
i have created query using user id SAP_MM after that i have logged in with SAP_SD user id, but Query not showing there.
kindly share that above mentioned case is possible or not.
Regards
Dev
any reply?...............
Regards
Dev
Sorry for delay. SQVI report it will displayed in where and which user id based you created. Hope you understand.
You can copy to z report and give to access to all.
Hope it is help full to you
No Requirement of Z-Report here---Check Mr Jurgens Link completely:
How to find and execute or work with other users quick views (or quick views created with old user-id)?
Sorry Phani kumar, I am thinking you are asking in directly in SQVI, that is reason i am given reply like. In SQ01 it is possible.
Once again sorry ..........
Thanks for feedback.
Check above Jürgens comment. He has created a document in which it is explained how you can get other peoples SQVI queries to show.
In my reply above is also a link to this document.
I have seen some time back concept of left outer and right outer while linking the table can you please highlight on that.
good document for reference. thanks.
Great Job.........
Hi Ravindra,
Is it possible to attach the query with a T-Code,
I mean can i use the report by using a T-Code
hi Rahul,
you have to note program name after that SE93 will hlp you for tcode...
Regards
Hi Rahul,
For creation of t-code i already posted one blog for creation and assignment t-code to this sqvi report.
Please see below link
http://scn.sap.com/docs/DOC-43535
or you can use directly se93
Thanks Ravindra
Gone through both documents, found really helpful, Thanks
It is even possible to work with other users quickview, see my blog:
How to find and execute or work with other users quick views (or quick views created with old user-id)?
check my reputation and you will have the answer
This calls for a meme-style image with Samuel Jackson in it.
Jürgen is 100% correct in saying that via SQVI you can access other persons quick view.
Follow his guide and try it out. I know it works because I'm using the function.
Thanks Ravindra . good work.
Excellent validation ... Jurgen... 🙂 ... Truly inspiring on how you reach out to each and everything with a best in class solution.
Nice Doc.
Can we have a document as such of RTP Process.??
Thanks in advance
Hi,
Thank u for reading my documents.
I am not posted RTP Process previously. Will post document on RTP process shortly.
Thank you RD.
Hi,
As per your request I posted RTP process. Please check and if you getting any doubt please send reply or any suggestions.
Good article which explain steps of using SQVI. thanks for sharing 🙂
Thanks a lot Ravindra, for your helpful document.
Thanks ...........
Good document.
Regards,
Ibrahim
This guide also helps me during my first implementation. There are several reports that did not have to go through abaper at all. Thank you.
Hi ,
This doc is useful.
I have two queries:
Firstly, is there any way where we can define the type of join , whether Union, Intersection or so ?
Secondly, whats the difference between List Fields and Selection fields?
Regards,
Subhadra.
Listed Fields: means these fields will be visible in your Output
Selected Fields: these fields will be visible for selection when you are inputting the data.
Request you to do more practice--so you can clarify on yourself.
Phanikumar
Hi ,
Actually , I tried joining these two tables as LFA1 and LFB1.
however, only the selected fields from the first table are getting displayed , but no data is being fetched from the second table.
Can the join condition be changed ?
If yes , then how?
Can u pls guide me on this?
Regards,
Subhadra
Dear Subhadra
Once you are taking these two tables LIFNR will be the link between these two Tables.
Note: please follow this thread completely
Important Tools and Techniques - Advanced Techniques | SAP-SD
Phanikumar
Hello,
I did table join for EKKO and EKPO but in the output I only see one line item per purchase order.
How Can i see all line itemes/PO in output ?
Thanks,
Darshak
Darshak,
You'd probably be better off posting this as a discussion rather than a comment on a document. And you should show some screen prints of your SQVI, so people can have an idea of what the problem might be.
- Jeff
Darshak
Check your join conditions and delete join conditions if needed. If not mistaken join between EKKO and EKPO proposes join condition between EKKO LPONR (last item) and EKPO EBELP (Item number on the purchase document). If you delete this join condition you will see all data .
Very useful document, keep up the good work. 🙂 🙂
Very Nice document,thanks a lot
Hi Ravindra,
Good work...little more clear screen shots with pop up messages will make it perfect.
Vignesh.V
Hi,
Thank you .... Will try to make clear screen shot
Hi Ravindra garu,
I had created one Quick viewer for material group wise cost center GI report and GR report.
but it not showing all the transaction, where MB51 showing all.
Regards,
B V
What are tables used for this report. Can you explain brefiely.
Hi Ravindra garu,
I have selection tables MKPF, MSEG, CSKS, MARA and T023T.
selection screen fields are:
MKPF-BLDAT Document date
MKPF-BUDAT Posting date
MSEG-BWART Movement type
MSEG-MATNR Material No
MSEG-WERKS Plant
MSEG-LGORT S Location
MSEG-KOSTL Cost Center
MARA-MTART Material type
MARA-MATKL Material Group
Regards,
B V
which data you are missing .. Whether report was generated..
It is showing only 201 movement type documents other than this movement type system is not showing any results.
Regards,
B V
Hope it is looking for cost center related documents. why because you have considered report related to cost center.. CSKS ... is related to cost center.. system checking in this table should have entry..
This really help me a lot! Thank you Ravindra.
hi,
SQVI for the personal use... you can use SQ03,SQ02 and SQ01.
Create Query and make T-code and give authorization to multiple users.
Regards
KKK
Thank you, this works perfect
Does this affect if I have changed my PC.
It is not working for my new PC .
Please Help me to go through it.
Hi ,
I hope you have changed the user id. If you are changed the user id then you can't find the old reports.
And more over its not related to PC, you can try one more time. Hope you will get it this time.
Regards,
Ravindra