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.

Types of BDC?

5 Answers  

What are the different kinds of lock modes?

0 Answers  

wat is the difference between A-gate & W-gate?where are they used?

0 Answers  

what the tcode to check the consistency of work flow for ALE /EDI in a inbound error processing?

1 Answers  

how can you display data say "your name"in sap script without print program or driver program??

0 Answers   Siemens,

How do you do effort estimation? Based on which parameters?

2 Answers   KPIT,

How to combine multiple order in one Delivery ( Step by Step)?

0 Answers  

if i login in english then top-of page will display in english.if i login in german then it will display in german as on .. abap report how.........

4 Answers   IBM,

How many ways can a sap system be accessed?

0 Answers  

whai is the transaction code or table to see all print programs

2 Answers   Reliance,

scripts are client independent then how to transfer from one client to (i know RSTXR3TR AND SCC1 TCODE )another client?

2 Answers   Satyam,

While sorting field groups we cannot use more than one key field. State true or false. : abap modularization

0 Answers