Skip to Content
0
Former Member
Mar 23, 2009 at 05:36 AM

No result if one field is blank

550 Views

Hi all,

in my module pool screen i have 4 input fields (no selection or ranges, its like parameters). To get the value based on that i am using this query.

SELECT *

FROM LTAK

INTO TABLE GT_LTAK

WHERE LGNUM = GV_LGNUM

AND KQUIT NE 'X'

AND BNAME = LV_BNAME

AND BWLVS = LV_BWLVS

AND BENUM = LV_BENUM.

If i fill all these 4 values i am getting the output. If i leave a field blank i dont get the result.

Can anyone please help me.

Regards,

Nik