Merging Internal Tables

Former Member · ‎2008 Apr 15

Hi Guys,

Is it possible to merge internal tables having different fields?

If so, how?

Thanks a lot!

Former Member · ‎2008 Apr 15

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.

Former Member · ‎2008 Apr 15

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.

Former Member · ‎2008 Apr 15

Hi,

Thanks a lot!

I have 3 internal tables:

i_crhd with fields:

kostl

objid

vgwts

arbpl

i_mseg with fields:

mblnr

bwart

matnr

werks

dmbtr

menge

meins

aufnr

kostl

budat

i_afko with fields:

aufnr

plnbez

aufpl

rsnum

I want to merge the 3 internal tables...

How am I going to do that? Thanks so much!

Former Member · ‎2008 Apr 15

Hi,

What would hapen if my first internal table have 50 rows and the my cond internla table have 100 rows and my third have 50 rows...? How many rows will my final internal table have?

Thanks a lot guys...

Former Member · ‎2008 Apr 15

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.