topic Re: SELECT STATEMENT in Application Development and Automation Discussions

SELECT STATEMENT

Former Member — Thu, 13 Dec 2007 08:53:06 GMT

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 — Thu, 13 Dec 2007 08:56:52 GMT

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 — Thu, 13 Dec 2007 09:02:52 GMT

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 — Thu, 13 Dec 2007 09:18:59 GMT

Hi kaveri,

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

regards

sirish