SQVI – Create quick report

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

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

SQVI - Add table

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

SQVI - Tables

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

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

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.

About these ads

31 thoughts on “SQVI – Create quick report

  1. Ayman

    Thanks a lot for this topic

    are there is any thing related to financial as i wana add material column in sales tax report

    Reply
    1. Kowboy Post author

      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.

      Reply
  2. Sudipto Choudhury

    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.

    Reply
  3. Peter Coburn

    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?

    Reply
  4. Bob Sonntag

    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

    Reply
  5. Grace

    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?

    Reply
  6. Michael

    I would like to know the rules when joining tables in SQVI, sometimes I join two tables and when I run the report information repeats itself, if anyone can help me out I will appreciate it, thanks

    Reply
  7. Suresh

    This is very helpful.
    Based on my past experience, in ABAP Query, I know that you could add your own custom field and have a brief logic to determine/ calculate the value of the custom field.
    Do you know if same is possible with the SQVI? If yes, I would appreciate if you can give quick steps. Thanks

    Regards,

    Suresh

    Reply
  8. IVY

    thank you very much for your information.
    but i also want to know the rule of the table linking.
    hope you can recommend and appreciate.

    Reply
  9. bhupathi

    Good. step by step explanation.
    I wanted to know who are all dont have emaild id in su01.

    but when there is no data maintained for specific user(for eg: email not maintained in su01) and executing out put for username,email: it wont give any output even No record itself for email not maintained user.
    Regards
    Bhupathi

    Reply
  10. Atul Kumar

    Hi,

    To link tables there should be common primary or secondary keys. For example Material No or Customer No.

    Interestingly you can link a Custom T-code to a SQVI Query program.

    Reply
  11. manohar

    can we generate report for user profiles by using sqvi
    please tell me how to pull data for user profiles.

    Reply
  12. Pankaj

    Hi,

    Can anybody tell me..
    How to filter the data, like i have field vbrk-fksto ‘X’.
    i.e cancel data should not come..

    Thnx/Pankaj

    Reply
  13. John Spencer

    Thanks Very Much for this information. We have had SAP for a few years and using SQVI was my first venture into performing a ‘quick query’ using joined tables.

    This post saved me a number of hours–Thanks Again!!

    Reply
  14. Rafa

    Hi all,
    To convert a QuickView to a Query, proceed as follows: SQ01/Choose Change user gruop. Select user group you want./Chose Query -> Convert QuickView.

    Regards.

    Reply
  15. Yeni

    Hi All,
    i have a problem to display data in query.example: i have vendor data, a few vendor have VAT Registration and few vendor have not VAT registration.when i make query on SQVI, data just display few vendor with VAT registration, and vendor have not VAT registration, cannot be displayed. did i do something wrong? please help me to solving.
    thanks in advance…

    Reply
  16. Niranjan

    Hi Friends,
    This posting was awesome. However, i am wondering is there any link from where we can learn how to link the report to a transaction code and give to user with proper authorization. please post such links to saphr.tickets@gmail.com

    Regards,
    Niranjan Ghosh

    Reply
  17. Wenjing Liu

    Create Tcode for the report generated in [SQVI]:
    1. [SQVI] -> menu “QuickView” -> “Additional Functions” -> “Display report name”, e.g. “AQTGSYSTQV000036ZSD_VBAK======”.
    2. [SE93] -> create Tcode -> Start object “Program and selection screen (report transaction)”.

    Reply
  18. Sharad

    Hi,

    We need to get payment transactions per payment method from SAP. If no existing report is available, please help to create query. I have not created a querry till date

    We need the below information, thanks.

    Posting Date
    Paying company
    G/L Account
    Payment method
    Currency
    Amount in doc. Curr
    Vendor
    Company code
    Payment document number

    Thanks
    Sharad

    Reply
  19. tzmazlan

    Hi Expert,

    I need some help in creating SAP Query report using SQVI. The report that I need to create is Who approved the PO, Approve ID and Name, Date PO release/Approved.

    I have try to link table EKKO, EKPO but there is no infor related to Who approved the PO, Approve ID and Name, Date PO release/Approved.

    What is the table that have all the above info.

    Appreciate all the help.

    Thanks.

    Regards,
    Mazlan

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s