topic Re: Update All User queries in Application Development and Automation Discussions

Update All User queries

former_member2492 — Fri, 20 Sep 2019 08:39:42 GMT

Hello,

I am trying to update all queries of a user programmatically.

I am trying to change the username of the user,in all his queries.Most of the queries in are saved in the client-specific area and not in the global area.

Unfortunately I have not been able to find way.

Please let me know if you have any information.

Thank You

Re: Update All User queries

former_member1716 — Fri, 20 Sep 2019 09:00:51 GMT

Hello,

You have to move the Query to Global Area. For this follow the below steps:

Execute T-Code SQ02

Input the required Infoset

Now reach out to Environment from menu BAR and click on transports.

You will get below screen, Now you have all the possible options with respect to transport for a query.

Re: Update All User queries

former_member2492 — Fri, 20 Sep 2019 09:10:32 GMT

I have requested for a way to do this programatically...

Re: Update All User queries

FredericGirod — Fri, 20 Sep 2019 09:15:41 GMT

So create a Batch Input based on Satish proposal

Re: Update All User queries

former_member2492 — Fri, 20 Sep 2019 09:38:41 GMT

Frederic Girod I have also to catch the errors,how will do that ?

Re: Update All User queries

former_member2492 — Fri, 20 Sep 2019 14:04:46 GMT

do you know any FM that finds all queries that a user has?

Re: Update All User queries

former_member1716 — Fri, 20 Sep 2019 14:12:49 GMT

Check out the below link...

https://answers.sap.com/questions/3804495/how-to-find-out-query-name-if-i-have-program-gener.html

Re: Update All User queries

former_member2492 — Tue, 24 Sep 2019 07:49:31 GMT

I only have the user name ,not the program gender

Re: Update All User queries

former_member2492 — Tue, 24 Sep 2019 14:57:46 GMT

a function module that finds out all queries that belong to a user would be apricciated

Re: Update All User queries

former_member1716 — Tue, 24 Sep 2019 15:26:42 GMT

Try This

RSAQ_DECODE_REPORT_NAME

Re: Update All User queries

former_member2492 — Wed, 25 Sep 2019 09:37:10 GMT

this is for the report however I can not find the author