topic Loop Question in Application Development and Automation Discussions

Loop Question

Former Member — Wed, 15 Jul 2009 18:44:27 GMT

I have an internal table that I loop through using a WHERE statement. I want to be able to tell if its the last run through the loop. If it is, I want to do some additional code. Currently, I loop through it one time to count the number of times, then I loop again for main functionality. Is there a better way to do this?

Here is what I currently do:

mycount = 0.
LOOP AT mytable INTO mywa WHERE kunnr = currentkunnr.
     mycount = mycount + 1.
ENDLOOP.

LOOP AT mytable INTO mywa WHERE kunnr = currentkunnr.
     IF sy-tabix = mycount.
          <CODE>
     ENDIF.
     <CODE>
ENDLOOP.

Thanks,

Curtis

Re: Loop Question

Former Member — Wed, 15 Jul 2009 18:49:30 GMT

try using At Last.

Loop.

code....

At Last.

Code exclusively tobe done at last one

endat

Endloop.

Re: Loop Question

Former Member — Wed, 15 Jul 2009 20:00:21 GMT

The AT LAST statement will not work when I have a condition on there loop. Are there any other suggestions?

Re: Loop Question

Former Member — Wed, 15 Jul 2009 20:04:28 GMT

Hi ,

Loop at itab.

at last.

endat.

endloop.

at last is the event which is exclusively used for the last record.

Hope this will help you.

Thanks,

Rajesh.

Re: Loop Question

Former Member — Wed, 15 Jul 2009 23:15:52 GMT

You could find out the number of lines in the table first.

DATA: I_TABLE LIKE ZTABLE OCCURS 0 WITH HEADER LINE,

V_LINES TYPE I.

DESCRIBE TABLE I_TABLE LINES V_LINES.

LOOP AT I_TABLE WHERE VALUE = CONDITION.

IF SY-TABIX = V_LINES.

ADDITIONAL CODE HERE

ENDIF.

ENDLOOP.

Re: Loop Question

venkat_o — Thu, 16 Jul 2009 02:10:51 GMT

Hi Davis, Try this way.


REPORT  ztest_notepad.
DATA: BEGIN OF it_nfal OCCURS 0,
        einri TYPE nfal-einri,
        falnr TYPE nfal-falnr,
        falar TYPE nfal-falar,
        patnr TYPE nfal-patnr,
      END OF it_nfal.

START-OF-SELECTION.
  SELECT *
  FROM nfal
  INTO CORRESPONDING FIELDS OF TABLE it_nfal
  UP TO 10000 ROWS.
  "Sort internal table by key field which is used in Where condition.  
  SORT it_nfal BY einri.
  LOOP AT it_nfal WHERE einri = 'CGH'.
    "It is triggered when it reaches last value.
    AT END OF einri.
      WRITE 'Test this'.
    ENDAT.
  ENDLOOP.

Thanks Venkat.O

Re: Loop Question

Former Member — Thu, 16 Jul 2009 03:16:32 GMT

Try AT END <Field>

This will compare the value of your current record with your next record in the itab. Then, if the next record value in that field is different, this AT END will trigger. Insert your coding here.

Hope this is what you are looking for.

Thanks

Kiran

Re: Loop Question

faisalatsap — Thu, 16 Jul 2009 03:23:59 GMT

Hi, Davis

Please use Meaningful Subject Line for next time, Please

Regards,

Faisal