Skip to Content

SQVI

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Aug 22, 2007 at 04:57 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 22, 2007 at 04:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 22, 2007 at 05:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded