filtering data

[Former Member]

Hi,

i am new to abap. i want to de-select the data which have vale- blank-space or character vale. only integer type of data need to be selected. plz help me in writing the expression .

regards

vivek

[Former Member]

You can give a condition for that

v_val IS NOT INITIAL.

Hope this solves your purpose.

Award points if it helps.

-Gaurang

[Former Member]

select * from dbtable into itab where vale <> ' ' and ca 'abcdefghijklmnopqrstuvwxyz'

[Former Member]

hi,

this statement is showing error.

regards

vivek

[Former Member]

check this sample..

data : begin of itab occurs 0,

f1(5) type c,

end of itab.

itab-f1 = 'ABC1'.

append itab.

itab-f1 = '111'.

append itab.

itab-f1 = 'ABC1'.

append itab.

itab-f1 = '221'.

append itab.

loop at itab.

if itab-f1 ca sy-abcde or itab-f1 = ''.

delete itab index sy-tabix.

endif.

endloop.

loop at itab.

write : / itab-f1.

endloop.

regards

shiba dutta

Message was edited by:

SHIBA DUTTA

[Former Member]

hi vivek,

just try this,

select * from dbtable where field NE ' ',

and field GE '0'

and field LE '99999999999999'.

this code can solve your problem.

regards...

seshu.