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.