Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between select single * and Select
upto 1 row?
- 6 Answers
- 21871 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
Define batch input session?
How many tables are there in sap?
What is Field group?
Difference between Field groups and internal tables?
What are different types of parameters?
What is meant by hotspots?
What is the difference between a pool table and a transparent table?
What is value table? : abap data dictionary
What is evaluation path, where do we do it and why? : sap abap hr
Where do you create indexes in abap?
What are the dynapro keywords?
How to split one Invoice into Multiple ( Step by Step)?
how can you display data say "your name"in sap script without print program or driver program??
Can you set up background processing using call transaction?
Did you use buffering?
