How to change user group of a query (sq01)

[Former Member]

Hi,

I'm working with SAP Queries (SQ01) and I don't know how can I change the user group assignation of a query. We did only one user group for all users and queries and know in order to arrange it a bit we've created three user groups.

We know how to assign users to new user groups but for each query of the old group we neet to move it to one of the new user groups, how could we do this?

thanks in advance

[Former Member]

Hi

pls go through these links

http://help.sap.com/saphelp_46c/helpdata/en/35/26b413afab52b9e10000009b38f974/content.htm

Step-by-step guide for creating ABAP query

http://www.sappoint.com/abap/ab4query.pdf

ABAP query is mostly used by functional consultants.

SAP Query

Purpose

The SAP Query application is used to create lists not already contained in the SAP standard system. It has been designed for users with little or no knowledge of the SAP programming language ABAP. SAP Query offers users a broad range of ways to define reporting programs and create different types of reports such as basic lists, statistics, and ranked lists.

Features

SAP Query's range of functions corresponds to the classical reporting functions available in the system. Requirements in this area such as list, statistic, or ranked list creation can be met using queries.

All the data required by users for their lists can be selected from any SAP table created by the customer.

for more information please go thru this url:

http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Create_The_Query.asp

http://goldenink.com/abap/sap_query.html

Please check this PDF document (starting page 352) perhaps it will help u.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCSRVQUE/BCSRVQUE.pdf

check the below link will be helpful for u

once you create query system generates a report starting with AQZZ/SAPQUERY/ABAGENCY2======= assing this report to tr code for the same

[andreas_mann3]

you can assign info set to user group - use tcode SQ02

A.

[Former Member]

thanks Andreas, but I need to change a query from one user group to another not the infoset

thanks for the interest

[raymond_giuseppi]

When you start SQ01 and copy a query (Menu : select line, icon copy) in the popup screen youi can change old and new name of query and old group of users, the new group is the current one.

So connect to one the new groups (Edit, other user group) and simulate a copy on one of their group (Menu : query, copy) there change the from query/group to the query to duplicate.

Regards

[Former Member]

Thank you for your answer Raymond, I've also seen that when you copy the entire user group there is an option to copy the queries assigned too. But this is pretty thorny because then you need to remove the users and the queries you don't want to stay in this group.

So I decided to ask the group for an easier way to make the copy of queries between user groups. Is Raymond solution the best way?

thanks again