Does anybody knows why this SELECT is wrong !

[Former Member]

Hi @ll,

I am trying to select two fields and put them in a internal table in which I am looping. If I have only one field e.g. regio it works but not with regio and cityc.

Any idea ?

Thanks

SELECT SINGLE regio cityc INTO i_table-regio

i_table-cityc

FROM t001w

WHERE werks = i_table-werks.

IF sy-subrc = 0.

MODIFY i_table.

ENDIF.

[Former Member]

Hi @ll,

I am trying to select two fields and put them in a internal table in which I am looping. If I have only one field e.g. regio it works but not with regio and cityc.

Any idea ?

Thanks

SELECT SINGLE regio cityc INTO i_table-regio

i_table-cityc

FROM t001w

WHERE werks = i_table-werks.

IF sy-subrc = 0.

MODIFY i_table.

ENDIF.

[ThomasZloch]

try with brackets

> SELECT SINGLE regio cityc INTO (i_table-regio, i_table-cityc)

Thomas

[Former Member]

Thanks Thomas.

Kami