identifying blank fields

[Former Member]

i want to extract blank field form the database table :

DATA: BEGIN OF IT_YCSTK OCCURS 0 ,

MATNR LIKE YCSTK-MATNR,

WERKS LIKE YCSTK-WERKS,

CHARG LIKE MSEG-CHARG,

GKAHR LIKE YCSTK-GKAHR,

FLD2 LIKE YCSTK-FLD2,

END OF IT_YCSTK.

SELECT MATNR WERKS CHARG GKAHR

FROM YCSTK

INTO CORRESPONDING FIELDS OF TABLE IT_YCSTK

WHERE FLD2 = SPACE.

BUT SY-SUBRC IS 4...y???????

HERE FLD2 IS A DATE TYPE FIELD...

[Former Member]

i want to extract blank field form the database table :

DATA: BEGIN OF IT_YCSTK OCCURS 0 ,

MATNR LIKE YCSTK-MATNR,

WERKS LIKE YCSTK-WERKS,

CHARG LIKE MSEG-CHARG,

GKAHR LIKE YCSTK-GKAHR,

FLD2 LIKE YCSTK-FLD2,

END OF IT_YCSTK.

SELECT MATNR WERKS CHARG GKAHR

FROM YCSTK

INTO CORRESPONDING FIELDS OF TABLE IT_YCSTK

WHERE FLD2 = SPACE.

BUT SY-SUBRC IS 4...y???????

HERE FLD2 IS A DATE TYPE FIELD...

[Sm1tje]

all data types have different initial (empty) values. For a date it will be 00000000

[Sm1tje]

do a select like this:

where FLD2 is initial or where FLD2 = '00000000'.

[Former Member]

check with default value of date field.

it is 00000000

[Former Member]

By default date has value 00000000

so fld2 = '00000000'

~hitesh

[Former Member]

Hello

WHERE FLD2 IS INITIAL.