on 11-13-2008 5:56 PM
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.
Hello,
You can convert SQVI query to a regular Query. In SQ01, menu Query->Convert Quickview.
Thanks,
Venu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.