Answer / guest

[select single xxx from...] means we are choosinf=g
aparticular field which we want to show on the particular page
at teh run time.
And the [select * from ....up to row] means to select all the
fields placed in that particular row. And remember one thing
that a row may be one but number of coloumns can lie inside
it.

Answer / harsha

upto one row is faster than select * from
select single xxx from xxx into wa xx = xxx-xx means it will check all the fields and finally gives a first possible record in the selected group of record
select * from xxx in wa where xx-xxx upto one row means it retrieves only first possible record of table satisfying th condition.
please revert me if any issues with this answer. i dunno weather its ryt r rong.

Answer / ravikanth

@ Harsha

Ur presentation is a bit confusing to understand.
2nd answer is good to refer.

Answer / abaprajaram

Select Single will be pick up first row as per the key
where as in the One row where will keep the index specific
key areas we can use
Select * from up to one row

When value table becomes check table?

0 Answers  

---

Does sap handle multiple languages?

0 Answers  

---

What are the uses of table pool or table cluster.

0 Answers  

---

What are authorization objects and what statement is used to perform an authorization check in an abap program?

0 Answers  

---

How to change standard data base table ?

1 Answers  

---

PLEASE HELP ANYONE ON THIS ISSUE,is there any problem with this function module :RHPQ_T77BX_ADD_QUALIS_OF_DPLAN. IT IS TRIGGERING BEFORE COMPLETION OF THE DEVELOPMENT PLAN but it has to trigger after compltion of development plan..this issue raised in my project..so reply urgently..thanks in advance..

0 Answers  

---

where do we define LDB to a program ?

1 Answers  

---

After running a BDC program in background, next day morning when you see the results, few records are not updated(error records). What will you do then?

2 Answers   DELL,

---

How will you add colour in a row using ALV ?

4 Answers   TCS,

---

Where do you code the hide statement?

0 Answers  

---

what is the role of secondary index in performance?

1 Answers   IBM, Siemens,

---

what are the differences between scripts & smart forms?

4 Answers  

---