Skip to Content
Author's profile photo Ravindra Devarapalli

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.

/wp-content/uploads/2013/07/1_246547.png

enter Title like description and select data source table join

/wp-content/uploads/2013/07/2_321602.png

/wp-content/uploads/2013/07/3_321595.png

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.

/wp-content/uploads/2013/07/7_246611.png

Now extract the table which is showing left side

/wp-content/uploads/2013/07/8_246612.png

Here two rows showing 1)  list fields 2) selection fields 

/wp-content/uploads/2013/07/9_246613.png

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

/wp-content/uploads/2013/07/10_246614.png

Once selection is completed, please save it.

/wp-content/uploads/2013/07/11_246615.png

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.

http://scn.sap.com/community/erp/logistics-mm/blog/2012/03/22/how-to-find-and-execute-or-work-with-other-users-quick-views-or-quick-views-created-with-old-user-id

Hope it is very helpfull to all.

Thanks for Jurgen .

Jurgen is always 100% right. 😘 ……..

If is there any mistakes. Please excuse ………

Assigned tags

      66 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      This is right way to use it..

      Can i use this report in other user?

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      You can use all users, not only for MM users.

      Thanks for you comment

      Author's profile photo Jürgen L
      Jürgen L

      Please check your document, i can only see 3 of your 13 screenshots

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      Hi Jurgen,

      I have attached all screen shots but not uploading properly. Any way i again attached screens.

      Thanks Jurgen

      Author's profile photo Jürgen L
      Jürgen L

      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

      Author's profile photo pramod balanagendra
      pramod balanagendra

      Thank you.... Its very usefull to all freshers

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      Thanks Pramod for your comment.

      Author's profile photo Praveen Kumar G
      Praveen Kumar G

      Thanks Ravindra

      Author's profile photo Former Member
      Former Member

      There is some problem with screenshots otherwise good .

      Thanks !!

      Author's profile photo Former Member
      Former Member

      Thank you so much. It is really helpful.

      Author's profile photo Former Member
      Former Member

      should this done in Production system?

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      Ya you can do in Production also.

      Author's profile photo Former Member
      Former Member

      Hi Ravindra,

      Could you please tell me if sqvi is a sensitive transaction or anybody can take access to this?

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      Hi,

      I hope any body can take this access. There is no impact on the existing screens..

      If you like please give rating 

      Author's profile photo Senthil Nayagam
      Senthil Nayagam

      really useful document

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Former Member
      Former Member

      any reply?...............

      Regards

      Dev

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      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

      Author's profile photo Phanikumar Valiveti
      Phanikumar Valiveti

      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)?

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      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.

      Author's profile photo Peter Pallen
      Peter Pallen

      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.

      Author's profile photo Former Member
      Former Member

      I have seen some time back concept of left outer and right outer while linking the table can you please highlight on that.

      Author's profile photo Former Member
      Former Member

      good document for reference. thanks.

      Author's profile photo Ganesh Babu
      Ganesh Babu

      Great Job.........

      Author's profile photo Rahul Kottaparambil
      Rahul Kottaparambil

      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

      Author's profile photo Mehmet Ozgur Unal
      Mehmet Ozgur Unal

      hi Rahul,

      you have to note program name after that SE93 will hlp you for tcode...

      Regards

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      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

      Author's profile photo Rahul Kottaparambil
      Rahul Kottaparambil

      Thanks Ravindra

      Author's profile photo Former Member
      Former Member

      Gone through both documents, found really helpful, Thanks

      Author's profile photo Jürgen L
      Jürgen L

      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)?

      Author's profile photo Jürgen L
      Jürgen L

      check my reputation and you will have the answer

      Author's profile photo Former Member
      Former Member

      This calls for a meme-style image with Samuel Jackson in it.

      Author's profile photo Peter Pallen
      Peter Pallen

      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.

      Author's profile photo manu m
      manu m

      Thanks Ravindra . good work.

      Excellent validation ... Jurgen... 🙂 ... Truly inspiring on how you reach out to each and everything with a best in class solution.

      Author's profile photo Former Member
      Former Member

      Nice Doc.

      Author's profile photo Former Member
      Former Member

      Can we have a document as such of RTP Process.??

      Thanks in advance

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      Hi,

      Thank u for reading my documents.

      I am not posted RTP Process previously. Will post document on RTP process shortly.

      Author's profile photo Former Member
      Former Member

      Thank you RD.

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      Hi,

      As per your request I posted RTP process. Please check and if you getting any doubt please send reply  or any suggestions.

      Author's profile photo Arjun Pawar
      Arjun Pawar

      Good article which explain steps of using SQVI. thanks for sharing 🙂

      Author's profile photo Former Member
      Former Member

      Thanks a lot  Ravindra, for your helpful document.

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      Thanks ...........

      Author's profile photo Ibrahim S
      Ibrahim S

      Good document.

      Regards,

      Ibrahim

      Author's profile photo Bayu Setyawan
      Bayu Setyawan

      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.

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Phanikumar Valiveti
      Phanikumar Valiveti

      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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Phanikumar Valiveti
      Phanikumar Valiveti

      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

      Author's profile photo Darshak Kathiriya
      Darshak Kathiriya

      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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Former Member
      Former Member

      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 .

      Author's profile photo Nassar fathy
      Nassar fathy

      Very useful document, keep up the good work. 🙂 🙂

      Author's profile photo Former Member
      Former Member

      Very Nice document,thanks a  lot

      Author's profile photo Vignesh Veerasamy
      Vignesh Veerasamy

      Hi Ravindra,

      Good work...little more clear screen shots with pop up messages will make it perfect.

      Vignesh.V

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      Hi,

      Thank you .... Will try to make clear screen shot

      Author's profile photo B V Yadav
      B V Yadav

      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

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      What are tables used for this report.  Can you explain brefiely.

      Author's profile photo B V Yadav
      B V Yadav

      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

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      which data you are missing .. Whether report was generated..

      Author's profile photo B V Yadav
      B V Yadav

      It is showing only 201 movement type  documents other than this movement type system is not showing any results.

      Regards,

      B V

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      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..

      Author's profile photo D. Arina
      D. Arina

      This really help me a lot! Thank you Ravindra.

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Poornima Santhosh
      Poornima Santhosh

      Thank you, this works perfect

      Author's profile photo arti sinha
      arti sinha

      Does this affect if I have changed my PC.

      It is not working for my new PC .

      Please Help me to go through it.

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      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