At change of kunnr delete lines or proceed

Question

I have an itab which has the fields kunnr, bukrs, prodgrp & amound. I have the below lines:

150 1000 adsl  10
150 1000 adsl1 15
150 1000 adsl2 20
150 8000 vdsl  25
150 8000 vdsl1 10
200 1000 adsl1 80
200 1000 adsl2 80

I want to do the following: At the end of each customer sum the amount and if it is less than the amount that put the user in selection screen, delete the lines of itab. If it is bigger leave them. This itab at the end of the program will be displayed. Any idea on how to do it in a quick way?

What have you tried so far? SO is not a write-my-code-for-me service. — vwegert, Oct 16 '17 at 11:28
**TL; DR**: use `AT NEW...END AT` for this task. Your title explicitly suggest this construct. — Suncatcher, Oct 16 '17 at 12:49
Try to use on change of "the_field ... endon inside the loop. — Oguz, Oct 18 '17 at 05:47

score 0 · Answer 1 · answered Oct 16 '17 at 10:50

Instead of deleting in the current itab, I would use a new itab and only add the aggregations that match your condition.

Take a look at this answer showing how to aggregate your data in a new itab, and use your user input threshold (pa_user_threshold) before the append.

IF pa_user_threshold >= lf_sum.
   APPEND ls_agg TO lt_agged.
ENDIF.

At change of kunnr delete lines or proceed

1 Answers1