select --endselect

[Former Member]

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

how i can edit to it table with select single

[andreas_mann3]

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

[Former Member]

Hello Rani,

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

regards,

Kinshuk

[Former Member]

u can use

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

hope it helps,

Regards,

Bikash

[Former Member]

hi Rani,

as an alternative of that you can use

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

Regards,

Santosh

[Former Member]

Hi Rani,

Use select Fields from database table to itab where condition.

or

select * from dbtable into itab where condition.

i think this will help u out Rani..

Thanks,

Regars,

Sreevani

[rainer_hbenthal]

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.