topic Re: alv grid in Application Development and Automation Discussions

alv grid

Former Member — Tue, 05 Dec 2006 12:18:52 GMT

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

Re: alv grid

Former Member — Tue, 05 Dec 2006 12:21:06 GMT

Hi.

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

Regards,

Satya.

Re: alv grid

anversha_s — Tue, 05 Dec 2006 12:27:47 GMT

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

Re: alv grid

Former Member — Tue, 05 Dec 2006 12:28:03 GMT

hi,

you better go for field catalog.

try this FM REUSE_ALV_FIELDCATALOG_MERGE.

shan

Re: alv grid

Former Member — Tue, 05 Dec 2006 12:29:28 GMT

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.