cancel
Showing results for 
Search instead for 
Did you mean: 

sqvi

Former Member
0 Kudos

hi all guru's

could you explain abt TCODEl SQVI...with steps,

i have tried for that but no data....

could give me some table...for execution

regards

ss

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

HI Supriya,

SQV1 is used to convert a QuickView into a query.

QuickViewer:

The QuickViewer allows you to define reports without having to program yourself. The QuickViewer is especially useful for new users and occasional use.

QuickViewer is a tool for generating reports. SAP Query offers the user a whole range of options for defining reports. SAP Query also supports different kinds of reports such as basic lists, statistics, and ranked lists. QuickViewer, on the other hand, is a tool that allows even relatively inexperienced users to create basic lists.

QuickView definitions are user-dependent. You can transfer a QuickView into SAP Query in order to make reports, for example, accessible to additional users, or to use the other functions available in SAP Query.

The following is a comparison of QuickViews and queries:

QuickViews possess the same functional attributes as queries. However, only basic lists may be defined with QuickViews.

In contrast to queries, no user group assignment is necessary with QuickViews. Each user has his/her own personal list of QuickViews. QuickViews cannot be exchanged between users. QuickViews may, however, be converted to queries and then be made available to other users in a specific user group.

InfoSets are not required for QuickView definition. Whenever you define a QuickView, you can specify its data source explicitly. Tables, database views, table joins, logical databases, and even InfoSets, can all serve as data sources for a QuickView. You can only use additional tables and additional fields if you use an InfoSet as a data source.

The QuickViewer uses various controls. Certain hardware and software requirements must also be fulfilled before you can use the QuickViewer.

To define a QuickView, you select certain 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 the other toolbox functions available in WYSIWYG mode.

Reports created using the QuickViewer may also be passed to external programs (Excel, for example).

Call the QuickViewer using System -> Services -> QuickViewer (or transaction SQVI).

Enter the name of the QuickView. QuickView names can contain a maximum of 14 characters.

Choose Create.

Enter a title for the QuickView and remarks, if you think they are relevant.

If you do not want to base your list on a table, use the possible entries pushbutton in the Data source field to select another data source. You can choose logical databases or InfoSets. In addition, you may also create table joins. For further information, see Selecting a Data Source.

Choose Basis mode if you want to create the list directly with no list design. Choose Layout mode if you want to define the layout of your list yourself.

Reward points if it helpful

Regards

Govind.

former_member188826
Active Contributor
0 Kudos

SQVI is a quickviewr transaction.

You can read records in a table (or a table join)

Simple example>goto SQvi > Give a name plantmat (to represent plant material data)

Give a description

Leave the datasource as 'table'

enter MARC under the table name and click okay

you will find list field select tab first. Here from the right panel choose material, plant, profit center and special procurement type and push them to the left empty box.

Repeat the same in selection field.

Save and execute. Enter a plant and execute, you will see all the materials for that plant and their profit center and special procurement type.

Former Member
0 Kudos

Hi sridhar

if i wnt to use joint table

please give me some table names

regards

ss

Former Member
0 Kudos

hi,

SQVI Table Quickviewer – Used to create quick client dependent reports

QucikViewer (SQVI)

QuickViewer (SQVI) is a tool for generating reports. SAP Query offers the user a whole range of options for defining reports. SAP Query also supports different kinds of reports such as basic lists, statistics, and ranked lists. QuickViewer (SQVI), on the other hand, is a tool that allows even relatively inexperienced users to create basic lists.

For more info on creating follow these links...

http://www.sapsecurityonline.com/tutorials/r3_sqvi_tutorial.htm

http://help.sap.com/saphelp_nw04/helpdata/en/d1/44f2b5c7f411d296080000e82de14a/content.htm

Also Refer this below thread

Cheers

Alfred

Reward with points for helpful answers

Former Member
0 Kudos

Hi,

Send ur mail id, i will send the documentation

all the best

Prasad

former_member188826
Active Contributor
0 Kudos

Suppose you need for a material in a plant, the material type (MTART) and material group (MATKL) besides the above you information you got from MARC.

You can join MARC with MARA. Set the data source while creating the query to Table join. Give MARC first against the table. Then go to table join area and enter MARA second. Play around to link both these tables, there are enough icons to help you there. There you will have to provide link condition. You shall link both tables based on the common field MATNR.

When you come back to the original screen, you will find both the tables field.Pick whatever you need in both selection tab (based on what fields your selection is going to be) and the list tab (what you need to see in the output).