topic Re: Regarding SAP Query in Application Development and Automation Discussions

Regarding SAP Query

Former Member — Wed, 25 Jan 2012 14:13:26 GMT

Hi,

We have a SAP Report tree triggering a SAP Query program. The report program is working fine and we know the Query Name.

But we are not able to find the Query name and User group in SAP anymore. Require help on how this has happened.

Thanks

Re: Regarding SAP Query

Former Member — Wed, 25 Jan 2012 14:25:49 GMT

Once you execute the query and its selection screen shows, go to system status and note the report name behind the query.

If the name of the program is like

AQZZ/SAPQUERY/ABAGENCY1=======

SAPQUERY/AB = User group
AGENCY1 = Query name

A little guessing is needed as the query name and user group name are concatenated in the query report name.

Re: Regarding SAP Query

SuhaSaha — Wed, 25 Jan 2012 15:09:01 GMT


> A little guessing is needed as the query name and user group name are concatenated in the query report name.

If you don't want to guess you can use the FM RSBQ_DECODE_REPORT_NAME to get these details from the Query Report name

Re: Regarding SAP Query

Former Member — Wed, 25 Jan 2012 15:26:22 GMT

Hi,

We know the Query , Infoset and Usergroup.

But the Query, Infoset and Usergroup no longer exist. Where as the Report Generated by the Query exists.

We are wondering how this would have happened. Any guess how this has happened.

Thanks

Re: Regarding SAP Query

Former Member — Wed, 25 Jan 2012 15:29:55 GMT

hi!

go to transaction SQ01 (or SQ00) then use the pulldownmenu "environment" and then change the query area...

save your work, and you will find all the created user groups and queries.

with user parameter AQW you can set the default query area by user name.

have fun

Flo

Re: Regarding SAP Query

Former Member — Wed, 25 Jan 2012 15:38:16 GMT

This may be a moot question but did you check in both Global and Standard query areas?

SQ01 -> Environment -> Query areas

Suhas,

Thanks for the info, but that function doesn't seem to work for the query report name I gave. It is making assumptions as to the position and offset of query and user group name tokens withing the program name string (which in this query's case were wrong)

Re: Regarding SAP Query

SuhaSaha — Thu, 26 Jan 2012 10:17:50 GMT

 
> Suhas,
> 
> Thanks for the info, but that function doesn't seem to work for the query report name I gave. It is making assumptions as to the position and offset of query and user group name tokens withing the program name string (which in this query's case were wrong)

My bad! RSBQ_DECODE_REPORT_NAME is for decoding report names for older releases(< 4.0). The FM for later releases is RSAQ_DECODE_REPORT_NAME.

Thanks for pointing it out.

BR,

Suhas