topic Insert from select statement in Application Development and Automation Discussions

Insert from select statement

Former Member — Thu, 28 Oct 2010 04:32:03 GMT

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

Re: Insert from select statement

rejish_balakrishnan — Thu, 28 Oct 2010 12:45:01 GMT

Hi,

the problem is with select statement.

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

regards...

rbk

Re: Insert from select statement

Former Member — Tue, 02 Nov 2010 23:07:15 GMT

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

Re: Insert from select statement

Former Member — Thu, 18 Nov 2010 06:38:06 GMT

Hi,

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