Answer / manu gowdru

select single:it selects the first record which matches the condition defined in WHERE clause.so if there many records which matches the criteria will be ignored,so its not unique

select upto 1 rows:it retrieves all the records which matches the condition mentioned in WHERE clause and puts aggregate,average and gives the result

Answer / sumit0312

select single fetch the specified and matching data from the
table. and select up to 1 record directly select the first
record from the tabe.

Answer / silverage

Both will fetch 1 record from table. Select single is used when all the key of the table are to be matched in where condition. Select upto is used when any of the key is missing in the where condition.

Answer / nigesh

Select Single * will pickup only one matching record from
the database into the buffer, and returns the same to the
internal table.

Select upto 1 rows will pickup all the records matching the
condition into the buffer, but return the top record to the
internal table.

Answer / gagan

in select single , if multiple records are present matching
the where clause ( if stated ), then it returns the last
record among them.

While in select upto 1 rows , it returns the first
occurrence of the record.

What is object in OM

1 Answers  

How do you do BDC field Validtaions ? can any one help with syntax? is there any difference with BDC and BAPI validations?

1 Answers   CSC,

What does the extract statement do in extract datasets?

0 Answers  

why Transaction Varient needed?

1 Answers  

What do you mean by transparent tables in sap abap? : abap data dictionary

0 Answers  

what is the difference between user-exit & BADIs?

2 Answers  

difference between session and lsmw difference between bdc and lswm why u choose bdc instead of bapi

1 Answers   Siemens,

what "types" can be assigned to a data object in an abap

2 Answers  

Cds views

0 Answers   Infosys,

It is not possible to create an abap/4 program, which contains only subroutines. State true or false. : abap modularization

0 Answers  

in what application server the business logic is developed/deployed?

2 Answers   Zydus Cadila,

what is the main use of package(in user exits ,in SMOD user can provide the package name for the purpose of to find out all user-exits,that package use iam asking)?

1 Answers   Intelligroup,