Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Query in EHP6

Former Member
0 Kudos

Hi All ,

Recently we upgraded our system into EHP6.Since then some SAP queries are not working , throwing runtime error .

Can somebody guide me what to do to make those queries run?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

I have faced a similar issue and managed to solve the problem by following the steps below:

1. use SE93 to get the generated program name ('AQ...');

2. use SE37 to run FM 'RSAQ_DECODE_REPORT_NAME' to get USERGROUP and QUERY using the program name from step 1;

3. use SE38 to run program 'SAP_QUERY_CALL' with user group and query from step 2.

For more information please refer to Note 393160 - SAP Query: Using queries

2 REPLIES 2

raymond_giuseppi
Active Contributor
0 Kudos

Did you try to execute  the queries in SQ01 or only in transaction with generated program name.?

In the second case, consider converting the transactions :

Create a transaction with parameters, call START_REPORT transaction and pass the information to execute a query with followinng parameters

D_SREPOVARI-REPORTTYPE = 'AQ'

D_SREPOVARI-REPORT = user group (add a trailing 'G' for global area)

D_SREPOVARI-EXTDREPORT = query name

Calling those transactions should recreate the queries.  (Once during first execution.)

If you don't want to clean your system, you may be required to force the system to generate those program "old fashionned" - check Note 723577 - SAP Query: Release upgrade and new generation.

For oldest versions there are also programs that may correct some problems whose names start with RSAQ_REPAIR. (and good old RSAQUM40.)

Also you could read Note 550764 - FAQ SAP Query which contains much information and links.

Regards,

Raymond

Former Member
0 Kudos

I have faced a similar issue and managed to solve the problem by following the steps below:

1. use SE93 to get the generated program name ('AQ...');

2. use SE37 to run FM 'RSAQ_DECODE_REPORT_NAME' to get USERGROUP and QUERY using the program name from step 1;

3. use SE38 to run program 'SAP_QUERY_CALL' with user group and query from step 2.

For more information please refer to Note 393160 - SAP Query: Using queries