Skip to Content
0
Former Member
Nov 12, 2011 at 09:13 AM

SQVI - not getting any result

51 Views

Dear Experts,

When I join table VBAK and AUFK in SQVI, I am not getting any result. The join condition is proposed by the system. (field AUFNR in VBAK and AUFK).

I tried debugging SQVI, and I found these lines of codes:

open cursor with hold %dbcursor for

select VBAKVBELN AUFKAUFNR

from ( VBAK

inner join AUFK

on AUFKAUFNR = VBAKAUFNR )

where AUFK~AUFNR in SP$00001 .

It seems the system does not get any result from executing it. I tried to write a simple ABAP code similar to it like this:

select VBAK~VBELN

from ( VBAK

inner join AUFK

on AUFKAUFNR = VBAKAUFNR )

into corresponding fields of table it_aufk

where AUFK~AUFNR in S_AUFNR.

Again, I am not getting any result from it as well.

Would you please suggest how to make my query in SQVI works?