Insert from select statement

[Former Member]

Hi,

My program is based upon two SAP BI (DSO) tables, I wrote the select statement to populate the data into an internal table and loading into database table from internal table.

To populate into an internal table it takes 10 mins but to insert it takes 45 mins, I tried load data directly into an database table but i failed, is there any way to acheive this?

Thanks

[rejish_balakrishnan]

Hi,

the problem is with select statement.

Try using relevant select query (see best practices for select statement in sdn)

regards...

rbk

[Former Member]

Hi RBK,

I dont understand, how you conclude the problem is with Select statement, I hope there is no problem with Select statement, if there is any problem, then it would have not completed 10 mins (for millions of records)

Regards,

Ganesh

[Former Member]

Hi,

Just to close this thread, In ABAP it is not possible to insert into database table using select statement.