topic Re: Problem in Data selection in Application Development and Automation Discussions

Problem in Data selection

Former Member — Wed, 01 Dec 2010 09:34:26 GMT

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

Re: Problem in Data selection

jayanthi_jayaraman — Wed, 01 Dec 2010 09:38:54 GMT

Hi,

Try

WADAT_IST IS NOT INITIAL.

Re: Problem in Data selection

nabheetscn — Wed, 01 Dec 2010 09:40:51 GMT

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

Nabheet

Re: Problem in Data selection

Former Member — Wed, 01 Dec 2010 09:42:45 GMT

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.

Re: Problem in Data selection

Former Member — Wed, 01 Dec 2010 09:48:11 GMT

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.

Re: Problem in Data selection

Former Member — Wed, 01 Dec 2010 11:06:27 GMT

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.