topic Re: How to find user group from tcode in Application Development and Automation Discussions

How to find user group from tcode

Former Member — Tue, 07 Dec 2010 07:30:45 GMT

Hi Experts,

I have custom tcode from this i found report name as AQIDSYSTQV000001SD_RR_03======

I am unable to find Queryname in SQ01 from this.

When i saw some of the forums i understood that IDSYST is the user group for my query but i am unable to trace such user group in SQ01.

Please guide me how to find user group for my report

Thanks&Regards,

narasimha.

Re: How to find user group from tcode

Former Member — Tue, 07 Dec 2010 07:45:47 GMT

hi,

Check table AQGQSTRUC- This would give you user group assignment to query.

Regards,

Himanshu

Re: How to find user group from tcode

GauthamV — Tue, 07 Dec 2010 07:50:50 GMT

Use function module RSAQ_DECODE_REPORT_NAME.

If your program name is AQIDSYSTQV000001SD_RR_03====== then

USERGROUP - SYSTQV000001

QUERY - SD_RR_03

CLIENT - 401.

Re: How to find user group from tcode

Former Member — Tue, 07 Dec 2010 08:48:03 GMT

Hi ,

I found in table AQGQSTRUC but i didnt find the specified query

Previously 401 client is there but at present it is not there .How can you justify it that it is 401 client.

As 401 client data is moved to someother client is it the problem why i am not able to find query??

Thanks&Regards,

narasimha.

Edited by: narasimha02 on Dec 7, 2010 9:54 AM

Re: How to find user group from tcode

Former Member — Tue, 07 Dec 2010 09:17:22 GMT

Try to chekc if it's a quick query, so a query created by trx SQVI AQIDSYSTQV000001SD_RR_03, if it's so, the name of the query should be SD_RR_03

Max

Re: How to find user group from tcode

Former Member — Tue, 10 May 2011 12:15:13 GMT

Hello All,

I have a similar problem like narasimha though not with same query.

Though I have find out the user group for the query using the standard fm RSAQ_DECODE_REPORT_NAME but I am unable to find that user group in the standard user group of sq01.

Please give your suggestions.