|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
Introduction to Quickviewer (SQVI)
By Shelly Malik, HFCL Connect
There might come a time that
you want the information and it is spread in multiple tables. You can write a
SQVI and get this info. In this tutorial we will write an SQVI to find out role
assigned to users with full name of the users.
Create a SQVI
Put a title and
comments. Make sure that you select Table join from Data source
tables. Insert AGR_USERS and USER_ADDR tables.
correct join. Here we will join BNAME
Hit the back button
Here I will
select Role name and user name from AGR_USERS table and Full name from USER_ADDR,
and also make user name as the selection field. So when I run the query it will
ask me to list the users.
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards