topic Re: Get Query name from program name in Application Development and Automation Discussions

Get Query name from program name

Former Member — Mon, 02 Nov 2009 10:12:12 GMT

Hi ppl,

I have the program name of a query (eg. AQ1010==========11============).

How do I find the query name and user group details ( transaction SQ01) from this program?

Thanks,

David.

SuhaSaha — Mon, 02 Nov 2009 10:21:56 GMT

Hello David,

You can try with RSAQ_DECODE_REPORT_NAME

BR,

Suhas

Former Member — Mon, 02 Nov 2009 10:31:26 GMT

Hi,

For example:

Assigned report: AQA0Ztest=====ZMAT_COST3====

My query name would be : ZMAT_COST3.

Please tell me the complete program name?

Regrds,

Nikhil.

Former Member — Mon, 02 Nov 2009 10:53:51 GMT

Hi,

In the SAP Query, you can determine the user group and query from program name ...

For eg: I have the prog name: AQZZ/GRC/APPL===CO_OM_CA_10_Q1

First 4 chars are system specific and are same for all the queries in the system

Next 12 chars are user group

Last 12 chars are the Query name.

Note if there are less than 12 chars in the query or user group then rest of the chars will be filled up by "="

Hope this helps

Regards

Shiva

Edited by: Shiva Kumar Tirumalasetty on Nov 2, 2009 4:23 PM