topic Re: multiplying a field in Application Development and Automation Discussions

multiplying a field

Former Member — Mon, 04 Feb 2008 05:21:03 GMT

Select all the PRGRP, WERKS, ANTEI and NRMIT from table PGMI based on product group and plant from selection screen store into one internal while storing, Multiply ANTEI = ANTEI * 100 .

can any one tel me how can i multiply antei by 100

Re: multiplying a field

Former Member — Mon, 04 Feb 2008 05:25:23 GMT

Select all the PRGRP, WERKS, ANTEI and NRMIT from table PGMI based on product group and plant from selection screen store into one internal while storing, Multiply ANTEI = ANTEI * 100 .

Loop the ITAB

multiply the ANTEI = ANTEI * 100

endloop.

Narendra

Re: multiplying a field

Former Member — Mon, 04 Feb 2008 05:25:30 GMT

hi,

Use a select query to get all reqd fields in internal table itab.

then use following code.

loop at itab.

itab-antni = itab-antni * 100.

modify itab.

endloop.

Re: multiplying a field

Former Member — Mon, 04 Feb 2008 05:25:33 GMT

loop at itab.

multiply itab-ANTEI by '100'.

modify itab.

endloop.

Cheers,

Will.

Re: multiplying a field

Former Member — Mon, 04 Feb 2008 05:26:01 GMT

After the select statement.

loop at ANTEI = ANTEI * 100 .

ANTEI = ANTEI * 100 .

MODIFY ANTEI = ANTEI * 100 .

ENDLOOP.

Re: multiplying a field

Former Member — Mon, 04 Feb 2008 05:28:56 GMT

Hi,

you can to it in this way too

SELECT F1

into wa from DDT WHERE XYZ.

WA-F1 = WA-F1 * 100.

APPEND wa to itab.

endselect.

Rewards if helpful,

GAURAV J.

Re: multiplying a field

Former Member — Mon, 04 Feb 2008 05:31:04 GMT

select PRGRP, WERKS, ANTEI , NRMIT from pgmi into table t_pgmi where prgrp and werks acording to the selection-screen .

Loop at t_pgmi into wa_pgmi.

wa_pgmi-antei = wa_pgmi-antei * 100.

modify t_pgmi from wa_pgmi transporting antei.

endloop.

Re: multiplying a field

former_member156446 — Mon, 04 Feb 2008 05:38:20 GMT

doing a loop at your internal table is mandatory.. so do it effeciantly..

internal table is itab.

work area of this itab is wa_itab.


field-symbols:<fs_itab> type wa_itab.

loop at itab assigning <fs_itab>.
<fs_itab>-ANTEI = <fs_itab>-ANTEI * 100.
"<<<<<<<<you are eliminating a modify itab statment here..by using <fs>
endloop.

Re: multiplying a field

Former Member — Mon, 04 Feb 2008 06:35:16 GMT

select PRGRP

WERKS

ANTEI

NRMIT

from PGMI

into <internal table>

where <Condition>

if sy-subrc eq 0.

<internal table>-antei = <internal table>-antei * 100

append <internal table>-antei .

endif.

endselect.

LOOP AT <internal table>.

<internal table>-antei = <internal table>-antei * 100.

MODIFY <internal table>FROM <internal table>

TRANSPORTING antei.

ENDLOOP.