Select Query

[Former Member]

Hi all,

i need to fetch data from table T334E, where Primary keys are LGNUM and LGTYP and the other fields in the table are like LETY0,LETY1..........LET29.

i need to apply the condition something like....

select.....

from t334e

into.....

where lgnum = 'WZ1'

and lgtyp = <input lgtyp>

and LET&& = <input letyp>.

so my ques is how can i achieve this , is there any other way by which i can check whether LETY0...to....LET29, any of these fields holds the <inpu letyp>,otherwise i need to write those many conditions in the where clause as the no of fields LET&& (30!!!)

[Former Member]

Hi Neha,

You have to mention all the fileds in where condition. there is no other way.

[Former Member]

Hi Neha,

You have to mention all the fileds in where condition. there is no other way.

[naveen_inuganti2]

Hi..,

You have to declare ONE select-option for that filed,

And..,

Need to write where condition with all fields by checking with same select-options table.

Even if you try to write dynamic select-query for this, it reuires code more than this, as you need to check reuired variable anyway!

Thanks,

Naveen.I

[Former Member]

I used Field Symobols for this...