ABAP Query Tool

[former_member216425]

Heard that there is an ABAP Query Tool that helps one to generate dynamic queries for reporting purpose. Can anyone give me more info. on this?

Thanks,

Kavitha

[Former Member]

Hi Kavitha,

Dirst of all i want to clarify ur Question.

Do you want to generate queries dynamically means you want to generate your select query dynamiccaly based on some selection screen inputs. And you also want column selection and where conditions in select query builds dynamically. Is it right???

If my guess is right then you can't do dynamic query generation in ABAP query.

I hope it will help.

And reward it if it is helpfull.

I am waiting for your reply..

Bhavik

[Former Member]

Hi,

The term Dynamic Query Generation here is used in the context that the ABAP Query Tool automatically generates SELECT statements based on the JOIN conditions that you specify during data source (DB tables) selection. It is a very handy tool for basic reporting and used mostly by power users/knowledge workers. It allows them to create adhoc reports that fit their needs on a day-to-day basis. If you have worked with Reports in MS Access, ABAP Query is used more or less in the same manner. It also generates a selection screen for the user to restrict their searches. There are multiple ways in which the user can see output, e.g., ALV List, ALV Grid, Simle List, etc.

Try running Quick Viewer (trn. code SQVI) and take a test drive. You will get an idea of how it works.

Hope this helps.

Regards

Message was edited by: Shehryar Khan

[Former Member]

yes i agree with Shehryar Khan. We can generate dynamic query in this context. We need to specify only table for join. and it generates query for you. It also provide selection screen based on join tables.

[Former Member]

Transaction SQ01 is the Query Tool.

Transactoin SQVI is the Quickviewer Tool. It sits on top of the Query Tool to provide a more friendly interface without the administrative overhead that Query requires.

SAP Offers course BC407 on the Query Tools.

[Former Member]

Hi Kavitha,

I found one tool under downloads > Web AS > SQL Tool for ABAP Programmers of SDN. This is a report and you need to create a screen. I could not able to understand and create the screen from screen_0100.txt file. If this is what you want and you know to create the screen, please let me know.

Thank you,

Surya