HI EXPERTS,
i have two tables and i wont to move fields of price to table ZEMPKOSTLPRICE_REC where dates are match.
<b>I REWARD KINDLY</b>
i give example
table
<b>INTAB_A132[]</b>
resrc datbi datab price
0000010599 <b>20081231 20080401</b> 15000.00
0130130130 <b>20081031 20080301</b> 84000.00
0130130130 <b>20081231 20081101</b> 0.01
table
<b>ZEMPKOSTLPRICE_REC</b>
i wont like that
reserc period price date
0000010599 042008 15000.00 20080401
0000010599 052008 15000.00 20080501
0000010599 062008 15000.00 20080601
0000010599 072008 15000.00 20080701
0000010599 082008 15000.00 20080801
0000010599 092008 15000.00 20080901
0000010599 102008 15000.00 20081001
0000010599 112008 15000.00 20081101
0000010599 122008 15000.00 20081201
0130130130 032008 84000.00 20080301
0130130130 042008 84000.00 20080401
0130130130 052008 84000.00 20080501
0130130130 062008 84000.00 20080601
0130130130 072008 84000.00 20080701
0130130130 082008 84000.00 20080801
0130130130 092008 84000.00 20080901
0130130130 102008 84000.00 20081001
0130130130 112008 0.01 20081101
0130130130 122008 0.01 20081201
this is my code
DESCRIBE TABLE intab_a132 LINES a_index.
IF a_index GE 1.
DO a_index TIMES.
LOOP AT zempkostlprice_rec INTO wa_zem.
READ TABLE intab_a132 INTO wa_intab_a132 INDEX a_index .
IF wa_intab_a132-datab GE wa_zem-date.
IF wa_zem-kbetr IS INITIAL AND wa_zem-konwa IS INITIAL
AND wa_zem-kostl IS INITIAL .
MOVE: wa_intab_a132-kostl TO wa_zem-kostl,
wa_intab_a132-kbetr TO wa_zem-kbetr,
wa_intab_a132-konwa TO wa_zem-konwa.
MODIFY zempkostlprice_rec FROM wa_zem TRANSPORTING kbetr konwa kostl
WHERE resrc = wa_intab_a132-resrc AND date GE wa_intab_a132-datab.
.
CLEAR:wa_zem,wa_intab_a132.
ENDIF.
ENDIF.
ENDLOOP.
a_index = a_index - 1.
ENDDO.
ENDIF.
i try with this code but i get 84.0000 insred 0.01 in month 11 and 12 in 2008
0000010599 042008 15000.00 20080401
0000010599 052008 15000.00 20080501
0000010599 062008 15000.00 20080601
0000010599 072008 15000.00 20080701
0000010599 082008 15000.00 20080801
0000010599 092008 15000.00 20080901
0000010599 102008 15000.00 20081001
0000010599 112008 15000.00 20081101
0000010599 122008 15000.00 20081201
0130130130 032008 84000.00 20080301
0130130130 042008 84000.00 20080401
0130130130 052008 84000.00 20080501
0130130130 062008 84000.00 20080601
0130130130 072008 84000.00 20080701
0130130130 082008 84000.00 20080801
0130130130 092008 84000.00 20080901
0130130130 102008 84000.00 20081001
<b>0130130130 112008 84000.00 20081101<---- insted 0.01
0130130130 122008 84000.00 20081201</b>
REGARDS