topic Re: Query in Application Development and Automation Discussions

Query

Former Member — Tue, 10 Mar 2009 14:19:35 GMT

I have a transaction code which calls a query, the problem is that the query do not exist anymore, I think I have to generate it as we had a release change in the system. When I go to transaction se93 and enter the transaction code I can see the program name of the query which is really long, how can I look at the query with this long name?

Re: Query

amit_khare — Tue, 10 Mar 2009 14:38:05 GMT

Try FM RSAQ_DECODE_REPORT_NAME

~thanks to Eric

Re: Query

Former Member — Tue, 10 Mar 2009 14:40:33 GMT

hi,

Pls elebrote ur question, its not clear.

Thanks

Suraj

Re: Query

Former Member — Tue, 10 Mar 2009 14:44:35 GMT

Hello Amit,

after running the mentioned function I get the name of the query, but when I enter the name of the query in sq01 it says, that the query doesn't exist, how shall I go on?

Re: Query

former_member156446 — Tue, 10 Mar 2009 14:48:40 GMT

check if you are in the correct user group

Re: Query

Former Member — Tue, 10 Mar 2009 14:50:51 GMT

the problem is that the user group which is mentioned in the function is not available in sq01.

my user group begins with SYSTQV and this is not listed in the f4 help when I click on change user group.

Re: Query

former_member156446 — Tue, 10 Mar 2009 14:53:37 GMT

AQZZZSDN_UGRP===ZSDN_QUERY====

There is a specific naming convention to this program.

It starts with AQZZ, continued by user group name, from seventeenth character Query Name starts and rest of the spaces are filled with u2018=u2019 (equals).

Re: Query

Former Member — Tue, 10 Mar 2009 14:58:45 GMT

almost all user groups listed in f4 help started with /SAPQUERY/ and then it goes from a to Z after the slash,

so where is my user group?