Select with comparison between two fields in DB table

[Former Member]

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

[ferry_lianto]

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

[Former Member]

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

[former_member194669]

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®