topic Re: Query in Application Development and Automation Discussions

Query

former_member253223 — Mon, 03 Dec 2007 08:24:14 GMT

Hi Team,

Can we change/modify auto generated Query Program code.

Actually,Requirement is to add a additional field to the existing program which is a copy of query generated program.

pls let me know, How ?

Re: Query

JozsefSzikszai — Mon, 03 Dec 2007 08:44:34 GMT

hi Vikas,

there are two options:

1. Modify the query itself. In SQ01 you can add more fields to the query, if the infoset does not contain the fied yet, you can modify it in SQ02.

2. You cannot modify the generated program directly, but you can copy it to a Z... one. Then you can modify the copied one, however this we do very rarely.

hope this helps

Re: Query

former_member196280 — Mon, 03 Dec 2007 08:47:26 GMT

SAP query has certain limitations, we cannot modify the code generated by SAP query... SAp query mainly used to fetch data from tables and display it... check your requirment.. if you want to add new fields then goto SE01 and chenge your query... here you can add new fields that exists in the query table.

Regards,

SaiRam

Re: Query

former_member253223 — Mon, 03 Dec 2007 08:54:45 GMT

Hi Eric,

thank u,Can we modify the existing query or create a new query(SQ01) with same infoset as per requirement.

answers are appreciated in points.

thanks.

Re: Query

Former Member — Thu, 17 Jan 2008 04:44:38 GMT

Hi Vikas,

No, u can not change or modify auto generated code

if u want to add an additional field just change the infoset(functional area) and this will be solving your problem.no need to change the code.

thanks,

swaroop