Select Statement without INTO

[Former Member]

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}

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

It's possible in Native SQl.

Native sql is written using the statement EXEC.