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 |
A function group contains globally defined internal tables and function modules defined in it. FMOD1 populates itab1 and when FMOD2 is called will itab1 contains those values being populated by FMOD1?
Read statement..
How to upload data using catt ? : abap hr
What is the difference between value table and check table?
How to upload more than 2GB file from External Source to SAP?
what is the use of FOR ALL ENTRIES in an internal table?
9 Answers Keane India Ltd, PCS, Wipro,
What is the client concept in sap?
Are EVENTS Possible in LSMW?If so how to achieve?
What are lock objects?
What is the difference between Initialization and parameters ?
while implementing badi what are the tables u find??
I am having an internal table with field name 'type' which consists of values 'a' 'b' 'c' 'a' 'a'.Now i used 'at new fieldname' control statement on this field so what could be the output