topic Re: how can i do selct without using into.... in Application Development and Automation Discussions

how can i do selct without using into....

Former Member — Wed, 10 Dec 2008 13:24:57 GMT

i am writting a selection in order to know if there is a line in the table according to my conditions and i dont want to use into...

i am writting

select single *

from pa0014

into wa_pa0014 <--- i dont want to this line

where endda......

if sy-subrc eq o .

endif.

thanks.

Re: how can i do selct without using into....

Former Member — Wed, 10 Dec 2008 13:27:02 GMT

Hi,

Check the below code.


Tables : MARA.

select single * from MARA where MATNR = '1234'.

Re: how can i do selct without using into....

Former Member — Wed, 10 Dec 2008 13:27:13 GMT

Hi,

You can skip the "Into......" line and define the DB table pa0014 in the begining of the program as

tables: pa0014.

Thanks

vivekanand

Re: how can i do selct without using into....

former_member203501 — Wed, 10 Dec 2008 13:30:15 GMT

hi you can use it ...if you want to get all the fields from the table ...the table name it self creates a work area .

Re: how can i do selct without using into....

h_senden2 — Wed, 10 Dec 2008 13:30:34 GMT

This is only possible when you define

TABLES: PA0014.

But this is not allowed in ABAP OO.

In fact

SELECT * FROM PA0014 WHERE....

is the same as

SELECT * INTO PA0014 FROM PA0014 WHERE...

So it is a workarea, the same like your WA_PA0014.

What is the problem with the INTO WA_PA0014 part ? YOu don't have to use it.

regards,

Hans

Re: how can i do selct without using into....

JozsefSzikszai — Wed, 10 Dec 2008 13:33:35 GMT

if you really don't need that line, only want to know if it exists or not, than you should use SELECT COUNT( * )

SELECT COUNT( * )
FROM ...
WHERE ...
IF sy-subrc eq 0.
==> line exists
ELSE.
==> line does not exist
ENDIF.

(additionally sy-dbcnt will tell how many such lines exist)

Re: how can i do selct without using into....

ThomasZloch — Wed, 10 Dec 2008 13:34:25 GMT

Maybe you can use SELECT COUNT(*) FROM ... if you just want to know the number of rows matching the WHERE-condition.

Thomas

Re: how can i do selct without using into....

JozsefSzikszai — Thu, 11 Dec 2008 07:46:14 GMT


> You can skip the "Into......" line and define the DB table pa0014 in the begining of the program as
> tables: pa0014.

If anyone still follows: The TABLES statement is obsolate in "traditional" ABAP and prohibited in ABAP Objects (even if points were assigned....)

Re: how can i do selct without using into....

rainer_hbenthal — Thu, 11 Dec 2008 08:01:43 GMT


> If anyone still follows: The TABLES statement is obsolate in "traditional" ABAP and prohibited in ABAP Objects (even if points were assigned....)

In addition: what sense does it make to replace the into clause in that way? The only affect is that i cant see it, but its still there, the data is still transfered, not to the explicit given work area but to the implicit assigned work area.