SQL : Select clause

[Former Member]

Hi all..

In open sql, is it impossible..?

Select a~*

into table gt_mara

from mara as a inner join marc as b

~~~

For performance, I want to fetch the fields of table mara. But, while compiling, occur error..

How to do..? What to do..? tell me plz..

Thank you!!

regards..

[Former Member]

Use this :

data : gt_mara like mara OCCURS 0.
Select *
into corresponding fields of table gt_mara
from mara as a inner join marc as b
ON a~matnr = b~matnr.

Ps: Reward points if helpful.

[Former Member]

Hi Kil,

Just an addition to the prev post..

Avoid the "into corresponding fields" for performance reasons... as long as the fields in the internal table are in the same order, use the below clause..

Select *

into table gt_mara

from mara as a inner join marc as b

ON a_{matnr = b}matnr.

Rgds,

Prash.