HELP IN CODE

Former Member — Tue, 28 Aug 2007 05:31:02 GMT

hallow

i have two tables that i wont to move the data(price/kbetr) from first table INTAB_A132

to table zempkostlprice_rec. in table zempkostlprice_rec i have 2 Colman one is date and resrc.

i give example.

table 1.

INTAB_A132

resrc date kbetr(price)

0000123456 20070101 20.0000

0000123456 20070601 25.0000

the date mean that from 01012007 until 01062007 the price where 20.0000

this is what i have in table right now zempkostlprice_rec and i wont to add price Colman from INTAB_A132

table 2

zempkostlprice_rec

rserc date

1 0000123456 012007

2 0000123456 022007

3 0000123456 032007

4 0000123456 042007

5 0000123456 052007

6 0000123456 062007

7 0000123456 072007

8 0000123456 082007

9 0000123456 092007

10 0000123456 102007

11 0000123456 112007

12 0000123456 122007

13 0000123456 012008

this is what i wont to add price Colman to third table from intab_konp

u can see that price have to be change after 01062007 to 250000

resrc date price

1 0000123456 012007 20000.00

2 0000123456 01022007 20000.00

3 0000123456 01032007 20000.00

4 0000123456 01042007 20000.00

5 0000123456 01052007 20000.00

6 0000123456 01062007 250000.00

7 0000123456 01072007 250000.00

8 0000123456 01082007 250000.00

9 0000123456 01092007 250000.00

10 0000123456 01102007 250000.00

11 0000123456 01112007 250000.00

12 0000123456 01122007 250000.00

13 0000123456 01 012008 250000.00

I TRY WITH THAT CODE BUT I GET JUST PRICE WHERE DATE > 01062007

I WONT ALSO WHEN DATE LESS THEN 01062007 WHERE PRICE 20.00000

(i use the function to change the format of day to be the same format in both table)

LOOP AT zempkostlprice_rec INTO wa_zem.

READ TABLE intab_a132 INTO wa_intab_a132.

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'

EXPORTING

date_external = wa_zem-date

IMPORTING

date_internal = tmp_date.

IF wa_intab_a132-datab LE tmp_date.

MOVE: wa_intab_a132-kbetr TO wa_zem-kbetr.

MODIFY zempkostlprice_rec FROM wa_zem TRANSPORTING kbetr .

CLEAR:wa_zem,wa_intab_a132.

ENDIF.

ENDLOOP.

0000123456 012007 0.00

0000123456 022007 0.00

0000123456 032007 0.00

0000123456 042007 0.00

0000123456 052007 0.00

0000123456 062007 250000.00

0000123456 072007 250000.00

0000123456 082007 250000.00

0000123456 092007 250000.00

0000123456 102007 250000.00

0000123456 112007 250000.

<b>I REWARD</b>

Regards

Re: HELP IN CODE

Former Member — Tue, 28 Aug 2007 05:43:29 GMT

HI S

TRY WITH ELSE AND GE MAYBE IT WILL HELP.

REGARDS

Re: HELP IN CODE

Former Member — Tue, 28 Aug 2007 06:23:00 GMT

hi antonio

i try it already but it not working it bring me in all field 20.0000

Regards

Re: HELP IN CODE

Former Member — Tue, 28 Aug 2007 06:42:23 GMT

plz

some one give me dirction ,

<b>i reward kindly</b>

Regards

Re: HELP IN CODE

Former Member — Tue, 28 Aug 2007 06:43:15 GMT

Hi,

I think 2 internal tables records are same. So use index in both the internal table and comparing the index concatenate it according to ur requirement. hope it will help u out.

topic HELP IN CODE in Application Development and Automation Discussions

HELP IN CODE

Re: HELP IN CODE

Re: HELP IN CODE

Re: HELP IN CODE

Re: HELP IN CODE