Technical Upgrade Query Issue .

[Former Member]

Dear ,

We are updating our system from ECC4.7 to ECC 6.0 .

I come across the issue that Queries are not updated in system .

Some of the queries I have resolved by going in transaction SQ01 simply by acivating it and execute but in some of the

objects query name does not exist in old system but report execute there .

In new system 6.0 this not even executing . What the problem that not able to identified .

For example :

Query is this : AQFKSYSTQV000015ZPODET========

Query name is : ZPODET

This is not exist in both the system but its running fine in old system .

Please suggest any solution for this if u have any .

Rgds Aryan

Edited by: Aryan@sap on Nov 11, 2009 10:59 AM

[Former Member]

HI Aryan,

During the technical upgrade queris will not be trasfered . U need to re create those queris again. U will get Errors in SPAU reagrding the same. Please check the SPAU -- Other objects for the same.

Regards,

Srinivas.

[Former Member]

Hi Srinivas,

Since these are auto generated program, you cannot capture them in SPAU or SPDD.

SPAU/SPDD will only give errors in SAP Standard data dictionary or STD Objects(programs/FM etc..)

Regards

Shiva

[Former Member]

Hi Shiva,

We got the SPAU error for in other objects for all queries which were created In Production Server and assigned to Y TCODE in the Development sever with the Auto generated program..

Srinivas

[Former Member]

Hi,

This is the most common issue faced during the Upgrades.

1) First go to SE37 and execute the FM: RSAQ_GENERATE_PROGRAM by entering the Query name and the User group.

2) You can get the link for SAP Query and User groups from the table AQLQCAT(local areas) and AQGQCAT(global areas)

3) Finally after the query is generated, you will get the program name as output of the FM.

4) Check this program exists in SE38.

If you want to generate more queries try writing a simple report using the above logic....

OR Simply go to SQ01 and try to generate each query from the menu->Query>More Functions->Generate Program

The same process needs to be done in all the systems(old/new/dev/quality/prod systems)

For your help, AQFKSYSTQV000015ZPODET======== the name of query and user group can be determined as:

First 4 char : system specific

Next 12 Char : User Group

Next 12 Char : Query name.

Wherever names are less than 12 chars then the = are added.

Hope this helps

Regards

Shiva

[Former Member]

Dear ,

But the thing is the query doesn't exist in the system .

Where is query gone some of the queries are imported and they are running perfectly fine . I dont know about the rest of the queries why they are not working . Even they are exist in the new R/3 system .

Rgds Aryan

[Former Member]

Hey,

Download the query and infoset from the old system and upload it in the new system.