Skip to Content
0
May 27, 2009 at 12:52 PM

Technique to move data between 2 tables using <FS>

48 Views

Hi,

I am trying to learn the technique for moving data between to tables (and switching the order of name1 and kunnr) using Field Symbols. I have a simple example, but am getting a compile error saying:

i_cm_alv and <x_cm_alv> are type-incompatible.

Here is my code:

TYPES: BEGIN OF tt_cm.

TYPES: kunnr TYPE kna1-kunnr,

name1 TYPE kna1-name1,

vkbur TYPE knvv-vkbur,

konda TYPE knvv-konda,

END OF tt_cm.

TYPES: BEGIN OF tt_cm_alv.

TYPES: name1 TYPE kna1-name1,

kunnr TYPE kna1-kunnr,

vkbur TYPE knvv-vkbur,

konda TYPE knvv-konda,

END OF tt_cm_alv.

DATA: i_cm TYPE TABLE OF tt_cm,

i_cm_alv TYPE TABLE OF tt_cm_alv.

FIELD-SYMBOLS: <x_cm> LIKE LINE OF i_cm,

<x_cm_alv> LIKE LINE OF i_cm_alv.

SELECT

hkunnr hname1 ivkbur ikonda

INTO TABLE i_cm

FROM kna1 AS h

JOIN knvv AS i ON ikunnr = hkunnr.

ASSIGN i_cm_alv TO <x_cm_alv>.

LOOP AT i_cm ASSIGNING <x_cm>.

<x_cm>-kunnr = <x_cm_alv>-kunnr.

<x_cm>-name1 = <x_cm_alv>-name1.

<x_cm>-vkbur = <x_cm_alv>-vkbur.

<x_cm>-konda = <x_cm_alv>-konda.

ENDLOOP.

Any help is greatly appreciated!

Thx,

Andy