How to create Report by using SQVI
30 Ocak 2017 16:32 tarihinde eklendi.
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 ………

 

Resource => https://blogs.sap.com/2013/07/04/how-to-create-report-by-using-sqvi/


Etiketler : indirim haberi,indirim haberleri, , , , , , ,
Yazar
Selahattin Şahin
Yorumlar

Bu Yazıya 0 Yorum Yapılmış

Henüz yorum yapılmamış

Yorum yapabilmek için giriş yapmalısınız.

Mevzuat Arama Motoru
Sosyal Medya da Benim Grubum !!!
SMMM Selahattin Şahin Sitesinde yayınlanan Eserler ve Programlar, Fikir ve Sanat Eserleri Kanunu ve Türk Ceza Kanunu\\\\\\\\\\'na tabidir.Eser ve Programların kamusal ve anonim olanları dışındakiler sahiplerinin izniyle yayınlanmaktadır. izin alınmak, FSEK\\\\\\\\\\'na uymak ve eser sahibiyle sitenin adı verilmek şartıyla alıntı yapılabilir. Copyright © 2013. Tüm Hakları saklıdır. SMMM Selahattin Şahin Muhasebe-SMMM-Yeni TTK-Yeni Borçlar Kanunu-AGİ-2012-Pratik Bilgiler-SGK-Bağ-Kur-Emekli Sandığı-Beyanname Rehberi-Transfer Fiyatlandırması-Özelgeler-Yönetmelikler-Sirküler-Soru-Cevap-SMMM Staj Rehberi-Ücretsiz SMMM Sınavları-Mali Takvim-Basel II-YMM-Ekonomi-Finans-Maliye-Güncel Bilgi Kaynağı
yukarıya Çık
Sorgu Sayısı: 79 Yüklenme Süresi: 0,3800,380