topic Re: Select Statement without INTO in Application Development and Automation Discussions

Select Statement without INTO

Former Member — Wed, 07 Oct 2009 08:27:12 GMT

Hi,

I notice some standard programs are using select statement without the INTO clause. Why is it possible? Following is an example I found:

SELECT SINGLE *

FROM DFKKKO

WHERE OPBEL = i_dfkkcoh-data1.

{/code}

Re: Select Statement without INTO

Former Member — Wed, 07 Oct 2009 08:29:58 GMT

Hi,

If the report or program already has DFKKKO declared in tables section.

e.g.:- tables DFKKKO.

Then explicit into clause is not required.

It will select the data into workarea.

SELECT SINGLE *

FROM DFKKKO

WHERE OPBEL = i_dfkkcoh-data1.

Re: Select Statement without INTO

Former Member — Wed, 07 Oct 2009 08:30:08 GMT

Hi,

Where ever you find selects without the INTO clause, they must have declared a TABLES statement.

For Eg,


TABLES: DFKKKO.

SELECT SINGLE *
FROM DFKKKO
WHERE OPBEL = i_dfkkcoh-data1.

The tables statement generates a workarea similar to the structure of DFKKKO and will store the result into it directly without the need for specifying the INTO clause

Regards,

Vikranth

Re: Select Statement without INTO

Former Member — Wed, 07 Oct 2009 08:32:04 GMT

It's possible in Native SQl.

Native sql is written using the statement EXEC.