Skip to Content
0
Former Member
Sep 12, 2007 at 06:05 PM

Concatenating two internal tables.

23 Views

Hi,

I am fetching a data say fields X,Y from one table into internal table T1 and fields X,Z from another table into internal table T2. Now here X is primary key and hence to display the concatenated result by means of data from T1 and T2 in third table T3, if an approach is first fetching X,Y into T1 and then using APPEND T1 to T3 and then fetching X,Z and then using APPEND T2 to T3 the data is fetched. However if result is needed as if the records are obtained by concatenating tables T1 and T2 and fetching result X,Y,Z in T3, what is the best method that can be used?

Thanks and Regards

Ameet