Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Append statment logic required

Former Member
0 Kudos

Hi All,

i want to fetch the records from 6 tables. The fields are same. For that i have a internal table. i want to make all the selected records in the internal table. How to make that?

anyone pls guide this.

Mohana

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

Please make use of the statement below:


... INTO|APPENDING [CORRESPONDING FIELDS OF] TABLE itab

Thanks,

Sriram Ponna.

5 REPLIES 5

Former Member
0 Kudos

take 6 structures for sixtables and append them to your final output table

Former Member
0 Kudos

Hi,

Try using Appending table itab from....after each selections to meet your requirement.

Former Member
0 Kudos

use F1 on appending table addition of select statement.

Former Member
0 Kudos

Hi,

Please make use of the statement below:


... INTO|APPENDING [CORRESPONDING FIELDS OF] TABLE itab

Thanks,

Sriram Ponna.

vinod_vemuru2
Active Contributor
0 Kudos

Hi,

Do like this.

SELECT f1 f2.. INTO TABLE i_tab FROM dbtab1

..

..

SELECT f1 f2.. APPENDING TABLE i_tab FROM dbtab2

.

.

.

SELECT f1 f2... APPENDING TABLE i_tab FROm dbtab6.

Now u have data from 6 tables into i_tab.

Thanks,

Vinod.