SQVI

[kiran_k8]

Hi Folks,

1.Are the queries in SQVI client dependent?

2.Can anyone here please provide me a detailed explanation of using SQVI.

Thanks,

K.Kiran.

[seshatalpasai_madala]

Hi,

Search in help.sap.com for SQVI.

Check

http://help.sap.com/saphelp_47x200/helpdata/en/b7/26dde8b1f311d295f40000e82de14a/frameset.htm.

Regards,

Sesh

[Former Member]

Hi,

No query is not client depenent. Sqvi si query viewer basically use to make any simple report with abap coding. First u make relation of tables decide which fields use in it and create selection query and make outpur format according to your need.

REwards points it is useful

[Former Member]

Hi Kiran

SQVI Table Quickviewer – Used to created quick client dependent reports

Probably the easiest and most flexible way to do this is thru one of the abap query transactions.

Transaction SQVI can do this and it has a very good help function that explains how it works... the drawback is that it is only for one user.

You can play around with it and see if it meets your needs...

The query results will come back in an ALV Grid or Excel... you can select what fields are returned, and have a selection screen to enter the search criteria.

To allow any user to run a query, then you can create an Infoset with transaction SQ02 (you define what fields the user will get in their results, and what fields will appear on the selection screen), then create a multi user query using transaction SQ01 and the infoset you creataed in SQ02. One of the basis people can then create a transaction from your sq01 query, and that transction can then be moved into production.

SQVI and SQ02/SQ01 are far more powerful than SE16 as they allow you to do table joins. SQ02 also allows you to create computed fields.

Got the above info from a link

Also see this

http://supplychain.ittoolbox.com/groups/groups.asp?v=sap-r3-log-mm&i=783523

ABAP Quick Viewer

In SAP 4.6x, you can used a simplified ABAP query. The Quick Viewer ( SQVI ) can be used to generate simple report without any programming.

You select fields according to your data source that determine the structure of your report. The report can be executed in basis mode with standard layout or may be edited using drag and drop and other toolbox functions available in WYSIWYG mode.

However, only transparent table are allow to be use in SQVI.

e.g. Your cannot use BSEG as it is a cluster table, instead use BSIS.

BKPF - Accounting Document Header

BSIS - Accounting: Secondary Index for G/L Accounts

reward points to all helpful answers

kiran.M