Skip to Content
0
Former Member
Apr 30, 2009 at 10:00 AM

Combining Select Query

21 Views

Hi All,

Please tell me how to combine the following 2 select queries:

SELECT SINGLE konda

FROM vbkd

INTO v_konda

WHERE vbeln EQ v_vbelv.

SELECT SINGLE traty

FROM vbkd

INTO wa_output-out_code

WHERE vbeln EQ v_vbelv

AND posnr EQ v_posnr.

in order to access VBKD table only once.(here wa_output is a work area)

Thanks,

Neethu.