Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

select single

Hi Gurus,

I am unclear about the meaning or usage of the syntax 'select single ... into...'

Could you please help to clarify?



Former Member
Former Member replied

hi Alfonso,

to add info given by Praveen...

select single will retrieve only one record eventhough there is more record meet the select statement.

e.g we have data in database

customer customer_group

a x

b x

c x

d y

using select single customer into lv_customer

where customer_group = 'x'.

we will get a only customer = a, though b and c also

meet the condition.

in data loading, it's suggested to avoid select single since it may be #1 performance killer, retrieve some records from database and move first to internal table and later fetch from internal table would normally better than select single record from database each time.

take a look some sample code on this

Update rules / master data attributes

Is it possible to read a third ODS in update rules between two ODS?

you can use transaction ABAPHELP to see more detail about select single. and ABAPDOCU may also useful.

hope this helps.

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question