Append statment logic required

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

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

[Former Member]

use F1 on appending table addition of select statement.

[Former Member]

Hi,

Please make use of the statement below:

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

Thanks,

Sriram Ponna.

[vinod_vemuru2]

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.