Skip to Content
0
Former Member
Mar 04, 2009 at 03:38 PM

Select statement to pick up field runtime

58 Views

hi

i hava z-table

Ztable with field puid guid key1 key2 key3.

i want to fetch data for key1 key2 key3 runtime.

data : l_key type ztable-key1,

t_ztable type standard table of ztable with header line.

i wrote query as below

select * into table t_ztable from ztable

where puid eq '1',

guid eq '3',

l_key eq 'ght'.

where l_key will be key1,key2 or key3 as per runtime value.

but it is showing error that l_key is non defined.

I know other solution that putting where clause in one string variable.

But i want to ask whether it is possible to pass runtime field name in sele