Skip to Content
0
Former Member
Jan 26, 2011 at 08:47 AM

Abap SQL question

564 Views

Hi,

I need to select the set of records only in Table A, but not in Table B. I think that the correct SQL is:

select k~vbeln

into data

from vbak as k

inner join vbfa as f on kvbeln = fvbelv

where f~vbelv is null.

But the following message appears: u201CNo fields from the right-hand table of a LEFT OUTER JOIN may appear in the WHERE condition: u201CF~VBELBu201Du201D.

Thanks in advance,

Ricard.