Regarding SAP Query

[Former Member]

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

[Former Member]

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.

[SuhaSaha]

> 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

[Former Member]

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

[Former Member]

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

[Former Member]

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)

[SuhaSaha]

> 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