Control Break Processing in ABAP Internal Tables

Control break processing is used to execute a piece of code whenever a specific condition in the data is detected during the processing of internal table loop.

The following control break statements are available with in LOOP and ENDLOOP.

  • AT FIRST / ENDAT
  • AT LAST /  ENDAT
  • AT NEW / ENDAT
  • AT END OF / ENDAT
  • SUM
  • ON CHANGE OF / ENDON

The code between AT NEW and ENDAT is executed only during the first loop pass. So it is used to write the headers or some other initialization processing.

The code between AT LAST and ENDAT is executed only during the last loop pass. So it is used to write the totals or some report footers.

*————————————————————–* *Data Declaration *————————————————————–*

DATA: gwa_spfli TYPE spfli.
DATA: gt_spfli  TYPE TABLE OF spfli.

*UP TO 5 ROWS addition selects only 5 rows from table SPFLI

SELECT * UP TO 5 ROWS FROM spfli INTO TABLE gt_spfli.

LOOP AT gt_spfli INTO gwa_spfli.

AT FIRST.

    WRITE:/ 'Start of Loop'.
    WRITE:/ 'Flight Details'.
    WRITE:/ 'Airline Code' COLOR 5,14 'Connection No.' COLOR 5,
         29 'Departure City' COLOR 5, 44 'Arival City' COLOR 5.
    ULINE.

ENDAT.

  WRITE:/ gwa_spfli-carrid,14 gwa_spfli-connid,
       29 gwa_spfli-cityfrom,44 gwa_spfli-cityto.

AT LAST.

    ULINE.
    WRITE:/ 'End of Loop'.

ENDAT.

ENDLOOP.

Output

control-break-it-1

Between AT FIRST and ENDAT the work area will not contain any data. The default key fields are filled with asterisks(*) and the numeric fields are filled with zeros. The ENDAT restores the contents to the values they had prior to entering the AT FIRST. Changes to the work area within AT FIRST and ENDAT are lost. The same applies for AT LAST and ENDAT.

*————————————————————–* *Data Declaration *————————————————————–*

DATA: gwa_spfli TYPE spfli.
DATA: gt_spfli  TYPE TABLE OF spfli.

*UP TO 5 ROWS addition selects only 5 rows from table SPFLI

SELECT * UP TO 5 ROWS FROM spfli INTO TABLE gt_spfli.

LOOP AT gt_spfli INTO gwa_spfli.
  AT FIRST.
    WRITE:/ 'Flight Details'.
    WRITE:/ 'Airline Code' COLOR 5,14 'Connection No.' COLOR 5,
         29 'Departure City' COLOR 5, 44 'Arival City' COLOR 5,
         58 'Distance' COLOR 5.

WRITE:/ gwa_spfli-carrid,14 gwa_spfli-connid, 29 gwa_spfli-cityfrom,44 gwa_spfli-cityto, 58 gwa_spfli-distance.

    ULINE.
  ENDAT.
  WRITE:/ gwa_spfli-carrid,14 gwa_spfli-connid,
       29 gwa_spfli-cityfrom,44 gwa_spfli-cityto,
       58 gwa_spfli-distance.
  AT LAST.
    ULINE.

WRITE:/ gwa_spfli-carrid,14 gwa_spfli-connid, 29 gwa_spfli-cityfrom,44 gwa_spfli-cityto, 58 gwa_spfli-distance.

    WRITE:/ 'End of Loop'.
  ENDAT.
ENDLOOP.

Output

control-break-it-2

AT NEW and ENDAT is used to detect a change in the value of the field between the loop passes. The field that is specified in AT NEW is called control level. The code between AT NEW and ENDAT will be executed during the first loop pass and every time the value of the control level changes or any other field left to the control level changes. Between AT NEW and ENDAT all the fields in the work area that are right to the control level are filled with zeros and asterisks.

Similarly The code between AT END OF and ENDAT will be executed during the last loop pass and every time the value of the control level changes or any other field left to the control level changes.

*————————————————————–* *Data Declaration *————————————————————–*

DATA: gwa_spfli TYPE spfli.
DATA: gt_spfli  TYPE TABLE OF spfli.

SELECT * UP TO 5 ROWS FROM spfli INTO TABLE gt_spfli.

LOOP AT gt_spfli INTO gwa_spfli.
  AT FIRST.
    WRITE:/ 'Flight Details'.
    WRITE:/ 'Airline Code' COLOR 5,14 'Connection No.' COLOR 5,
         29 'Departure City' COLOR 5, 44 'Arival City' COLOR 5,
         58 'Distance' COLOR 5.
    ULINE.
  ENDAT.

AT NEW carrid. WRITE:/ gwa_spfli-carrid, ‘ : New Airline’. ULINE. ENDAT.

  WRITE:/14 gwa_spfli-connid,
       29 gwa_spfli-cityfrom,44 gwa_spfli-cityto,
       58 gwa_spfli-distance.

AT END OF carrid. ULINE. WRITE:/ ‘End of Airline : ‘, gwa_spfli-carrid. ULINE. ENDAT.

  AT LAST.
    WRITE:/ 'End of Loop'.
  ENDAT.
ENDLOOP.

Output

control-break-it-3


3 thoughts on “Control Break Processing in ABAP Internal Tables

  • October 18, 2012 at 5:43 am
    Permalink

    Its fine for beginner,please uplaod also functional modules like MM,FI………….

    Reply
  • June 13, 2013 at 3:25 pm
    Permalink

    i think ”at first” is used to executed only during the first loop pass. So it is used to write the headers or some other initialization processing.

    Reply
  • July 14, 2016 at 3:53 am
    Permalink

    need help my at new executed on every row and not just a new value for CUSTTYPE. Would appreciate if anyone could enlighten me?
    SORT ITABSCUSTOM BY CUSTTYPE ID.

    LOOP AT ITABSCUSTOM INTO WA_ITABSCUSTOM.

    AT FIRST.
    WRITE : / SY-VLINE,
    2 ‘BUSINESS CUSTOMERS’,
    AT LINE_SIZE SY-VLINE.
    ENDAT.

    AT NEW CUSTTYPE.
    WRITE : / SY-VLINE,
    2 ‘PRIVATE CUSTOMERS’,
    AT LINE_SIZE SY-VLINE.
    ENDAT.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *