SELECT STATEMENT

[Former Member]

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 a_{vbeln = b}vbeln

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.

[Former Member]

u need add thisvl_awkey to the internal table tg_report.

for that after second select statement u need to modify the table tg_report by transporting vl_awkey only

[Former Member]

Hi Sirish,

Not getting ur req...

if u want vl_awkey field in tg_report internal table..then add this field to its structure..

loop at tg_report where vbeln = vl_vbeln..

tg_report-awkey = vl_awkey.

modify tg_report transporting awkey where vbeln = vl_vbeln.

endloop.

Regards,

Kaveri

[Former Member]

Hi kaveri,

My tg_report is a has no header line. so hw to add vl_awkey in tg_report.?

regards

sirish