topic Re: Three select statement data in to One Internal table in Application Development and Automation Discussions

Three select statement data in to One Internal table

Former Member — Tue, 14 Oct 2008 05:49:51 GMT

HI All,

By using 3 select statement, data is displying by using work area (classical report). Now i want define three internal table for three select statements, and finally get the data in one final itab, and pass this to function module (ALV Report).

looking for response

Re: Three select statement data in to One Internal table

Former Member — Tue, 14 Oct 2008 05:56:02 GMT

can u be a bit more clear.

if ur requirement is that u have 3 intable and u want the data in one final table

then u can do this

loop at itab1 into wa1.

wa_final = wa1.

append wa_final to it_final.

endloop.

similarly for for the other 2 itab

Re: Three select statement data in to One Internal table

Former Member — Tue, 14 Oct 2008 05:56:45 GMT

Just remove all write statements and Skip keyword.

and create internal tables as same as earlier work area were defined and collect all data in itab by using read statements.

this seems a very structured process while switching to ALV from classical

Re: Three select statement data in to One Internal table

Former Member — Tue, 14 Oct 2008 06:44:23 GMT

HI sushant,

In a classicall report, getting the data by using Select & Endselect statements (total 3 select stat). Now i want to displya the data in ALV formate. So, i want to get all data in to one final itab.

I am thinking to define 3 itabs for 3 select stats & one final itab. How to fetch all data into the final itab....

I hope provieded clear info..

Re: Three select statement data in to One Internal table

GauthamV — Tue, 14 Oct 2008 06:50:46 GMT

hi,

first define 3 internal tables and get data into them.

now you can loop at one internal table and read the data from other internal tables and move that data into final internal table.

check this.


Form final_table.

loop at it_bsis.
 CLEAR IT_bkpf.
 READ TABLE IT_bkpf WITH KEY bukrs = IT_bsis-bukrs
                             belnr = it_bsis-belnr
                             gjahr = it_bsis-gjahr.


 IF SY-SUBRC = 0.

 it_final-xblnr = it_bkpf-xblnr.
 it_final-bukrs = it_bkpf-bukrs.
endif.
 CLEAR IT_bseg.
 READ TABLE IT_bseg WITH KEY bukrs = IT_bkpf-bukrs
                             belnr = it_bkpf-belnr
                             gjahr = it_bkpf-gjahr.
                             
 IF SY-SUBRC = 0.

 IT_FINAL-belnr = IT_bseg-belnr.
 it_final-prctr = it_bseg-prctr.
 IT_FINAL-gsber = IT_bseg-gsber.
endif.
 APPEND IT_FINAL.
 CLEAR IT_FINAL.
endloop.

endform.

Re: Three select statement data in to One Internal table

Former Member — Tue, 14 Oct 2008 09:45:39 GMT

hi,

to get the data of 3 internal tables(TABLEA,TABLEB,TABLEC) into 1 internal table(FINAL) can be done by:

=> append the data of all the 3 internal table into one.

loop at TABLEA.

append TABLEA to FINAL.

endloop.

loop at TABLEB.

append TABLEB to FINAL.

endloop.

loop at TABLEC.

append TABLEC to FINAL.

endloop.

=> if u want only some specific data from 3 internal tables into 1 internal table then,loop at one table and read every entry of other internal table on the basis of some comparision and filter out the data to a final table,like:

loop at TABLEA.

read table TABLEB with key fielda = TABLEA-fielda.

if sy-subrc = 0.

move TABLEA-fielda to FINAL-fielda.

move TABLEB-fieldb to FINAL-fieldb.

append FINAL.

endif.

endloop.

anf then throw this final table to function module "REUSE_ALV_GRID_DISPLAY" to show the final data in ALV format..

Re: Three select statement data in to One Internal table

Former Member — Tue, 14 Oct 2008 10:11:59 GMT

hi,

just go through this simple example. no need of declaring 3 itabs.

data: begin of st1,
        a1 type c,
        a11 type i,
      end of st1.

data: begin of st2,
        a2 type i,
        a22 type c,
      end of st2.

data: begin of st3,
        a3 type i,
        a33 type i,
      end of st3.

data: begin of fin_struct.
          include structure st1.
          include structure st2.
          include structure st3.
data: end of fin_struct.

data: fin_itab like table of fin_struct with header line.

*1st structure  values
move 'a' to fin_itab-a1.
move 1 to fin_itab-a11.

*2nd structure values
move 11 to fin_itab-a2.
move 'b' to fin_itab-a22.

*3rd structure values
move 15 to fin_itab-a3.
move 12 to fin_itab-a33.

*appending 1st record.
append fin_itab.

*1st strcuct values
move 'b' to fin_itab-a1.
move 3 to fin_itab-a11.

*2nd structure values
move 22 to fin_itab-a2.
move 'c' to fin_itab-a22.

*3rd structure values
move 20 to fin_itab-a3.
move 30 to fin_itab-a33.

*appending 2nd record.
append fin_itab.


loop at fin_itab.
write:/ fin_itab-a1, fin_itab-a11, fin_itab-a2, fin_itab-a22, fin_itab-a3, fin_itab-a33.
endloop.

here structre1,2,3...

i used move statement.

here u write select statement.. into struct1,2,3....

using move u move all the values ...

finally append it to final itab...

rest of and all common for ALV...

Regards,

Shankar.

Re: Three select statement data in to One Internal table

Former Member — Tue, 14 Oct 2008 10:50:59 GMT

HI sandya,

did u got it.....

Regards,

Shankar.

Re: Three select statement data in to One Internal table

Former Member — Mon, 17 Nov 2008 09:27:31 GMT

Hi Shakar,

yes i got it. ur answer helped me, not only this case but another case.

thnx