topic Re: select.........upto 1 rows syntax in Application Development and Automation Discussions

select.........upto 1 rows syntax

Former Member — Thu, 22 Mar 2007 07:33:36 GMT

plz sent the syantax select..........upto 1 rows

Re: select.........upto 1 rows syntax

Former Member — Thu, 22 Mar 2007 07:35:13 GMT

select *

from mara

up to 1 rows

into w_mara.

endselect.

Re: select.........upto 1 rows syntax

Former Member — Thu, 22 Mar 2007 07:36:06 GMT

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

Re: select.........upto 1 rows syntax

Former Member — Thu, 22 Mar 2007 07:37:41 GMT

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...

Re: select.........upto 1 rows syntax

Former Member — Thu, 22 Mar 2007 07:40:06 GMT

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

Re: select.........upto 1 rows syntax

former_member189631 — Thu, 22 Mar 2007 07:40:13 GMT

narenra,

Use this,

SELECT * FROM TABLE-NAME UP TO 1 ROWS INTO ITAB.

Regards,

Ramganesan K.

Re: select.........upto 1 rows syntax

Former Member — Thu, 22 Mar 2007 07:41:54 GMT

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.