topic Re: Merging Internal Tables in Application Development and Automation Discussions

Merging Internal Tables

Former Member — Tue, 15 Apr 2008 03:43:44 GMT

Hi Guys,

Is it possible to merge internal tables having different fields?

If so, how?

Thanks a lot!

Re: Merging Internal Tables

Former Member — Tue, 15 Apr 2008 03:54:01 GMT

hi,

do this way ....

declare a final internal table having both the internal table fields ...and then do as below...



loop at itab1.
 move-corresponding fields of itab1 to it_final.
 append it_final.
 clear    it_final.
endloop.

loop at itab2.
 move-corresponding fields of itab2 to it_final.
 append it_final.
 clear    it_final.
endloop.

Re: Merging Internal Tables

Former Member — Tue, 15 Apr 2008 03:55:22 GMT

Hi,

As far as I know.

If you want to merge two internal table there should be atleast one key field in common in both of those internal tables, otherwise you can't do it.

If you want to append all the fields into one final internal table then declare the internal table with all the fileds and use move corresponding to do it.

Re: Merging Internal Tables

Former Member — Tue, 15 Apr 2008 03:56:25 GMT

Hi Mark,

i think its possible to merge more than two internal tables. Pls find the below code depicting the same.

report zbnstest.

data syrepid like sy-repid.

data sydatum(10). " LIKE sy-datum.

data sypagno(3) type n.

type-pools : slis.

data: begin of t_mara occurs 0,

matnr like mara-matnr,

meins like mara-meins,

mtart like mara-mtart,

matkl like mara-matkl,

end of t_mara.

data : begin of t_marc occurs 0,

matnr like mara-matnr,

werks like marc-werks,

minbe like marc-minbe.

data: end of t_marc.

data : begin of t_makt occurs 0,

matnr like mara-matnr,

maktx like makt-maktx,

spras like makt-spras,

end of t_makt.

data: begin of itab1 occurs 0,

matnr like mara-matnr,

meins like mara-meins,

maktx like makt-maktx,

spras like makt-spras,

werks like marc-werks,

minbe like marc-minbe,

end of itab1.

data: fieldcatalog type slis_t_fieldcat_alv with header line,

fieldlayout type slis_layout_alv.

data : eventstab type slis_t_event with header line.

data : heading type slis_t_listheader with header line.

data : heading1 type slis_t_listheader with header line.

data : heading2 type slis_t_listheader with header line.

data : heading3 type slis_t_listheader with header line.

data : heading4 type slis_t_listheader with header line.

data : heading5 type slis_t_listheader with header line.

data : heading6 type slis_t_listheader with header line.

data : heading7 type slis_t_listheader with header line.

data : heading8 type slis_t_listheader with header line.

initialization.

syrepid = sy-repid.

sypagno = sy-pagno.

clear fieldcatalog.

start-of-selection.

perform fill_colorstruct using colorstruct.

perform populate_fieldcatalog.

perform selectdata_and_sort.

perform populate_layout using fieldlayout.

perform merge_fieldcatalog.

perform fill_eventstab tables eventstab.

perform fill_headingtable tables heading using 'HEADING'.

perform fill_headingtable tables heading1 using 'HEADING1'.

perform fill_headingtable tables heading2 using 'HEADING2'.

perform fill_headingtable tables heading3 using 'HEADING3'.

perform fill_headingtable tables heading4 using 'HEADING4'.

perform fill_headingtable tables heading5 using 'HEADING5'.

perform fill_headingtable tables heading6 using 'HEADING6'.

perform fill_headingtable tables heading7 using 'HEADING7'.

perform fill_headingtable tables heading8 using 'HEADING8'.

perform display_alv_list.

form populate_fieldcatalog.