Program ZAAQB - a tool to build complex SQL queries, and view the results of the sample.

similar to se16n, but you can use the JOIN s
similar to the Alv Robot, but it is more convenient, less action on the transfer request in and view the results
similar to Yes4SQL, but more user-friendly interface for query building and fitting it to fit your needs, less text to type with your hands, it is very convenient for beginners are not familiar with the syntax.
similar to SAPQuery, but generates a source program that can be used in the design and be sure that the sample is not empty before entering the debugger.

  SE16 is the best tool for the review of a spreadsheet, you can open several sessions if you have more than 1 table
  You can nelyubit JOINs
  However, if you want the relationship between the data were in the visible form
  There is nothing better than JOIN

program generates a working program that contains a description of all types, variables, and query, as a result of which an internal table, you will receive the data displayed on the screen.


program is fully mobile, it works for anything except unnecessary source program,
no need to create additional screens
no need to further establish the status of PF
no need to create additional entries in the abap dictionary.

CTRL + C, CTRL + V, ENJOY


Work Program

interface contains 5 tables edited:

1) Tables

here perechmslyayutsya table and the angle used in the query box Alias neobyazatelnoe need to Joina table with the 
If the table or the camera angle is not in the dictionary row to this table will disappear.
Double click on the name of the table opens a window to select the fields involved in the query.

2) Select

Here are Select, Select the name of ZMAIN has always been a major inquiry, all the rest can be used in subqueries.

3) Join

here are built Join s for each Select to be filtered when you click the button next to the Select.
Join a field name, type type, left or left-table Join, right right table

4) join condition

conditions joina, to each their own, is filtered by pressing buttons next to the Joina. Left field left field, first select the table,
Right field is selected from the table specified in the right table Joina.

5) Where

lists the fields participate in the request

Conclusion: If the box labeled participate in a sample, or used in the condition, otherwise there simply is.
fields: the table name and fields
alias: alias for the field when the field with identical names are selected from different tables
Aggregation: Aggregation functions min, max, count, average, sum, may be performed only over number fields, is on your responsibility.
Type sort: increasing waning.
Sort: sort.
Criteria for: Groups used in Having, Values used in the Where.
NO_check: if the observed conditions are ignored (to temporarily disable the conditions)
or or or or: conditions for logical connectives, or the correctness of filling conditions is your responsibility, you can use subqueries.

after making changes, press enter, the table is updated on developments in the enter.

Button-up move down the line,
export and import - saves restore request from a text file.
save saves the request in the database * to use the additional functionality necessary to create 2 tables in abap dictionary, if they do not create a message containing the necessary information to create tables.
1 screen displays a list of queries, the selected request will replace the current.
cancellation of the first screen will cause a dialog box requesting a new name for the query.
List the request retrieves from the database * to use the additional functionality necessary to create 2 tables in abap dictionary, if they do not create a message containing the necessary information to create tables.

run query: is a request to the database and displays the query to the database.
show code: generates the source code of the program on the current request.
join wizard: generates a query from the existing text in the table name and the names of fields, you can edit regard to the

program does not contain all the checks on invalid request if you ask her to make an incorrect request, it will try to do it and most likely fall in the dump,
Keep your queries before running (or export in the base), to check conditions in terms of correctness or.

demo use


press HD button

http://www.youtube.com/watch?v=0IxpOmoK3O0
http://www.youtube.com/watch?v=-Na1g7mD4m8