Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between select single * and Select
upto 1 row?
- 6 Answers
- 22370 Views
- Yash Technologies, I also Faced
- E-Mail Answers
Answer Posted / chittidi
select single f1 f2 f3 ... into <wa> from <dbtab> where
<condition>. this where condition is important to fetch
exact record from database . for thsi purpose we provide
entire primary key combination in whrere conditon.
by using this statement to read exact information .
select f1 f2 f3 .... into <wa> from <dbtab> up to 1 rows
where <condition>
endselect.
it reads the first record found which may not be exact .
the where condition can be part of primary key combination.
it is mainly used to validate the INPUT.
IF WE ARE NOT PASSING ENTIRE COMBINATION OF PRIMARY KEY
IN SELET * SINGLE IT SIMPLY ACTS AS SELECT * UP TO 1 ROWS.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Did you create help views?
What is For-period and In-period
What kind of BDC programs are written ?
Why cant we use Normal function module for data transfer?
What are the payroll related Infotypes
What is an abap/4 query? : abap hr
Update function modules are classified as either v1 or v2. Which type of update is performed first and in what mode (asynchronously, synchronously or locally) can each type be processed in?
What actually happens in real-time recruitment? : sap abap hr
What are the ways you can do the tuning?
Difference between Field groups and internal tables?
How can we omit a leading sign and a leading zero in sapscript?
When to use logical database?
What are the difference between call screen and leave screen?
How do you set up background jobs in sap?
What is the use of start-of-selection.,if not use in report what will happen,?
