buffer usage on select statments.

Hi,

There are many standard SAP tables where total row count is in crores. So for these table, if we give abap statement as "select * from tablename" then I want to ask if there will be any buffer issues. I have tried to limit rows by giving statement "select * from tablename where rowid" but unfortunately there is no rowid option available with select statement.

So I would like to ask if there is any other way to avoid any possible ABAP dumps due to buffer related issues when we give "select * from" command.

Please advise.

Regards,

Santosh