topic Re: Looking a QuickView in Application Development and Automation Discussions

Looking a QuickView

Former Member — Fri, 21 Oct 2005 14:32:58 GMT

Hi!

If a user create a QuickView (SQVI) how another user can see it?. Is there a way?

The problem is that a user create a QV but, that username was delete and the new user need that QV.

Thanks in advance!

Carlos

Re: Looking a QuickView

RichHeilman — Fri, 21 Oct 2005 14:35:52 GMT

Have your basis team re-create the delete user. Then maybe you can access it. Hopefully you can copy it to the new user then.

Regards,

Rich Heilman

Re: Looking a QuickView

Former Member — Fri, 21 Oct 2005 14:42:30 GMT

Hi,

Quick Views are stored based on User Groups..

If you know the user group the earlier user belongs to then you can use fm RSAQ_IMPORT_QUERY_CATALOG to get all the quick views created for that user group.

AQLQCAT is the table where these are stored..

F1 Help from SQVI..

SAP Query: Query name / QuickView name

Fourteen-character query name or QuickView name.

You can use any characters for this name, however, only letters, numbers , and the special character '_' are recommended.

Procedure

Enter here the name of the query that you want to create, edit or execute. This query belongs to the user group specified in the field User group . If you display the possible entries, you get a list of all queries for the specified user group.

Dependencies

You can execute and maintain queries only in the user groups to which you have been assigned by your system administrator.

The field Query name contains a default value managed in the SAP memory under the parameter ID AQQ and is always updated if you enter a new name. If you predefine the parameter AQQ with the name of a query in your user master record, this query is always displayed as the default when you call ABAP/4 Query for the first time.

Hope this helps..

Also, function module RSAQ_IMPORT_USERGROUP_CATALOG

will give you user group for users in table parameter DBBN..

Once you get the user group for the deleted user..try adding the new user to the table DBBN and then call fm

RSAQ_EXPORT_USERGROUP_CATALOG.

Then in SQVI, the new user should be able to see queries..

Sri

Message was edited by: Srikanth Pinnamaneni

Re: Looking a QuickView

Former Member — Fri, 21 Oct 2005 14:55:28 GMT

Well, i know which UserGroups has "SD01" (User deleted) and the new user is "MFUNCIONAL", they has different UserGroups but how i can change the MFUNCIONAL'S UserGroups?

Re: Looking a QuickView

Former Member — Fri, 21 Oct 2005 14:58:53 GMT

Hi,

This should do it..

Also, function module RSAQ_IMPORT_USERGROUP_CATALOG

will give you user group for users in table parameter DBBN..

Once you get the user group for the deleted user..try adding the new user to the table DBBN and then call fm

RSAQ_EXPORT_USERGROUP_CATALOG.

Leave workspace as space..

Actually change the user groups for new user in the table DBBN and then call RSAQ_EXPORT_USERGROUP_CATALOG.

Hope this helps..

Sri

Message was edited by: Srikanth Pinnamaneni

Re: Looking a QuickView

Former Member — Fri, 21 Oct 2005 15:05:38 GMT

Table DBBN?. I looking for it in SE11 but is says that doesn't exist.

Ok.. i understand what do you mean with the table DBBN... i'm trying right now...

Message was edited by: Carlos A. Lerzundy

Re: Looking a QuickView

Former Member — Fri, 21 Oct 2005 15:15:27 GMT

Sorry i can't make it work =(

this are the parameters:

DELETED USER: SD01

UG: SYSTQV000003

NEW USER: MFUNCIONAL

SYSTQV000009

What i'm doing wrong?

Please help

Message was edited by: Carlos A. Lerzundy

Re: Looking a QuickView

Former Member — Fri, 21 Oct 2005 19:29:27 GMT

> Well, i know which UserGroups has "SD01" (User

> deleted) and the new user is "MFUNCIONAL", they has

> different UserGroups but how i can change the

> MFUNCIONAL'S UserGroups?

Go to SQ03. Enter user group of SD01. Click "Assign users and infosets". Inside, enter "MFUNCIONAL" and save it. Now the new user is assigned to the user group.

If you go back to SQVI as the new user, you should now be able to see the query.

Re: Looking a QuickView

Former Member — Sat, 22 Oct 2005 08:38:20 GMT

Hi,

Actually it does not work..

Srinivas, in SQ03, all the user groups are not showing up. It seems it is only showing the user created user groups (Z) and not the system ones SYSTQ..

And Carlos,

Modify the new user DBBN record as follows..

DELETED USER: SD01

UG: SYSTQV000003

NEW USER: MFUNCIONAL

SYSTQV000009 to SYSTQV000003

Hope this helps..

Sri

Message was edited by: Srikanth Pinnamaneni

Re: Looking a QuickView

Former Member — Sat, 22 Oct 2005 22:11:06 GMT

You have to change the query areas to global, then you will be able to see them.