topic Re: AT END PROBLEM--HELP in Application Development and Automation Discussions

AT END PROBLEM--HELP

Former Member — Wed, 18 Apr 2007 09:17:47 GMT

WHAT IS WRONG

LOOP AT g_tab ASSIGNING <out>.

sum_open = <out>-zsum_open + sum_open.

AT END OF prctr.

ITAB1-PRCTR = <out>-prctr.

itab1-zsum_open = sum_open.

APPEND itab1.

CLEAR sum_open.

ENDAT.

ENDLOOP.

it's work but dont make at end statment

i have 3 kind of prctr

and i need to get 3 lines

i get 100 instead

Re: AT END PROBLEM--HELP

Former Member — Wed, 18 Apr 2007 09:19:03 GMT

i made sort before

Re: AT END PROBLEM--HELP

Former Member — Wed, 18 Apr 2007 09:19:51 GMT

Is the prctr is first field in tab? just check out the same.

Thanks

Sandeep

Re: AT END PROBLEM--HELP

Former Member — Wed, 18 Apr 2007 09:21:23 GMT

The pre requisite is that the PRCTR field must be the first as sandeep already pointed out.

Regards,

ravi

Re: AT END PROBLEM--HELP

Former Member — Wed, 18 Apr 2007 09:21:40 GMT

Hi,

what is your purpose?

do you wants to display the SUMS on the basis of Profit centers.

then use this. first Sort by prctr.

then use SUM between AT end..endat.

<b>sort g_tab by prctr.</b>

LOOP AT g_tab ASSIGNING <out>.

sum_open = <out>-zsum_open + sum_open.

AT END OF prctr.

read table g_tab index sy-tabix.

SUM.

ITAB1-PRCTR = <out>-prctr.

itab1-zsum_open = sum_open.

APPEND itab1.

CLEAR sum_open.

ENDAT.

ENDLOOP.

reward if useful

regards,

ANJI

Re: AT END PROBLEM--HELP

Former Member — Wed, 18 Apr 2007 09:22:48 GMT

Sort the itab with the prctr and make the prctr as the first field in your internal table.

hope it will clear ur doubt

regards

ravish

<b>plz dont forget to reward points if helpful</b>

Re: AT END PROBLEM--HELP

Former Member — Wed, 18 Apr 2007 09:23:34 GMT

Hi Liat,

The important fact that you should consider while using AT NEW AT ENDand ON CHANGE OF is while using AT NEW/AT END you should make the FIELD which you are checking as the first field of internal table , other wise if any of the fields which is in the left of the field that you are putting at "ATNEW/ END" changes it will get triggered.So u wont get the expected result

But ON CHANGE will only check that particular field and it can be at anywhere in the internal table

Regards

Avi

Re: AT END PROBLEM--HELP

Former Member — Wed, 18 Apr 2007 09:23:47 GMT

Hi,

Try to do like this.

SORT by PRCTR.

LOOP AT i_prctr_amt INTO wa_prctr_amt.

AT END OF prctr.

SUM.

wa_prctr_sum-prctr = wa_prctr_amt-prctr.

wa_prctr_sum-wrbtr = wa_prctr_amt-wrbtr.

APPEND wa_prctr_sum TO i_prctr_sum.

ENDAT.

CLEAR :wa_prctr_sum,

wa_prctr_amt.

ENDLOOP.

Regards,

-->Suresh

Re: AT END PROBLEM--HELP

Former Member — Wed, 18 Apr 2007 09:28:11 GMT

i get erryou canot make sum at assiging

what the prob

Re: AT END PROBLEM--HELP

Former Member — Wed, 18 Apr 2007 09:37:04 GMT

i tried to make it wa

and i get dump

Re: AT END PROBLEM--HELP

former_member491305 — Wed, 18 Apr 2007 10:28:45 GMT

Hi,

What dump you are getting?

Regards,

Vigneswaran S