Tag: Query

SQVI: quick viewer

SQVI is a tool to quickly build ad-hoc queries.

Start transaction SQVI:

Enter a QuikView name and press create. Now choose the type (in this case we will make a table join):

First add the table:

And add the second table:

The join between the tables is in this simple cases created automatically. In more complex cases you have to define the join conditions yourself.

Press the back button to go back.

Now enter the output fields:

And the selection fields:

Save the SQVI query.

Now you can start to Execute the query:

Enter the input criteria and press execute to get the wanted results:

Bug fix OSS notes

Bug fix OSS notes for SQVI:

Table AQLDB clean up

Table AQLDB is used for storing data of SAP Queries created via SQ01 queries. Cleaning this up can be tricky job.

Deletion of old query data

Deletion of old SAP query data is performed via program RSAQQLRE_MASS:

Background OSS note: 2336268 – SQ01: Reorganization of saved lists.

In case of inconsistencies, install program Z_INCONSISTENT_SAVED_LISTS from OSS note 2173291 – Saved List cannot be deleted by program RSAQQLRE.

Clean up of generated programs

Program RSAQDEL0 can be used to clean up generated query program data:

System queries, generated programs and obsolete programs can be cleaned up.

Background notes:

Exit mobile version