topic Re: Select with comparison between two fields in DB table in Application Development and Automation Discussions

Select with comparison between two fields in DB table

Former Member — Fri, 28 Sep 2007 15:16:30 GMT

I need to do the following select but I am not sure of the correct syntax.

select vbeln fkart netwr into table it_table from vbrk where

fkdat NE erdat.

What I need is every record (only fields vbeln, fkart, and netwr) from vbrk where fkdat and erdat are not equal. Is there a way to do this in a single select? It is looking for erdat to be defined in the program but erdat and fkdat are both the values in the database and are not supplied by the program or the use. I hope this makes sense.

Davis

Re: Select with comparison between two fields in DB table

ferry_lianto — Fri, 28 Sep 2007 15:22:56 GMT

Hi,

Please try this.


select vbeln fkart netwr fkdat erdat 
into (vbrk-vbeln, vbrk-fkart, vbrk-netwr, vbrk-fkdat, vbrk-erdat) 
from vbrk
where fkdat ne space.
  if vbrk-fkdat ne vbrk-erdat.
    it_table-vbeln = vbrk-vbeln.
    it_table-fkart = vbrk-fkart.
    it_table-netwr = vbrk-netwr.
    append it_table.
  endif.
endselect.

Regards,

Ferry Lianto

Re: Select with comparison between two fields in DB table

Former Member — Fri, 28 Sep 2007 15:26:44 GMT

Ferry, thank you very much. I was unaware that you could do such a thing. I have learned a lot from you and I appreciate it very much!

Davis

Re: Select with comparison between two fields in DB table

former_member194669 — Fri, 28 Sep 2007 15:27:25 GMT

Hi,

May be this way.


tables : vbrk.
select vbeln fkart netwr from vbrk
  if vbrk-fkdat NE vbrk-erdat.
    move-corresponding vbrk to it_table.
    append it_table.
  endif.
endselect.

a®