Program Name starting with AQ

[Former Member]

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

[RaymondGiuseppi]

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

[Former Member]

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

[laurent_fournier2]

Hi,

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

This will probably re-create the program.

Regards.

[RaymondGiuseppi]

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

[Former Member]

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

[RaymondGiuseppi]

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

Regards,

Raymond

[laurent_fournier2]

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.

[Former Member]

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.