Skip to Content

how SQ01 query report to let user to use

I try to create a ALV report by SQ01, after creating the report. How to let a group of user to run it. It seems not make sense to let user to go SQ01 to run the report.

Is it required to convert the SQ01 ALV report to ABAP program.

Or it can convert into a new T-code for that report?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 04, 2016 at 06:36 PM

    Queries have report names, for example:

    AQZZQDEMO=======DEMO==========

    You can display the report name from SQ01->Query->More Functions->Display report name.

    You can assign a program to a Z* tcode.

    If you are not going to use SQ01 and groups, make sure to add additional authorization checks in the infoset, if needed.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 05, 2016 at 05:10 AM

    Hi Jason,

    There shouldn't be any issue with the users running queries using SQ01. You should be able to assign the users to your query user group using code SQ03. Once you are in that screen, you can even restrict the users from making changes/deleting the query as well.

    -Nikhil Tella

    Add comment
    10|10000 characters needed characters exceeded

    • In general, you are right, and yet, in most companies, where I have worked in, business users do not get SQ01 in a production environment, this is mainly granted to support consultants and master data experts. In exceptional cases key users get such authorizations temporarily in a QA system before go-live, so that they can validate easily if what was requested as master data upload via templates, corresponds to what they expect to get in PRD a few months later.

      Why?

      Well, I cannot say if these are all the reasons, but as a start:

      • many business users find SQ01 a bit too complicated, if they are assigned to more than one user group (which is quite possible in smaller subsidiaries of big companies, where you get to wear many hats, but in bigger subsidiaries there are different persons doing this). Creating separate user groups in such cases is tedious.
      • it seems harder to report on dangerous combinations in external tools and maintain user assignments in companies, where users change job positions or temporarily assume additional responsibilities.
  • Nov 07, 2016 at 08:36 AM

    You can create a transaction to execute a Query, Read some notes like good old 393160 - SAP Query: Using queries or more recent 2185998 - How to create transaction code for a query.(*) or use search tool, as this is a FAQ.

    Regards,
    Raymond

    (*) Create a parameter transaction for report SAP_QUERY_CALL.

    Add comment
    10|10000 characters needed characters exceeded