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 SQL Trace, how would you carried out performance analysis of ABAP code using SQL Trace? Give the steps?

2 Answers  

1. If I send 5 entries of table from one system to another system, if the only 4 entries there in the target system what I have to do? 2. If I send the customer master IDOC from one SAP system to another system, if one field is missing in target table what is the steps? 3. If I want to access the 4th row 3rd column in the hashed table how to do it? 4. Whether there is any other statement than MODIFY statement to modify the content of internal table?

0 Answers  

What is the relation between Badi and Bapi ?

1 Answers   Accenture,

when we are using at new?should we use this inside the loop or outside?what will be the effect?

1 Answers  

how to print barcode in vertical manner

1 Answers   CSC,

i want to print 1 tp 100 in sapscript in a single page in a vertical manner 1 6 2 7 3 8 . . . . how will i do it

2 Answers   IBM,

how u define that idoc is generated for ale or edi method ?

3 Answers   IBM,

tell me about NGT?

1 Answers   Bristle Cone,

What is the difference between BAPI and RFC?

11 Answers   Bristle Cone, IBM,

What is sap abap tables?

0 Answers  

What is the use of SLIS type pool in Alv reports ?

4 Answers   IBM,

Can Top-of-page trigger with VLINE.?

4 Answers   Satyam,