Community
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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SQVI Query

Former Member

‎2010 Mar 24 11:17 AM

0 Likes
1,149

Hi,

I need some help to create a Query through SQVI for displaying the output conditions per vendor.

The output format should be as given below:

Output Type, Doc Type, POrg, Vendor, Created By, Created on, Partner function, Medium, TIme, Language

Regards,

Komal

Hi,

I need some help to create a Query through SQVI for displaying the output conditions per vendor.

The output format should be as given below:

Output Type, Doc Type, POrg, Vendor, Created By, Created on, Partner function, Medium, TIme, Language

Regards,

Komal

Reply
1 REPLY 1
Read only

former_member778253
Active Participant

‎2010 Mar 31 11:49 AM

0 Likes
645

1) Go to transaction SQVI: In the section u2018Quickviews for u2026u2019 you may see some prepared reports already. Since you are new to this it is likely to be empty. Since we are going to create a new report enter a name for the report in the Quickview name field and press < Create>.

2) In the selection window enter descriptions and choose u2018Table joinu2019 as u2018Data sourceu2019. This means we are going to connect and use multiple tables. Press <Enter> to continue.

3) In the screen u2018Choose data sourceu2019 press the u2018Insert tableu2019 button. In the window that pops up enter the name of the table that you need.

4) Repeat the previous step for all required tables. Your screen will now look like below:

5) Press u2018F3u2032 to go to the configuration screen. In the left side of the screen you can select per table which fields are for selection and/or list purpose. E.g. if you only select a field as u2018List fieldu2019 it will show up in the report results, but will not appear in the selection screen of the report as a filter criterium.

6) Now itu2019s time to test drive your report! Press <Execute>. It takes a short time for SAP to build te report. You are taken to the selection screen of the report. Now it is important that you have an idea of what data you are going to find. Enter filter criteria based on this idea. I mention this because you need to validate the data you will be presented in the report. Do not just accept the quantities. Analyze the results and if the numbers are off find out why and adjust your reportu2019s filter criteria and/or add extra filters to remove redundant data.

7) If you are satisfied with the quality of the report save it for future use. It is possible to link it to a transaction code and make it accesible for users through authorization.

Hope it helps...