topic Re: Re: Select Single * statement in Application Development and Automation Discussions

Re: Select Single * statement

colin_cheong — Fri, 23 Apr 2010 14:19:34 GMT

Hi ABAPers,

I had a question and hope you could give me an answer.

Here is it,

select single * into itab from VRMPA where MATNR in S_MATNR

This would return a single record into itab although it is not correct as there would be more than 1 incoming record and so it is not unique.

My question is

a. would the logic skip out when it hit the first record and would not process the second valid selection

b. it would process all valid records and return only the last record processed

i need to know in order to improve the performance of the logic.

Thanks for the answer in advance.

Re: Re: Select Single * statement

Former Member — Fri, 23 Apr 2010 14:25:36 GMT

When you do a select single, SAP will only retrieve 1 result, the first it encounters. So if you would have multiple material numbers in your select-option S_MATNR, only 1 of them will be in the result. The others are not further selected.

Re: Re: Select Single * statement

rthoodi — Fri, 23 Apr 2010 14:28:47 GMT

The logic skip out when it hits the first record and record was placed in itab, in contrast to select single , select up to 1 rows will fetch all records corresponding to itab based on where clause, but places only first record in itab.

However, make sure that when u use select single *, better use all key fields in where clause as possible and it is not necessary to get data into ITAB, just get data into wa_itab as there is only one record will fetched using select single statement.

Thanks

Re: Re: Select Single * statement

Former Member — Fri, 23 Apr 2010 14:33:26 GMT

Hi,

Its very basic question lot of information available in Google

Checkout this link

http://www.sap-basis-abap.com/abap/difference-between-select-single-and-up-to-1-row.htm

Regards and Best wishes.

Re: Re: Select Single * statement

SuhaSaha — Fri, 23 Apr 2010 14:37:24 GMT

Hello Colin,

You would rather hit an F1 on SELECT SINGLE & read the SAP documentation which clearly states:

"If the remaining additions to the SELECT command select more than one line from the database, the first line that is found is entered into the resulting set"

Source: [http://help.sap.com/abapdocu_70/en/ABAPSELECT_CLAUSE_LINES.htm#!ABAP_ALTERNATIVE_1@1@]

Re: Re: Select Single * statement

Former Member — Fri, 23 Apr 2010 19:51:36 GMT

Select single with an IN operator is simply nonsensical. You would write

. . . .where matnr eq <matnr parameter>.