10-21-2008 12:52 PM
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
10-21-2008 12:56 PM
Hi,
Please make use of the statement below:
... INTO|APPENDING [CORRESPONDING FIELDS OF] TABLE itab
Thanks,
Sriram Ponna.
10-21-2008 12:54 PM
take 6 structures for sixtables and append them to your final output table
10-21-2008 12:54 PM
Hi,
Try using Appending table itab from....after each selections to meet your requirement.
10-21-2008 12:55 PM
10-21-2008 12:56 PM
Hi,
Please make use of the statement below:
... INTO|APPENDING [CORRESPONDING FIELDS OF] TABLE itab
Thanks,
Sriram Ponna.
10-21-2008 1:03 PM
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.