Problem in Data selection

[Former Member]

Hi,

I have the below code

*********

Select VBELN VKORG From LIKP into table IT_LIKP

where VKORG = VKORG

AND ERDAT = ERDAT

AND WADAT_IST NE ' '.

*******

I want to select all deliveries VBELN from LIKP as per criteria in where clause and as i mention WADAT_IST NE ' '. but still it is selecting data where WADAT_IST is blank I also try with using SPACE insted of ' ' not still it is selecting two records.

regards,

zafar

[Former Member]

It should work if it is not working then delete the data from internal table.

Nabheet

[jayanthi_jayaraman]

Hi,

Try

WADAT_IST IS NOT INITIAL.

[nabheetscn]

It should work if it is not working then delete the data from internal table.

Nabheet

[Former Member]

I can see WADAT is a date field. The initial value for date will be 00000000 and not space. Try using NOT INITIAL or NE 00000000.

[Former Member]

hi

No matters let it come like that ,

delete those unwanted spaced rows , from the internal table as.

loop at IT_LIKP into IT_LIKP.
    if it_likp-WADAT_IST =  ' '.
         delete it_likp.
    endif.
endloop.

[Former Member]

Try gs_date type sy-datum, then pass that gs_datum in select statement, as a date field we have given has 00000000 in it.