cancel
Showing results for 
Search instead for 
Did you mean: 

How to have a SQVI query to be available to Users

Former Member
0 Kudos

Hi all,

What Are all the steps in having a query created in SQVI be available for users to run?

Do I have to recreate this query on SQ01?

What are all the necessary step? Do I need to have a ABAP create a Z Transaction fro this?

What do I need to setup as far as Query Area, InfoSet, User Group....etc.?

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

You can convert SQVI query to a regular Query. In SQ01, menu Query->Convert Quickview.

Thanks,

Venu

Answers (3)

Answers (3)

Rihards
Explorer
0 Kudos

I found another work-around. If you open SE38 after SQVI creation report name will be presented there.

So you can just share the report name with others.

Others will be able to execute it and use your SQVI query.

su01
Participant
0 Kudos

Hi all,

please consider the implications. If that Quick(!) Report ist really a one time thing it might be ok to share the report name.

If this Query is meant to be repeated and used by many -> How shall maintenance over time be done?

Please don't do SQVI only.

If you prefer SQVI over SQ01/SQ02/SQ03 ok - but please when publishing it, publish it as intended by SAP by converting it and assigning it to user groups (also for authorization) as described above by Jürgen Lins (Nov 25, 2008 at 07:59 AM).

A quick view will be maintainable only from within the context of the user who created it. If that user is not in the system anymore or left the company or is on vacation.... no one could easily change it. It's a pain. Really.

JL23
Active Contributor
0 Kudos

there is no need to create extra qeuries with SQ01.

All user can access other users SQVI's.

It is possible from SQ02. You have to change the workarea.

I can give you the full details tomorrow, if you want

JL23
Active Contributor
0 Kudos

How to find and execute or work with other users quickviews (or quickviews created with old user-id)?

Preparation:

Execute SQ02

Choose from menu Settings > Settings to get this Pop-up

Activate u201CDisplay system objectsu201D, and then press Enter to adopt the changes.

Make sure that your work area is set to u201CStandard areau201D in menu Environment > Query areas:

Operation:

Execute transaction SQ01

Klick Change Usergroup

Each User has its own user group for Quickviews.

The name starts with SYSTQV followed by a sequential number.

Choose a desired User group.

All Quickviews of this usergroup are listed and can be executed from here.

Former Member
0 Kudos

Hii Jurgen ,

     Detailed Explanation.

Regards,

Murari Shah

Former Member
0 Kudos

Hi,

The steps u need to follow are as below:

1. SQ03 - Create User groups who would use this query (For ex: MM, PP, SD etc)

2. SQ02 - Create Infoset (Joining of tables -- same as u have done in SQVI). In this step assign the infoset to user group. This limits the authorization for using this Infoset or creating a query for this Infoset.

3. SQ01- Create Query against the created Infoset. Select the input & output fields. The Queries can be created only for the User groups to which the Infoset is assigned.

User can go to SQ01 & run the query as per his User group.

Thanks,

Sourabh

Former Member
0 Kudos

Thanks for the Info.

What about creating a TCode for a set selection screen?

What do i need to do and give to Basis in order to get this done?