Skip to Content
0
Former Member
Dec 13, 2007 at 08:53 AM

SELECT STATEMENT

11 Views

Hi Gurus,

im working on alv reports.in this i hav 2 select statements .

SELECT * FROM vbrk AS a INNER JOIN vbrp AS b ON avbeln = bvbeln

INTO CORRESPONDING FIELDS OF TABLE tg_report

WHERE a~vbeln IN s_vbeln

AND a~vkorg IN s_vkorg

AND a~vtweg IN s_vtweg

SELECT SINGLE awkey FROM bkpf INTO vl_awkey WHERE belnr = vl_vbeln.

CONCATENATE '00' vl_awkey INTO vl_awkey.

i want to keep this <b>vl_awkey</b> field in this select statement & output in tg_report.

plz help me in this Gurus.

correct answers will be rewarded.

sirish.