Wednesday, September 30, 2020

Differences between SELECT SINGLE and UPTO 1 ROWS in SAP ABAP.

What are the differences between SELECT SINGLE and UPTO 1 ROWS?


Differences between SELECT SINGLE and UPTO 1 ROWS in SAP ABAP.

SELECT SINGLE

UPTO 1 ROWS

1. It extracts single record from the data base table

1. It extracts all the records into a buffer and moves the first record in to an application program

2. It doesn’t require END SELECT statement

2. It requires END SELECT

 3. Use this one, in case of all key fields can be considered. To read exact record from database table we need to provide all key fields.

3. Use this one, in case of not possible to use all the key fields. We can read appropriate record from database table; we may not need to provide all key fields.

4. It is slower because it is a construct to read database records with primary key. In the absence of the primary key, it might end up doing a sequential search

4. It is faster because you are not using all the primary key fields.

No comments:

Post a Comment