Quick Viewer

[Former Member]

Hi Guys,

how can i get <b>company code specific data(customer master data) using quick viewer</b>?

as i know we dont get any selection criteria.

it it is not possible can somebody explain how can i extract all customer master data particular to a company code?(not from SE16)

Thanks

anil

Message was edited by:

anil maguluri

[Former Member · Accepted solution]

Hi,first setp for ABAP Query is Create a User group-SQ03

then second step is create infoset-SQ02

then here select direct read from the table ex then select include all table fields.then click on join tab in the nxt screen

then click on insert table then here enter vbap.

then select fields what ever u want from that tables.

then goto SQ01 and execute this query.

save it in local object.

reward points if it helps

thanks&regards

veera.

[Former Member]

Hi Anil,

You can use the Quick Viewer to get the Company Code Data for a Customer.

Follow the steps to generate the report

1) Use the standard menu bar go to Systems -> Service -> Quick Viewer

2) Enter the name of the View and click on Create option

3) Give the title for the report and select the Data Source as Table. Enter the table name KNB1 and use the Layout Mode

5) In the list design view you would find the fields name of table KNB1 and the selection field check box.

6) Using the check box you can get the selection screen for your report.

Hope it had helped. Do reward if you had felt the same.

Regards

Nadarajah Pratheb

[Lakshmipathi]

Hi Anil

Check the link

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

Thanks

G. Lakshmipathi

[former_member227476]

dear anil

SQVI is used to convert a Quick View into a query.

Quick Viewer:

The Quick Viewer allows you to define reports without having to program yourself. The Quick

Viewer is especially useful for new users and occasional use.

Quick Viewer 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. Quick Viewer, on the other hand, is a tool that allows even relatively inexperienced users to create basic lists.

Quick View definitions are user-dependent. You can transfer a Quick View 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 Quick Views and queries:

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

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

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

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

To define a Quick View, 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 Quick Viewer may also be passed to external programs (Excel, for example).

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

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

Choose Create.

Enter a title for the Quick View 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 Info Sets. 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.

SQVI Table Quick viewer – 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 created in SQ02. One of the basis people can then create a transaction from your sq01 query, and that transaction 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

rewards if it helps

siva

[Former Member]

Chk the following Posting on how to create report using ABAP/SAP Query, this does not involve using SE16

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40bec8da-4cd8-2910-27a9-81f5ce10...

Regards

AK

Reward points if helpful