03-22-2007 7:33 AM
03-22-2007 7:35 AM
03-22-2007 7:35 AM
03-22-2007 7:37 AM
tables: mara.
select-options:
s_matnr for mara-matnr.
select *
from mara
up to 1 rows
into mara
where matnr in s_matnr.
endselect.
It's with where clause....
reward if helpful...
03-22-2007 7:36 AM
Hi,
select * from kna1 up to 1 row where field1 = 'xxx' and field2 = 'yyyy'
* here you need to mention all the primary keys in the select to get the exact record
http://www.sap-img.com/abap/difference-between-select-single-and-select-upto-one-rows.htm
regards
Sudheer
03-22-2007 7:40 AM
Hi,
SELECT..... FROM <dbtab> [CLIENT SPECIFIED] [BYPASSING BUFFER]
[UP TO <n> ROWS].........
ENDSELECT.
SELECT * FROM MARA INTO ITAB UP TO 20 ROWS WHEER ABC = BCD.
rgds,
prajith
03-22-2007 7:40 AM
narenra,
Use this,
SELECT * FROM TABLE-NAME UP TO 1 ROWS INTO ITAB.
Regards,
Ramganesan K.
03-22-2007 7:41 AM
Hi,
it will give the same result as select single *.
for select single * u need not write endselect.
the syntax for this is
select * from <db table> up to 1 rows.
endselect.
regards,
bharat chowdary.