Changing the Query

[Former Member]

Hello All,

I need to make authority check on Plant which is a select-options field of the existing Query.I went to SQ02 and tried to change the code in start-of-selection(tried in other events too).When I put break-point it is getting triggered, but when I use the screen field name of plant(SP$00008) in code query is throwing an error at the generation time saying "SP$00008 is not defined by DATA statement".

In short when I try to write the code in SQ02 I am unable to access the selection fields.Please suggest what to do?

Regards,

Shafivullah Mohammad

[Former Member]

Probably it may not be in Global declaration. Try keeping it in Global data

[Former Member]

Hello Phani,

Thanks for ur advise but it is not the Global data it is a select-options field name.

Regards,

Shafivullah

Edited by: shafivullah mohammad on Feb 23, 2009 2:36 PM

[kiran_k8]

Shafi,

We can change the Query and the tables used in it,but we can even change the code generated by the query?I am not aware of this,looking forward to the replies.

K.Kiran.