topic Re: Regarding select statement in Application Development and Automation Discussions

Regarding select statement

Former Member — Thu, 07 May 2009 13:38:22 GMT

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

Re: Regarding select statement

Former Member — Thu, 07 May 2009 13:39:40 GMT

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

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

Max

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

Re: Regarding select statement

former_member222860 — Thu, 07 May 2009 13:40:50 GMT

Simple

where fiedname =  '  '

Re: Regarding select statement

Former Member — Thu, 07 May 2009 13:43:44 GMT

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