Regarding select statement

[Former Member]

hii !!

i am new to abap. I want to select only the rows in which a particular field is blank in a table. Can any one tell what condition should i keep in the where condition.

Sorry if i asked a silly question.

can anyone help me

Regards

radhika

[Former Member]

Hi

SELECT * FROM <TABLE> WHERE <FIELD> = SPACE.

or

SELECT * FROM <TABLE> WHERE <FIELD> IS NULL.

Max

Edited by: max bianchi on May 7, 2009 3:43 PM

[former_member222860]

Simple

where fiedname =  '  '

[Former Member]

Hi ,

Try this code - -

DATA : t_itab LIKE TABLE OF spfli.
SELECT * FROM spfli INTO TABLE t_itab
                           WHERE carrid = '   ' ." Where condition field carrid of spfli

Here in the example table is SPFLI and the field is CARRID.You can use any table

and any field similarly according to your requirement.

For more information you can write SELECT in the ABAP editor and press F1 keeping

the cursor in the SELECT.

Regards

Pinaki