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

identifying blank field

Former Member — Thu, 21 Aug 2008 07:26:25 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 ZERO...y???????

HERE FLD2 IS A DATE TYPE FIELD...

Edited by: Mathew Parera on Aug 21, 2008 9:28 AM

Re: identifying blank field

Former Member — Thu, 21 Aug 2008 07:29:47 GMT

Sy-subrc will be zero if your select query enables to retrieve any data with all the conditions satisfied.

Check on debugger i am sure that ITAB must contain some data.

Thanks and Regards

Aditya

Re: identifying blank field

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

Hi,

SY-SUBRC will be zero, if select query is a success.

If its not fetching values pertaining to FLD2 = SPACE.

Try select..

where FLD2 is null.

Regards,

Re: identifying blank field

Former Member — Thu, 21 Aug 2008 07:45:20 GMT

hi,

The reason the SY_SUBRC = 0 is that it has fetched the records from the table with the conditions that you have put,because the conditions put have been satisfied and data exists in th etable for the conditions..

Hope this hepls.

Thanks,

Rashmi.