mobileNavlogo
headerlogo

Blog

SQVI – Quickviewer in SAP-Security

22 September, 2020

Related Blogs

SQVI - Quickviewer In SAP-Security

Like the Data Browser (SE16) reviewed in the last article, Quickviewer (transaction SQVI) is a very useful tool for quick and dirty reporting through Ad Hoc Queries. The advantage of using Quickviewer is its ability to perform table joins enables us to display data from multiple tables.

In the example below, we create a query to return the t codes executable by an individual user. We name the query “Z_USER_TCODE” using table join.

Quickviewer In SAP-Security

SQVI - Initial Screen

SQVI - Initial Screen

SQVI - Query Definition

On clicking the check button, we get to the design window shown below. We insert the three tables which we will be using for our report and add graphically add the join conditions as shown below.

SQVI - Query Definition

SQVI - Join Conditions

Once the data sources and join conditions are set up, we need to check the fields appearing in the selection and list output. We have the option or changing the field order of both the selection and list screens or even the sort order of the resulting data.

SQVI - Join Conditions

SQVI - Selection & List Fields

We now save our query and click the execute button. In the example, we filter the query to return the tcodes for user “test_user”.

SQVI - Selection & List Fields

SQVI - Query Selection Screen

The output returns a list of tcodes that can be executed by the user and also the role which contains the t code.

SQVI - Query Selection Screen

For In-depth knowledge on SAP Security click on:
About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .