topic Re: filtering data in Application Development and Automation Discussions

filtering data

Former Member — Wed, 09 May 2007 08:56:29 GMT

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

Re: filtering data

Former Member — Wed, 09 May 2007 08:58:02 GMT

You can give a condition for that

v_val IS NOT INITIAL.

Hope this solves your purpose.

Award points if it helps.

-Gaurang

Re: filtering data

Former Member — Wed, 09 May 2007 08:58:37 GMT

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

Re: filtering data

Former Member — Wed, 09 May 2007 09:07:11 GMT

hi,

this statement is showing error.

regards

vivek

Re: filtering data

Former Member — Wed, 09 May 2007 09:11:46 GMT

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

Re: filtering data

Former Member — Wed, 09 May 2007 09:15:25 GMT

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.