I am unclear about the meaning or usage of the syntax 'select single ... into...'
Could you please help to clarify?
Edwin Harpino replied
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
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
you can use transaction ABAPHELP to see more detail about select single. and ABAPDOCU may also useful.
hope this helps.