regenerate tcode for queries

[Former Member]

Dear all,

We have a query created in the Globla area with a toce assigned to it. Everything is ok, but now we must add a new field, we have changed the infoset, and the query. If I run the query in SQ01 the field is there, but if I run the tcode, the field is not there, which means the tcode has not been updated.

How to regenerate it?

Thanks.

[Shahid]

Select the query in Sq01 >> choose goto more functions >> Generate the Program.

regenrating the program will resolve the issue. try it.

[Former Member]

Hi,

I regenerated the program, but the tcode is not working yet.

[SuhaSaha]

Hello Alberto,

Can you check is SE93 if the tcode is directly attached to the Query or to the report program generated from this query?

BR,

Suhas

[Former Member]

Hi,

The tcode is linked to transaction START_REPORT

REgards.

[Clemenss]

Hi Alberto,

if you don't find a better way: Delete the transaction and re-create it.

Regards

Clemens

[Former Member]

Hi,

Did you generate the infoset?.

Are the parameters for tranasction are like below

D_SREPOVARI-REPORTTYPE = AQ

D_SREPOVARI-REPORT = precisely the first 12 characters - query user group (including trailing spaces), 13-th character is G for global queries

D_SREPOVARI-EXTDREPORT = Query name as shown in SQ01.

Thanks,

Venkatesh.

[Shahid]

i assume there should be one more option like ADJUST in the MORE FUNCTIONS...have u tried it...

it worked for me sometime back...

[kiran_k8]

Everytime you regenerate a query the program name of that query changes.So,you need to tag the newly generated program name of that query to the transaction code.Did you checked the program assigned to the transaction code and the program name of the newly generated query.

Thanks

K.Kiran.