query through SQVI

[Former Member]

Hi all,

I was trying to create a query through transaction Code SQVI

I choose as a data source join table and basic mode

Then I selected the table to joined and insert the propper field. After I clicked excute button, I see a print screen when I have a Layout field from where I can choose some possible entry.

My question is related to that because I can't understand what it is for and how I can proceede.

please let me know

Thanks

[Former Member]

Hi CMM,

In SQVI after adding these required fields you need to get some out by giving some input.

For .Ex: i am adding sales order tables for getting all information abt certain orders with in time period.( VBAK-VBAP-VBEP).

In this scenario you need to join these 3 tables as you said. After completing this activity you need to come back you need to select certain check boxes i.e what should be the input and what should be the output. In SQVI Input is Selection Field and output is ListFields.

In my example in VBAK i selected VBAK - ERDAT, ERNAM, AUART as a Selection Fields i.e. Input and VBAP - POSNR,MATNR & VBEP - EDATU,WMENG,BMENG,VRKME is List Fields i.e. Output.

Then save the query and execute the query .

After giving the input execute the button you will get some data where it gives all your required information in default layout format. If you want to get this report as per your requirement then please choose the layout icon and do the changes as u required and save it in your system as user specific or Default Setting.

The SQVI is useful becasue instead of creating 'Y' report you can create query in SQVI when u save this query automatically one program will generate in back ground that program u can assign it to 1 customized t.Code and provide it to all users as report .

If you ahve any query plz revert back...

Regards,

Durga Sana

[Former Member]

IN SQVI cHnage mode

Click on Basis Mode button(f9)

here you can see the tabs

list fld selection etc..

if you want to join other tables click in Data source and Change join button here you can join the new tables

Likes points ..

[Former Member]

Expand the tables in the 'Data fields' section on the left hand of the screen.

Select the checkboxes against fields within each table to use fields to list (display results in your query) or select (search on).

Alternately you can use the "list fld. select" and "selection fields" tabs in the main part of the screen to do the same thing.

James