topic Re: regenerate tcode for queries in Application Development and Automation Discussions

regenerate tcode for queries

Former Member — Mon, 25 Jul 2011 13:12:30 GMT

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.

Re: regenerate tcode for queries

Shahid — Mon, 25 Jul 2011 13:16:56 GMT

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

regenrating the program will resolve the issue. try it.

Re: regenerate tcode for queries

Former Member — Mon, 25 Jul 2011 13:28:41 GMT

Hi,

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

Re: regenerate tcode for queries

Shahid — Mon, 25 Jul 2011 13:39:11 GMT

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

it worked for me sometime back...

Re: regenerate tcode for queries

SuhaSaha — Mon, 25 Jul 2011 14:38:03 GMT

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

Re: regenerate tcode for queries

Former Member — Mon, 25 Jul 2011 15:34:32 GMT

Hi,

The tcode is linked to transaction START_REPORT

REgards.

Re: regenerate tcode for queries

Clemenss — Mon, 25 Jul 2011 19:08:30 GMT

Hi Alberto,

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

Regards

Clemens

Re: regenerate tcode for queries

kiran_k8 — Wed, 27 Jul 2011 05:53:38 GMT

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.

Re: regenerate tcode for queries

Former Member — Wed, 27 Jul 2011 06:54:19 GMT

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.