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 |
Difference between sy-tabix and sy-index?
What is the syntax of packed number?
how to modify the standard method as per your requirement
whai is the transaction code or table to see all print programs
6)what are the table controls in BDC ?
Explain what are the different functions used in sap script? What are the parameters used in each function?
How do you send files to the legacy systems from SAP and vice versa? How does one know that the legacy files have come on to the SAP server you are working on?
How do you write a squential file
how to design checkbox on the o/p of the list ,not on the selection screen.
in bdc which method is suitable for back ground processing?
4 Answers Bristle Cone, Cap Gemini, HP, Satyam, Wipro,
What are domains and data element?
What is the exactly definition of Foreign key 2.what is the exactly definition of Value Table. 3)What is the exactly definition of Data element and Domain.Please give the exactly definitions of all above questions without fail....Thanku