Select without into clause

[Former Member]

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.

[Former Member]

tables : mara.

select single * from mara where .....

if sy-subrc = 0.

<record exist>

else.

<no>

endif.

regards

shiba dutta

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[h_senden2]

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

[Former Member]

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

[Former Member]

You can use the table itself

REPORT YCHATEST1.

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