topic Re: Select without into clause in Application Development and Automation Discussions

Select without into clause

Former Member — Thu, 29 Mar 2007 11:13:12 GMT

Hi gurus!

It is often necessary to know if some entry exists in the database table. There is an addition 'TRANSPORTING NO FIELDS' for read table statement. But I couldn't find something like it for the select statement. Maybe I should use another statement for my requirement?

Thanks in advance.

Re: Select without into clause

Former Member — Thu, 29 Mar 2007 11:16:13 GMT

tables : mara.

select single * from mara where .....

if sy-subrc = 0.

else.

<no>

endif.

regards

shiba dutta

Re: Select without into clause

h_senden2 — Thu, 29 Mar 2007 11:19:03 GMT

i dont think that there is a statement like that.

You can use a SELECT SINGLE or SELECT * UP TO 1 ROWS statement

regards,

Hans

Please reward all helpful answers !!!!!

Re: Select without into clause

Former Member — Thu, 29 Mar 2007 11:20:05 GMT

> tables : mara.

> select single * from mara where .....

> if sy-subrc = 0.

> <record exist>

> else.

> <no>

> endif.

Thanks, but here you declare structure mara, i.e. you use this structure as container for the selection...

Re: Select without into clause

Former Member — Thu, 29 Mar 2007 11:24:17 GMT

that is correct but that is table work area where it should take the value...i think no other options are there to check that.

regards

shiba dutta

Re: Select without into clause

Former Member — Thu, 29 Mar 2007 11:37:08 GMT

Ok. Most likely you are right. But it is still a little bit strange for me why didn't SAP foresee such a request to the database...

p.s. Points were awarded.

Re: Select without into clause

Former Member — Thu, 29 Mar 2007 11:41:51 GMT

Hi Pavel,

Declare the table in the report using TABLES.

example.


TABLES: MARA.

SELECT MATNR FROM MARA WHERE MATNR IN S_MATNR.

for this you do not require any into clause......

Thanks and Regards,

Kunjal Patel

Re: Select without into clause

Former Member — Thu, 29 Mar 2007 11:44:48 GMT

You can use the table itself

REPORT YCHATEST1.

TABLES: MARA.
 
SELECT MATNR FROM MARA into mara-matnr WHERE MATNR IN S_MATNR.