Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between select single * and Select
upto 1 row?
- 6 Answers
- 22140 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
What are the function modules used to create batch input session? : abap bdc
How do you document ABAP programs? Do you use program documentation menu option?
What are authorization objects and what statement is used to perform an authorization check in an abap program?
why to create a custom BAPI if the BAPI already exists? y to find BAPI again? frankly even i dint undstnd tne question properly. if any one come across this q please do anser me.
What are plan versions used for? : sap abap hr
What is an update type with reference to a match code id?
Explain what are the events in screen programming?
Fallback class
What is your approach to find exit and BAdi?
Explain the difference between domain and data element? What are aggregate object?
What is asap methodology? : sap abap hr
what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.
What is read line in abap?
What is luw or data base transaction ?
dear friends, do you know how to configure web dynpro and adobe into ECC6.0 IDES?
