How can we create Query by using SQVI

[Former Member]

Hi Frendz,

I need to generate a report by using SQVI hw can i do that, i want each step wise( I dont know how to do that even begining also), Pl send reply ASAP.

Thanks

Babu Rao

[Former Member · Accepted solution]

hi babu rao,

pl check this link where you can see working with SQVI along with screen shots.

[SQVI|http://www.sapsecurityonline.com/tutorials/r3_sqvi_tutorial.htm]

regards

sadhu kishore

[Lakshmipathi]

Dear Babu rao

Normally, SQVI will be used to join multiple tables. Go to SQVI and do the following:

1) Give some description in "Quickview"

2) Click "Create" button

3) Give some description in "Title"

4) From the tab "Data Source", select "Table Join" and click blue tick

5) Press "Shift + F1"

6) Give the table you wanted and press enter

7) Again Press "Shift + F1"

😎 Again give the table you wanted and press enter

9) Press F3

10) On your left screen you can see those two tables with header "List fields" and "Selection Field"

11) Whatever data you want to give as input, (say for example based on sales organisation, you want some report), select the white box under selection field

12) Whatever data you want as report format, select those fields under List fields

13) Execute the report

thanks

G. Lakshmipathi

[Former Member]

Hi,

In SQVI, give a name to a Query & create --> Select Tables & fields --> .....

Regards,

Rajesh Banka

[former_member184555]

Hi

Please use the following link to access an excellent document on ABAP Query. It explains the process step by step with the help screen shots.

http://www.auditware.co.uk/downloads/SAPQuery_step_thru.pdf

Thanks,

Ravi