topic Re: select --endselect in Application Development and Automation Discussions

select --endselect

Former Member — Thu, 23 Mar 2006 08:17:43 GMT

i heard that select---endselect it not good for performance.

how i can edit to it table with select single

Re: select --endselect

andreas_mann3 — Thu, 23 Mar 2006 08:24:09 GMT

hi,

look in online-docu for:

select (fields) from dbtable into itab

where ....

or if you search a single item:

select single field from dbtable into hfield

where .... (complete primary key)

Andreas

Re: select --endselect

Former Member — Thu, 23 Mar 2006 08:24:13 GMT

Hello Rani,

you can try to collect data in a internal table with where condition and read from internal table.

regards,

Kinshuk

Re: select --endselect

Former Member — Thu, 23 Mar 2006 08:24:16 GMT

u can use

select xxx from dbtab into <b>TABLE</b> itab where xxx

hope it helps,

Regards,

Bikash

Re: select --endselect

Former Member — Thu, 23 Mar 2006 08:26:00 GMT

hi Rani,

as an alternative of that you can use

Select * <b>from mara into table Itab</b> Where Matnr = '000000000000000038'...

Regards,

Santosh

Re: select --endselect

Former Member — Thu, 23 Mar 2006 08:32:33 GMT

Hi Rani,

Use select Fields from database table to itab where condition.

select * from dbtable into itab where condition.

i think this will help u out Rani..

Thanks,

Regars,

Sreevani

Re: select --endselect

rainer_hbenthal — Thu, 23 Mar 2006 09:27:39 GMT

1) avoid select *, always type in the columns you need.

2) make extremly use of the where condition, do nout use check of if statements so filter data. Aoid evry unnecassry transfer from database to applaction server.

3) if you only need one row, use select single. in that case, you have to specify the whole primary key in the where condition.