Skip to Content

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

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

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