topic Re: Select statement to pick up field runtime in Application Development and Automation Discussions

Select statement to pick up field runtime

Former Member — Wed, 04 Mar 2009 15:38:41 GMT

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

Re: Select statement to pick up field runtime

Former Member — Wed, 04 Mar 2009 15:46:04 GMT

Hi harshalata,

first Check your field l_key exist in that table ztable.

then you can proceed to assigining the value at the run time.

runtime only possible with the existance of that field in that table

Thanks

Edited by: Prasanth on Mar 4, 2009 9:16 PM

Re: Select statement to pick up field runtime

Former Member — Wed, 04 Mar 2009 15:46:55 GMT

You need to use a dynamic condition, it would be something like this

L_key is the name of the field you want to use dynamically


data: l_key(50)

data: begin of itab occurs 0,
cond(72),
end of itab.
itab-cond = 'puid eq ''''1'''' and'. append itab.
itab-cond = 'guid eq ''''3'''' and'. append itab.
concatenate l_key 'eq' '''''3''''.' into itab-cond separated by space.
append itab

select * into table t_ztable from ztable
where (itab).

Re: Select statement to pick up field runtime

Former Member — Wed, 04 Mar 2009 15:48:41 GMT

Hi,

In Ztable there are only this fields puid guid key1 key2 key3.there is no field with l_key in table ztable.

so it won't work.

Regards,

Sathish

Re: Select statement to pick up field runtime

Former Member — Wed, 04 Mar 2009 15:58:52 GMT

hi alll

I want to run query

select * from ztable into table t_ztable

where puid eq 1

guid eq 2

(key1 or key2 or key3) eq 'abc'.

here l_key will hold value either key1,key2,key3 runtime

Re: Select statement to pick up field runtime

Former Member — Wed, 04 Mar 2009 16:08:44 GMT

I told you already how to do it. You need to fill the condition in a table.

Re: Select statement to pick up field runtime

Former Member — Wed, 04 Mar 2009 16:14:07 GMT

I can achieve that with putting condition in string.

L_where_clause. no need of table too.

Just asking whether we pass Column name of Table runtime without using itab ot l_where_clause (string)

Re: Select statement to pick up field runtime

former_member194669 — Wed, 04 Mar 2009 16:19:47 GMT

You can pass the field name only in where clause by concatenating. we don't any other opions to do that

otherwise you need to look for

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db999535c111d1829f0000e829fbfe/content.htm

a®

Re: Select statement to pick up field runtime

Former Member — Wed, 04 Mar 2009 17:08:15 GMT

thanks everyone