Skip to Content
0
Former Member
Sep 17, 2007 at 09:13 AM

HELP TO MOVING FIELDS FROM TABLES

21 Views

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