topic Re: creating new fields with arithmetic operations in Application Development and Automation Discussions

creating new fields with arithmetic operations

Former Member — Sat, 27 Sep 2008 07:50:57 GMT

data : begin of wa, kunnr type kunnr, end of wa, it like table of wa.

select kunnr into table it from kna1 up to 10 rows.

loop at it into wa. write : / wa-kunnr. endloop.

Here 5 customer numbers are displayed.. i want a another new column with adding 100 to each of customer number which is disaplyed from kna1 table .

can anyone solve my problem with codings..

Regards.

Thiru.

Re: creating new fields with arithmetic operations

Former Member — Sat, 27 Sep 2008 08:03:24 GMT

hi,

try to code like this.

data : begin of wa,

kunnr type kunnr,

v_kun type kunnr,

end of wa.

data it like table of wa.

select kunnr into table it from kna1 up to 10 rows.

loop at it into wa.

v_kun = wa-kunnr + 100.

write : / wa-kunnr, v_kun.

clear: wa, v_kun.

endloop.

hope this will help u.

Re: creating new fields with arithmetic operations

Former Member — Sat, 27 Sep 2008 08:06:55 GMT

Thanks for ur idea, but v_kun has to be decalred as a integer in data statements..

Regards,Thiru

Re: creating new fields with arithmetic operations

Former Member — Sat, 27 Sep 2008 08:29:33 GMT

Hi,

loop at it into wa.

write : / wa-kunnr.

wa-kunnr = wa-kunnr + 100.

write : wa-kunnr.

endloop.

Thanks,

Durai.V

Re: creating new fields with arithmetic operations

Former Member — Sat, 27 Sep 2008 08:29:56 GMT

Changed the above code....little bit....


DATA : BEGIN OF wa,
kunnr TYPE kunnr,
END OF wa,

v_kun TYPE i.

DATA it LIKE TABLE OF wa.

SELECT kunnr INTO TABLE it FROM kna1 UP TO 10 ROWS.

LOOP AT it INTO wa.
  v_kun = wa-kunnr + 100.
  WRITE : / wa-kunnr, v_kun.
  CLEAR: wa, v_kun.
ENDLOOP.

Re: creating new fields with arithmetic operations

Former Member — Sat, 27 Sep 2008 08:44:24 GMT

Hi,

Use this

data : begin of wa,

kunnr type kunnr,

end of wa.

data it like table of wa.

DATA: KUNNR TYPE C,

V_KUNNR TYPE I.

V_KUNNR = KUNNR.

select KUNNR into table it from kna1 up to 10 rows.

loop at it into wa.

v_kunnr = wa-kunnr + 100.

write : / wa-kunnr, V_KUNNR.

clear: wa, v_KUNNR.

endloop.

Hope my answer helps you.

Cheers!!