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 can a lock object be called in the transaction?
How to convert Normal function module to RFC enabled Function Module?
The extract statements in field groups can be used before or after processing the sort statements. State true or false. : abap modularization
how to capture the errors in bdc Call transaction method?
What is client in the sap system? : sap abap hr
How to use a specific number occurs statement?
what is a ticket?
8. what are user-exits? 9
what is Tool view and Project view?
What is Routine in ABAP and Types of routines?x
which state ment is used to move identically named fields between structures?
what is the difference between DATA ELEMENT and DOMAIN? please give the fully detailed