topic Re: New User ID's - Copy Query Assignment in Application Development and Automation Discussions

New User ID's - Copy Query Assignment

vijayendra_rao — Wed, 30 Oct 2013 08:52:26 GMT

Hello All,

We are in the process of creating new user ID's. I would like to know what steps should I keep in mind so that the new user ID's are properly assigned to the queries.

I have already checked the FM: RSAQ_IMPORT_USERGROUP_CATALOG. But I am not quite sure if I am seeing the right information in there. Under O_DBBN - I only two entries under columns NUM (is this user group?) and BNAME. Does this mean there are only two users in my organization using the queries? (seems unlikely!) Where do I see to which queries these users are assigned? Under O_DBBS - I see 25 entries, it seems to me like these are queries in the current (?) environment. But again, it does not list who are the users.

I would appreciate any help.

Thanks!

Vijay

Re: New User ID's - Copy Query Assignment

mvoros — Wed, 30 Oct 2013 22:45:33 GMT

Hi,

I know that this is not an answer to your questions but my advice would be to stop using queries. Create a transaction for each query and use transaction code to control access. Maintaining query assignment does not scale. When you have many users the effort required will be too big and you will always forget to remove assignments. IdM can't handle query assignment nor HR org. structure can.

Cheers

Re: New User ID's - Copy Query Assignment

vijayendra_rao — Thu, 31 Oct 2013 04:09:25 GMT

Thanks Martin, that is a good tip indeed. Once the new ID's are implemented, I plan to do this! But I still need to find a way to figure out all the users assigned to the queries. Will keep digging.

Vijay

Re: New User ID's - Copy Query Assignment

mvoros — Thu, 31 Oct 2013 20:57:29 GMT

Hi,

just use FM RSAQ_READ_QUERY_CATALOG with default parameters. It will give you queries with corresponding user groups and users.

Cheers

Re: New User ID's - Copy Query Assignment

Former Member — Tue, 05 Nov 2013 16:44:48 GMT

Hi Vijay

This happened with us as well. If we recently changed userid's.

Basically these queries are personalized queries

Open a query which is already created in SQVI

Then Press SAP QUERY Button on Quick viewer. Then it will lead you to SAP QUERY.

Menu bar > Environments> Query Areas--- change to Standard areas from Global

Then

Menu bar >Query convert Quick view--> assign infoset name and user group.

Please assign the users to group(where you assigned queries) using Sq03

Re: New User ID's - Copy Query Assignment

vijayendra_rao — Wed, 06 Nov 2013 01:45:43 GMT

Thanks Martin!

I think I accidentally deleted the email notification of your post. Looks like this is what I need! But I am doing some due diligence to make sure I am getting what I want. Thanks again! Will update soon.

Vijay

Re: New User ID's - Copy Query Assignment

vijayendra_rao — Thu, 07 Nov 2013 05:52:23 GMT

The function module is useful in getting list of standard SAP queries, but I don't think it includes Quick View queries. Thanks Martin.

Re: New User ID's - Copy Query Assignment

vijayendra_rao — Thu, 07 Nov 2013 05:58:34 GMT

Thanks Pavan.

Looks like this is the approach we will have to take as well as there is no standard procedure to copy over Quick Views. The issue I see with this approach is, as per our table extract from AQLTS (by looking into field Text which also stores username:queryname information) we seem to have over 1000 Quick Views. Manually converting each Quick View to SAP Query does not make sense. How did you execute this? Is LSMW possible? I am creating a LSMW script to test it.

Re: New User ID's - Copy Query Assignment

vijayendra_rao — Thu, 07 Nov 2013 08:46:43 GMT

Update:

It is possible to create LSMW script for mass copy. I did have to delete screen field entries under SAPMS38R 0050 from LSMW recording. Also, had to use "Display only errors" processing mode (somehow Background processing kept failing).

However, I still have not found a straight forward way to get a list of all Quick Views maintained by each user (for me it will be a manual exercise), unless there is a function module that gives the result?

Re: New User ID's - Copy Query Assignment

Former Member — Thu, 07 Nov 2013 09:30:44 GMT

Hi Vijay

I never tried LSMW.I have always developed and used Secatt scripts for all the mass changes.

May be you can try , Secatt is easy way. i hope it will fine