Skip to Content
0
Former Member
Sep 14, 2007 at 09:08 AM

select query problem

91 Views

hi friends,

i am selecting vbeln from vbrk .

and fkimg netwr from vbrp.

i am able to get values for first line item only.

how to slect for multiple line item.

SELECT kschl knumv kwert kposn FROM konv

INTO CORRESPONDING FIELDS OF TABLE cond

WHERE ( kschl = 'JCST' OR kschl = 'ZCST' ).

IF cond[] IS NOT INITIAL.

SELECT vbeln knumv fkdat kunag kunrg FROM vbrk

INTO CORRESPONDING FIELDS OF TABLE itab

FOR ALL ENTRIES IN cond

WHERE knumv = cond-knumv

AND vbeln IN vbeln.

ENDIF.

IF itab[] IS NOT INITIAL.

SELECT vbeln fkimg netwr posnr FROM vbrp

INTO CORRESPONDING FIELDS OF item

FOR ALL ENTRIES IN itab

WHERE vbeln = itab-vbeln.

  • and posnr = cond-kposn.

APPEND item.

ENDSELECT.

ENDIF.

can any one correct my code.

thanks.