Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to find user group from tcode

Former Member
0 Kudos

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.

5 REPLIES 5

Former Member
0 Kudos

hi,

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

Regards,

Himanshu

GauthamV
Active Contributor
0 Kudos

Use function module RSAQ_DECODE_REPORT_NAME.

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

USERGROUP - SYSTQV000001

QUERY - SD_RR_03

CLIENT - 401.

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi

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

Former Member
0 Kudos

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.