topic Re: identifying blank fields in Application Development and Automation Discussions

identifying blank fields

Former Member — Thu, 21 Aug 2008 07:33:31 GMT

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 — Thu, 21 Aug 2008 07:35:50 GMT

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

Former Member — Thu, 21 Aug 2008 07:35:55 GMT

check with default value of date field.

it is 00000000

Sm1tje — Thu, 21 Aug 2008 07:36:48 GMT

do a select like this:

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

Former Member — Thu, 21 Aug 2008 07:37:35 GMT

By default date has value 00000000

so fld2 = '00000000'

~hitesh

Former Member — Thu, 21 Aug 2008 07:39:52 GMT

Hello

WHERE FLD2 IS INITIAL.