alv grid

[Former Member]

i am extrating different table fields and storing in different tables, can any one tell me how i need to make all differnet table fields in to one table and make the data into alv grid control

[Former Member]

i am extrating different table fields and storing in different tables, can any one tell me how i need to make all differnet table fields in to one table and make the data into alv grid control

[Former Member]

Hi.

Is there any common fields between these tables... Can i have the fields of the tables ur r extractiong...

Regards,

Satya.

[anversha_s]

hi,

make an internal table called int_final and pass this to ALV grid FM.

chk the below sample.

check this.

data : begin of itab1 occurs 0. "itab with work area.
key_field1 like ztable1-key_field1,
field1 like ztable1-field1,
field2 like ztable1-field2,
endof itab1. 

data : begin of itab2 occurs 0. "itab with work area.
key_field2 like ztable2-key_field2,
field3 like ztable2-field3,
field4 like ztable2-field4,
endof itab2. 

data : begin of itab_final occurs 0.
key_field1 like ztable1-key_field1,
field1 like ztable1-field1,
field2 like ztable1-field2,
field3 like ztable2-field3,
field4 like ztable2-field4,
endof itab_final. 


put the date final(merged) internal table
*****************************************
1. loop at itab1.
read table itab2 with key keyfield2 = itab1-keyfield1.
if sy-surc = 0.
itab_final-key_field1 = itab1-keyfield1
itab_final-field1 = itab1-field1.
itab_final-field2 = itab1-keyfield2.
itab_final-field3 = itab2-field2.
itab_final-field4 = itab2-keyfield2.
append itab_final.
clear itab_final.
endif.
endloop.

<i>pass this</i> <b>itab_final.</b>

rgds

Anver

[Former Member]

hi,

you better go for field catalog.

try this FM REUSE_ALV_FIELDCATALOG_MERGE.

shan

[Former Member]

hi ,

   loop at itab1.
         read table itab2 with key field1 = itab1-field1.
           read table itab3 with key field2 = itab1-field2.
         move-corresponding itab1 to it_final.
         move-corresponding itab1 to it_final.
        move-corresponding itab1 to it_final.
        append it_final.
   endloop.