topic Re: Code correction in Application Development and Automation Discussions

Code correction

Former Member — Thu, 15 Nov 2007 14:19:02 GMT

Dear All

The following code has Execute but qty,values didnot come

i cheched internal tabel month_total values are stored

why didnot come qty and values

how to come qty and values

my code

loop at month_total.

AT NEW monthcode.

month_total-tmpqty = month_total-tmpqty + month_total-qty.

month_total-tmpval = month_total-tmpval + month_total-val.

write : / month_total-monthcode, month_total-tmpqty, month_total-val.

endat.

endloop.

Thanks and Regards

Suresh

Re: Code correction

naimesh_patel — Thu, 15 Nov 2007 14:21:52 GMT

When you use the AT NEW for perticular field the right fields from that fields becomes * asentrik inside the AT NEW.

So, Do like this:

loop at month_total.
AT NEW monthcode.
  flag = 'X'.
endat.
if flag = 'X'.
  clear flag.
month_total-tmpqty = month_total-tmpqty + month_total-qty.
month_total-tmpval = month_total-tmpval + month_total-val.

write : / month_total-monthcode, month_total-tmpqty, month_total-val.
endif.
endloop.

Regards,

Naimesh Patel

Re: Code correction

Former Member — Thu, 15 Nov 2007 14:23:32 GMT

Suresh,

AT NEW is a control break structure.

You MUST have the internal table sorted by the "control break field" - in your case - monthcode.

Re: Code correction

Former Member — Thu, 15 Nov 2007 14:24:44 GMT

Because when ever you enter in side AT NEW stmt.. you'll be out of LOOP...means all table values will be nullified...

you can check this in debugging...

Thanks

Re: Code correction

Former Member — Thu, 15 Nov 2007 16:14:29 GMT

if you have one record per monthcode you don need the AT NEW STATMENT

if you not try somthing like that

AT NEW monthcode

sum.

month_total-tmpqty = month_total-tmpqty + month_total-qty.

month_total-tmpval = month_total-tmpval + month_total-val.

write : / month_total-monthcode, month_total-tmpqty, month_total-val.

endat.

To get the total of all monthcode records

Message was edited by:

GEORGE TRENTSIOS

Re: Code correction

Former Member — Thu, 15 Nov 2007 16:28:49 GMT

HI,

<b>SORT month_total BY monthcode.</b>

loop at month_total.

AT NEW monthcode.

month_total-tmpqty = month_total-tmpqty + month_total-qty.

month_total-tmpval = month_total-tmpval + month_total-val.

write : / month_total-monthcode, month_total-tmpqty, month_total-val.

endat.

endloop.

rgs

Re: Code correction

Former Member — Thu, 15 Nov 2007 16:47:07 GMT

Hi Suresh,

Modify Internal Table after doing Calculations.

Reward if it helps,

Satish