Skip to Content

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

You can select basis mode or layout mode  and enter

/wp-content/uploads/2013/07/13_246618.png

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

Click on insert Table (shift+F1)

enter table name , example EKKO and enter

/wp-content/uploads/2013/07/4_321603.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.

We can take n number of tables which should linked to previous entered table.

/wp-content/uploads/2013/07/5_246575.png

Once completed all table linking then click on back button

/wp-content/uploads/2013/07/6_246577.png

/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

Click on enter

/wp-content/uploads/2013/07/12_246617.png

Now execute (F8)

Execute (F8)

/wp-content/uploads/2013/07/13_246618.png

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

To report this post you need to login first.

64 Comments

You must be Logged on to comment or reply to a post.

  1. Devender Kumar

    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

    (0) 
    1. Ravindra Devarapalli 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

      (0) 
        1. Ravindra Devarapalli 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.

          (0) 
    2. 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.

      (0) 
  2. A B

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

    (0) 
  3. 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.

    (0) 
  4. 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.

    (0) 
  5. Subhadra Moharana

    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.

    (0) 
    1. 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

      (0) 
      1. Subhadra Moharana

        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

        (0) 
  6. 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

    (0) 
    1. Jeff G

      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

      (0) 
    2. Barry Andersson

      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 .

      (0) 
  7. 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

    (0) 
      1. 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

        (0) 
          1. 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

            (0) 
            1. Ravindra Devarapalli 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..

              (0) 
  8. Kunwar Verma

    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

    (0) 

Leave a Reply