• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

SQVI – Quickviewer in SAP-Security

Like the Data Browser (SE16) reviewed in the last article, Quickviewer (transaction SQVI) is very useful tool for quick and dirty reporting through Ad Hoc Queries. The advantage of using Quickviewer is it 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.

Capture.1454

Inclined to build a profession as SAP Security Developer? Then here is the blog post on
 SAP Security Training Course.

SQVI – Initial Screen

Capture.1455

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.

Capture.1456

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.

Capture.1458

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”.

Check out the top SAP Security Interview Questions now!

Capture.1459

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.

Capture.1460

For Indepth knowledge on SAP Security click on:
Summary
Review Date
Reviewed Item
Quickviewer in SAP-Security
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on SQVI – Quickviewer in SAP-Security"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.