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....
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!!!)