what is the difference between [select single xxx from ...]
and [select * from ... up to one row]?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 3 Yes | 0 No |
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.
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / ravikanth
@ Harsha
Ur presentation is a bit confusing to understand.
2nd answer is good to refer.
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
How to maintain lists?
what is meant by idoc filtering?
What is a match code in sap?
How do you do Recording and what will you do?
as a developer how u will decided which internal table we will use for requirement?
Which is the best institute for abap in ameerpet
How many default tab strips are there? How to insert more tabs in it?
What is the diffrence between Abstract Class and an Interface in OOABAP.
you've to run some program in back ground. how to display the last month info from 1st to 31st?
How can we set the table spaces and extent sizes? : abap data dictionary
Which function module you will use to attach a search help to a field in Selection screen?
Why do we use CALL FUNCTION ..IN BACKGROUND TASK and CALL FUNCTION ...STARTING NEW TASK? What is the difference?