Many times, as developers, we face the challenge of finding the right data. Typically, we delve into our code and attempt to retrieve the data from tables. Alternatively, we might write small test programs to fetch and display the data in reports. However, SQVI (Quick Viewer) for ABAP Developers offers a more efficient solution, allowing us to quickly create and view data without extensive coding.
There is SAP exchange SQVI (Speedy Watcher) which we can use to bring information. It has simplified office to join tables and select the fields for yield show. It likewise has element to create a choice screen.
And the best part? SQVI (Quick Viewer) for ABAP Developers requires NO coding. It takes barely 5 minutes to join tables and prepare a report, making it an excellent tool for finding the right set of data for testing quickly and efficiently.
Steps:
1. Go to T-Code SQVI. Give a name and press Make button.
2. Give the title and select Information source as Table join starting from the drop rundown and proceed.
3. You will go to Pick Information Source screen.
4. Click the Supplement button . Second from the left at top to embed tables.
5. Enter the tables for which you need information. For this situation, I have entered information expected for List advancements.
6. Continue
7. Enter one more table for which you need to channel or need information from.
For this show I’m utilizing VBAK table.
8. The framework naturally maps the two table with normal fields. (Join for engineers)
9. Here I am utilizing another table to channel information.
The subsequent table (VBAK) and third table (VBUP) is consequently planned with VEBLN field. (You can likewise interface Table 1 and Table 3. Just put the cursor at the field of Table 1 and drag it to the comparing field of Table 3. (It is very much like planning in code). You can connect as the need might arise. Furthermore, it need not be successive. You can interface first table with the third, seventh .. nth table. Simply simplified.
10. Table join is finished. Press back button. You will go to the underlying screen.
11. Presently select the fields from the three tables, for which you need to see the report (alv yield fields).
Use button
or
to select fields from right to left as well as the other way around.
12. Presently plan determination screen fields (if you need to involve channel in choice screen). You can execute even without setting up the determination screen. All things considered, the join will give all records.
To get ready determination screen, select Choice fields Tab as displayed underneath and with the assistance of button move the necessary field to left.
13. Our query is complete. Save it.
Testing:
1. Press Execute button to run the inquiry.
2. The choice screen comes. Enter the worth and see the information.
3. Assume I enter client 100065898, then the result is
4. Assume I enter Dismissal status for SD thing EQ Clear and Estimating for thing is deficient EQ Clear and with Client and Deals Association.
Subsequently we see that we can get tables together with the intuitive elements and chase after the information or even produce a report (regardless of determination screen) and that too without a solitary line of coding.
The utilitarian and testing group would be exceptionally acquainted with this SAP Exchange Code. This post is planned for the designers who seldom utilize this exchange (with the goal that they can utilize it or if nothing else, have some familiarity with the presence of this SAP utility exchange).
YOU MAY BE INTERESTED IN
AIF Architecture: Streamlining Workflows
Introduction to SAP Business Workflow and Building a Simple Workflow Application
WhatsApp us