Skip to Content
0
Former Member
Sep 10, 2007 at 02:18 PM

help to moving data from one table to other

19 Views

hallow

i ahve to fill data from one table to another i first table i have 3 field with kostl

perod and days

and in table that i have to fill i have field for kostl and one field for each month

and i have to fill it from gt_miss_data table

<b>i reward</b>

i give the data

gt_miss_data

kostl period days

10-101 200701 532

10-101 200702 456

10-101 200703 503

10-101 200704 453

10-101 200705 522

10-101 200706 500

10-111 200701 23

10-111 200702 20

10-111 200703 21

10-111 200704 19

10-111 200705 22

<b>

this is what i wont</b>

ccmissdays table

kostl m01 m02 m03 m04 m05 m06 m07 ......total

10-101 532 456 503 453 522 500 2966

10-111 23 20 21 19 22 105

i try with that code but its not working well

LOOP AT gt_miss_data ASSIGNING <gt_miss_data>.

AT NEW kostl.

MOVE <gt_miss_data>-kostl TO ccmissdays-kostl.

CASE <gt_miss_data>-period+4(2).

WHEN '01'.

MOVE <gt_miss_data>-miss_days TO ccmissdays-m01.

WHEN '02'.

MOVE <gt_miss_data>-miss_days TO ccmissdays-m02.

WHEN '03'.

MOVE <gt_miss_data>-miss_days TO ccmissdays-m03.

WHEN '04'.

MOVE <gt_miss_data>-miss_days TO ccmissdaysm-04.

WHEN '05'.

WHEN OTHERS.

ENDCASE.

APPEND ccmissdays.

ENDAT.

ENDLOOP.