Skip to Content
avatar image
Former Member

How to change user group of a query (sq01)

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 12, 2007 at 08:25 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 12, 2007 at 08:26 AM

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

    A.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

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

      thanks for the interest

  • Nov 12, 2007 at 08:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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