12-07-2010 7:30 AM
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.
12-07-2010 7:45 AM
hi,
Check table AQGQSTRUC- This would give you user group assignment to query.
Regards,
Himanshu
12-07-2010 7:50 AM
Use function module RSAQ_DECODE_REPORT_NAME.
If your program name is AQIDSYSTQV000001SD_RR_03====== then
USERGROUP - SYSTQV000001
QUERY - SD_RR_03
CLIENT - 401.
12-07-2010 8:48 AM
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
12-07-2010 9:17 AM
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
05-10-2011 1:15 PM
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.