What is the diffrence between select single * and Select
upto 1 row?
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
Explain the different types of mode (run code) in call transaction method?
What is protect & endprotect?
Explain what is sap script? What is the purpose of sap script? Difference between sap script and report?
What are authorization objects and what statement is used to perform an authorization check in an abap program?
How to determine the attributes of an internal table?
What is the purpose of sum statement?
What is your approach to find exit and BAdi?
How will u handle the situation – In a report using function module to generate a IDOC, How will u handle the error IDOC in the same report ?
Program lines for the radio button selection and unabling some input variables in section screen
What is the tcode for sapscript forms?
What is the definition of modification in an sap system and how do they impact an upgrade?
Explain what are the events in screen programming?
How do you find out whether a file exits on the presentation server?
How you attach search help to data element? : sap abap data dictionary
Have you set up a back ground job ? How to create a background job without a variant ?