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
What are Tickets in Realtime ?
What will you code in start-of-selection & end-of-selection ?
How do you validate the selection criteria of a report? And how do you display initialvalues in a selection screen?
What is output determination?
What is the difference between collect and sum?
Does the call transaction method allow multiple transactions to be processed by sap? : abap bdc
How do you execute the payroll
How table control cn be generated using bdc? : abap bdc
What are the buffering types?
What are the organizational related Infotypes
How did you test the form you developed? How did you taken print?
Events that can be used in both the classical and interactive reports
What is a modification assistant?
What are spa/gpa parameters (sap memory)?
How to transfer data into line items using batch input session method? : abap bdc