Skip to Content
0
Former Member
Mar 31, 2008 at 03:58 AM

select query

14 Views

Hi Friends,

I want to pick condition value kwert for condtion type zcdj

from invoice No .

i used this query its not working.

loop at i_vbtab.

i_vbtab-xyz = i_vbtab-vbeln.

modify i_vbtab.

endloop.

SELECT kschl kwert FROM konv

INTO CORRESPONDING FIELDS OF TABLE i_konv1

for all entries in i_vbtab

WHERE kschl = 'zcdj'

and knumv = i_vbtab-xyz

and sakn1 >= '0006105430'

and sakn1 <= '0006106430'.

pls help.