topic Program Name starting with AQ in Application Development and Automation Discussions

Program Name starting with AQ

Former Member — Wed, 20 Jun 2012 13:54:42 GMT

Hi Freinds,

I have a silly question.

This client that I am working with has a custom program but the program name start with A. Do you know how did they create this custom code without Z or Y at the beginning? Is it possible to "generate" program name out of custom code?

Program name : AQFKALL1========ZGET_MONUM

Appreciate your hints

Thanks

Nash

Re: Program Name starting with AQ

RaymondGiuseppi — Wed, 20 Jun 2012 13:59:22 GMT

This is a query generated program, transaction SQ01. Use FM RSAQ_DECODE_REPORT_NAME to identify user group, query workspace and query name.

Try to call transaction START_REPORT with following parameters

Regards,

Raymond

Re: Program Name starting with AQ

Former Member — Wed, 20 Jun 2012 14:15:04 GMT

Thank you Raymond for the quick response. Problem we are facing is above mentioned program 'does not exist' in our system after a service pack upgrade.We have be using that program for few years now.Do you think query generated program will be deleted during upgrade?

Thanks

nash

Re: Program Name starting with AQ

laurent_fournier2 — Wed, 20 Jun 2012 14:19:57 GMT

Hi,

Try to regenerate the query from SQ01. ( SQ01 --> Query --> More Functions --> Generate Program )

This will probably re-create the program.

Regards.

Re: Program Name starting with AQ

RaymondGiuseppi — Wed, 20 Jun 2012 14:25:05 GMT

Regenerate the program via SQ01 or execute it via SQ01 or START_REPORT (both options should regenerate the report)

Also change the transaction definition if it call the report, and replace it with a transaction with parameters which call START_REPORT, so problem will no longer arise.

Regards,

Raymond

Re: Program Name starting with AQ

Former Member — Wed, 20 Jun 2012 14:52:29 GMT

Thanks Raymond and Laurent. I will follow your leads and get back to you with what I find. Will award full points soon...

Re: Program Name starting with AQ

RaymondGiuseppi — Wed, 20 Jun 2012 14:53:01 GMT

You can also find interest in reading Note 393160 - SAP Query: Using queries.

Regards,

Raymond

Re: Program Name starting with AQ

laurent_fournier2 — Wed, 20 Jun 2012 14:57:21 GMT

Most probably , all your queries must be regenerated after an upgrade. It's is probably better to create a simple abap program to do this since if you have many queries it will be difficult to generate them one by one. Collect the queries from tables AQLQCAT( Standard area ) and AQGQCAT ( Generic Area ) and use RSAQ_CREATE_QUERY_REPORT to regenerate.

Regards.

Re: Program Name starting with AQ

Former Member — Thu, 21 Jun 2012 13:44:16 GMT

Thank you guys I followed your lead and the issue is now resolved. @Laurent that is a great suggestion to have a simple program to handle this.