Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SQL QUERRy (how to use the SQVI)

Former Member
0 Likes
1,958

Hi all,

can anyone explain the process and how to use the Tcode SQVI.....

thanks in advance

srinivas...

Hi all,

can anyone explain the process and how to use the Tcode SQVI.....

thanks in advance

srinivas...

6 REPLIES 6
Read only

Former Member
0 Likes
1,597

Hi,

Pls find below an excellent link which tells all about SAP Query.

http://www.scribd.com/doc/2184969/SAP-Queries

Please reward if found helpful.

Read only

0 Likes
1,597

could you please explain anyone of you for this SQVI.....

Read only

Former Member
0 Likes
1,597

Hi,

Srinivas,

Hi,

The Quick Viewer ( SQVI ) can be used to generate simple report without any programming.

You select data source(table,view,logical dabases, infoset from sap query) and then fields according to that 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.

SQVI is a sap query. but it is used to develop a report without any coding.

Steps to execute QuickViewer :

1. Enter a viwer name name and Create it.

2. Choose a title and remarks.

3. Enter the name of a Data Source .

4. Use layout mode to layout your Quick View graphically.

Note: Only transparent table are allow to be use in SQVI.

If useful, reward points.

Thank you,

Prasad G.V.K

Read only

0 Likes
1,597

Hi

I would like to add some more points in this case. If a report got created through SQVI Transaction it will not allows you to transport .

Its a user specific report.

Thanks and Regards,

Arun Joseph

Read only

Former Member
0 Likes
1,597

thanks for imm responce....

as per ur mail ...

If a report got created through SQVI Transaction it will not allows you to transport..

the same senario will effect to the Tcodes SQ01,SQ02,SQ03.....

could you please look into below my question also..can any one please responce to this,,,,

The below link will explain to genereate the normal or ALV report using ABAP query without any programming language.i have few questions......

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

1.here in this link pdf doc explained how to get the data in two tables usuing ABAP quesry,,,

is it possible for getting the data from more than two tables and how ,canone please guide me....

2.using ABAP query i got the ALV single grid report ,is it possible to get more than single grid usuingABAP query ....?

3.using ABAP query i got the ALV single grid report then how to give the print and how copy and paste in the edit pad....

note : the above PDF link step by step is helpfull for generating report using Tcodes like SQ01,SQ02,SQ03.

can anyone provide the similar type pdf documents for generating report using Tcode SQVI...?

thanks in advance

Srinivas...........

Read only

Former Member
0 Likes
1,597

give me your id will send you docs