topic Re: Append statment logic required in Application Development and Automation Discussions

Append statment logic required

Former Member — Tue, 21 Oct 2008 11:52:03 GMT

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

Re: Append statment logic required

Former Member — Tue, 21 Oct 2008 11:54:24 GMT

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

Re: Append statment logic required

Former Member — Tue, 21 Oct 2008 11:54:29 GMT

Hi,

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

Re: Append statment logic required

Former Member — Tue, 21 Oct 2008 11:55:02 GMT

use F1 on appending table addition of select statement.

Re: Append statment logic required

Former Member — Tue, 21 Oct 2008 11:56:43 GMT

Hi,

Please make use of the statement below:


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

Thanks,

Sriram Ponna.

Re: Append statment logic required

vinod_vemuru2 — Tue, 21 Oct 2008 12:03:13 GMT

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.