In an earlier post I promised to give a quickguide to creating a query in SAP based in transaction SQVI. I’m going to show you how you can quickly build a custom report for reporting Sales Schedule Lines based on different filter criteria and multiple tables (VBAK, VBAP and VBEP: header, item and schedule line data resp.):
1) Go to transaction SQVI: In the section ‘Quickviews for …’ 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>.
SQVI - Main screen
2) In the selection window enter descriptions and choose ‘Table join’ as ‘Data source’. This means we are going to connect and use multiple tables. Press <Enter> to continue.
3) In the screen ‘Choose data source’ press the ‘Insert table’ button. In the window that pops up enter the name of the table that you need.
SQVI - Add table
4) Repeat the previous step for all required tables. Your screen will now look like below:
SQVI - Tables
5) Press ‘F3′ 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 ‘List field’ it will show up in the report results, but will not appear in the selection screen of the report as a filter criterium. For the header I choose: document number, doc date, sales organization, distribution channel and sold-to party (all list and selection). On item level I select: Material Number and Reason for rejection (to be able to exclude rejected lines). Both List and Selection. For Schedule I pick: Item, Schedule Line, Schedule line category, Schedule line date and Confirmed qty. Only Schedule line category and date both List and Selection. The others only List. Now your screen will look like below.
SQVI - Fields selected
6) Now it’s 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 report’s filter criteria and/or add extra filters to remove redundant data.
SQVI - Report
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. I will post a guide on this in the future.
If you like this post, you may also like:
Thanks a lot for this topic
are there is any thing related to financial as i wana add material column in sales tax report
It is a matter of knowing what tables to use. I cannot tell you based on the information you give me whether you can link through to tables that contain material data.
This topic has proved very helpful to me…Reports and graphs can be created in no time…I also added a ‘Z’ transaction code to the report for the users to access it directly. its simply awesome…
Thnx to the genius.
The way of presentation is very simple & helpful. thx for posting
My organization is refusing to provide production access to SQVI on the grounds that it could take down porduciton system if a “wide Open” query was created with this tool.
Is there any merit to these claims of danger?
VERY COOL!! VERY HELPFUL!!
Just used your documentation to create a list of user names and e-mail addresses of those users with a given role.
Bob
nice and simple way to present a complex topic
Than’x
i tried your method but at configuration screen, the available fields for selection shows the the name of the quickview & not the fields from the table. did i miss a step?
When are you posting how to link the reports to a transaction?